| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formulas displaying wrong value
I'm copying formulas in excel, but the value of the original cell I copied
appears in all of the 'pasted' cells. However, when I select one of the 'pasted' cells, the copied formula appears in the formula bar. Therefore, the formula is in the cell, but displaying the wrong value (the one of the original 'copied' cell). Only after I double-click the 'pasted' cells (one-by-one), does the formula update to display the correct value. Any ideas of how to get rid of this? It started after I accidentally messed around with 'sticky' keys (appears when hitting the shift key 5 times). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| displaying a formula's answer into a separate cell | Excel Worksheet Functions | |||
| Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
| Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
| copy worksheet with formulas but not data | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Threaded Mode
