Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute value with a quick formula / shortcut?
Is there a way to have the absolute value be in your excel formula besides
going back into the formula and putting in the $ signs? I am looking for a way when I type = then click on a cell - say A1 to have the formula be =$A$1 rather than=A1 and having to edit the formula Any suggestions - is there a shortcut key for this maybe? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute value with a quick formula / shortcut?
Not sure it's much of a shortcut....
In the formula bar you can highlight the cell/range references and then hit function key F4 and the references will toggle from absolute to mixed to relative. -- Biff Microsoft Excel MVP "Derek" wrote in message ... Is there a way to have the absolute value be in your excel formula besides going back into the formula and putting in the $ signs? I am looking for a way when I type = then click on a cell - say A1 to have the formula be =$A$1 rather than=A1 and having to edit the formula Any suggestions - is there a shortcut key for this maybe? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute value with a quick formula / shortcut?
As you enter, select cell address with mouse in formula bar and hit F4 key to
toggle through the options. i.e. =a2 select the a2 and F4 then * a3 select the a3 and F4 then ENTER will give you =$A$2*$A$3 or whatever you chose by cycling through the options. Or do the F4 on the entire formula after Entering it. Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 10:40:01 -0700, Derek wrote: Is there a way to have the absolute value be in your excel formula besides going back into the formula and putting in the $ signs? I am looking for a way when I type = then click on a cell - say A1 to have the formula be =$A$1 rather than=A1 and having to edit the formula Any suggestions - is there a shortcut key for this maybe? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Absolute value with a quick formula / shortcut?
To expand a bit on the other suggestions....
After you click on a cell to add it to your formula, press F4 immediately after; you do not need to highlight the cell name. This will change the relative reference to an absolute reference as you described. (Pressing F4 more than once will step through the various combinations of absolute and relative references for the row and column.) Mark Lincoln On Sep 27, 1:40 pm, Derek wrote: Is there a way to have the absolute value be in your excel formula besides going back into the formula and putting in the $ signs? I am looking for a way when I type = then click on a cell - say A1 to have the formula be =$A$1 rather than=A1 and having to edit the formula Any suggestions - is there a shortcut key for this maybe? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an absolute reference shortcut? | Excel Discussion (Misc queries) | |||
Used Quick Lanch and no shortcut Bar for Excel came up What now | Excel Worksheet Functions | |||
Shortcut Keys -- quick find | Excel Discussion (Misc queries) | |||
Quick method to add absolute references in Excel using keyboard | Excel Discussion (Misc queries) | |||
Is there a quick shortcut to swap the data in two cells? | Excel Discussion (Misc queries) |