| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute cell reference A spreadsheet cell reference that does no
help
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
absolute cell reference A spreadsheet cell reference that does no
Well help with what!?
Enter your question in the Body of the message instead of the Subject line. Your question got cut off!! Do you just want to use an absolute reference? If so enter $'s around your cell reference: $A$1 -or- $A1 -or- A$1 A $ preceding the column reference ensures the column letter doesn't change. A $ preceding the row reference ensures the row number doesn't change. Does that help? -- Regards, Dave "help" wrote: help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions | |||
Linear Mode
