Results 1 to 2 of 2
Thread: Paste Special / Formulas (XL97)
2002-01-29, 10:49 #1
- Join Date
- Sep 2001
- Blue Springs, Missouri, USA
- Thanked 0 Times in 0 Posts
Paste Special / Formulas (XL97)
Maybe I am missing something... I have a rather large spreadsheet that I want to copy the formulas from and put them on a new spreadsheet. I highlight the whole spreadsheet (button in upper left corner) and then right click in the spreadsheet and select "Copy." I then select my next entire worksheet and right click in the worksheet and do Paste Special / Formulas. However... Excel pastes formulas AND values. Is this normal or is there something set that I am missing that would cause this? I can provide an example if it would be helpful. Thanx In Advance.
2002-01-29, 12:08 #2
- Join Date
- Mar 2001
- Springfield, Ohio, USA
- Thanked 2 Times in 2 Posts
Re: Paste Special / Formulas (XL97)
Dennis, for the purposes of paste special formulas, Excel considers a formula to be whatever you have entered into the cells, both constants and formulas. For paste special values, it is what you see on the sheet, ie the constants and evaluated formulas as you have them formatted.
If you really want to just copy the formulas, do the copy & paste special formulas just as you said. Then while the new cells are still selected, do an Edit | GoTo | Special | Constants, and press the delete key to clear the contents of these cells.
Another tip, while these newly cleared cells are selected, you can enter data with the Enter or Tab key and Excel will navigate to the next selected cell. You can even enter the same constant in every cell by typing the constant and then pressing <Ctrl><Enter> HTH --Sam<font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
<small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>