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) |