| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the key shortcut for absolute cell reference?
When selecting a cell to enter into a formula, there is a key or key
combination that will automatically make the cell an absolute cell reference when you point-and-click. You can also highlight the cell reference in the formula and use the shortcut to make it an absolute cell reference. This saves typing the "$" sign. Help! I can't remember it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the key shortcut for absolute cell reference?
F4 !!
Regards, Alan. "RM in Augusta" <RM in wrote in message ... When selecting a cell to enter into a formula, there is a key or key combination that will automatically make the cell an absolute cell reference when you point-and-click. You can also highlight the cell reference in the formula and use the shortcut to make it an absolute cell reference. This saves typing the "$" sign. Help! I can't remember it. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the key shortcut for absolute cell reference?
F4 will cycle you through the options. eg: Type A2 -- A2 F4 -- $A$2 F4 -- $A2 F4 -- A$2 F4 -- A2 (The order might be different for the two half-absolutes) RM in Augusta wrote: When selecting a cell to enter into a formula, there is a key or key combination that will automatically make the cell an absolute cell reference when you point-and-click. You can also highlight the cell reference in the formula and use the shortcut to make it an absolute cell reference. This saves typing the "$" sign. Help! I can't remember it. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the key shortcut for absolute cell reference?
F4 will cycle through the cell references for you.
"RM in Augusta" wrote: When selecting a cell to enter into a formula, there is a key or key combination that will automatically make the cell an absolute cell reference when you point-and-click. You can also highlight the cell reference in the formula and use the shortcut to make it an absolute cell reference. This saves typing the "$" sign. Help! I can't remember it. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What is the key shortcut for absolute cell reference?
try checking help, keyboard shortcuts, select data?
"RM in Augusta" wrote: When selecting a cell to enter into a formula, there is a key or key combination that will automatically make the cell an absolute cell reference when you point-and-click. You can also highlight the cell reference in the formula and use the shortcut to make it an absolute cell reference. This saves typing the "$" sign. Help! I can't remember it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Cell Color From Other WorkSheets | Excel Worksheet Functions | |||
| How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Cell Reference Math | Excel Worksheet Functions | |||
Hybrid Mode
