| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy-paste started misbehaving (cell reference wrong)
I have Excel 2003 SP2
Usually if enter a formula like =B3-B2 into a cell, and copy and paste it, I got relative reference in the destination, e.g. cell below would become B4-B3 Now when I paste, every cell gets =B3-B2, therefore the same value. I tried selecting the source cell and pressing F4 key to cycle through absolute and relative reference - that didn't help. I am using control-c control-v not paste special. Fortunately I have Open Office as well to get me out of a pickle, but I wish to know: What has happened to Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy-paste started misbehaving (cell reference wrong)
Most likely you have the calculations set to manual, what happens if you
press F9? Toolsoptionscalculation, change to automatic is where to change it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) wrote in message ups.com... I have Excel 2003 SP2 Usually if enter a formula like =B3-B2 into a cell, and copy and paste it, I got relative reference in the destination, e.g. cell below would become B4-B3 Now when I paste, every cell gets =B3-B2, therefore the same value. I tried selecting the source cell and pressing F4 key to cycle through absolute and relative reference - that didn't help. I am using control-c control-v not paste special. Fortunately I have Open Office as well to get me out of a pickle, but I wish to know: What has happened to Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
| how to paste formula but reference a fixed cell | Excel Discussion (Misc queries) | |||
| Copy from one worksheet to another is inserted into wrong cell | Excel Discussion (Misc queries) | |||
| Reference an identical cell on a different page using copy/paste? | Excel Worksheet Functions | |||
| copy/paste from one file to another without file name reference | Excel Discussion (Misc queries) | |||
Hybrid Mode
