| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I anchor a cell reference?
To greatly simplify this, cell A1 says "=B1" and cell A2 says "=A1"
If I move cell B1 to cell C1, cell A1 now says "=C1" and of course, cell A2=cell A1 Next problem... if i move data into cell B1, cell A1 gives me a #REF! How can I anchor the reference in cell A1 to always say "=B1"? How can I move data into a referenced cell without getting a #REF!? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Cell reference problem | Excel Worksheet Functions | |||
| how to include a cell reference that is contained in a cell withi. | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Threaded Mode
