| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I anchor a cell/create absolute ref. while clicking on it?
I know that I can manually go in to a formula and put a "$" to anchor a cell
(i.e., create an absolute reference), but I remember there being a way that I could use a key stroke while clicking on the cell that I want to anchor. Thanks for your help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I anchor a cell/create absolute ref. while clicking on it?
The F4 key cycles through
complete absolute, absolute row relative column relative row absolute column complete relative "dsapan" wrote: I know that I can manually go in to a formula and put a "$" to anchor a cell (i.e., create an absolute reference), but I remember there being a way that I could use a key stroke while clicking on the cell that I want to anchor. Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to underline by clicking on text? | Excel Discussion (Misc queries) | |||
| Convert displayed number to absolute value | Excel Discussion (Misc queries) | |||
| Making multiple cells absolute at once | Excel Discussion (Misc queries) | |||
| replace absolute references | Excel Worksheet Functions | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Hybrid Mode
