| 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? |
| 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) | |||
Threaded Mode
