Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic absolute formulas
Using absolute formulas allows you to copy and paste formulas from one cell
to another so that the new cell shows the same value as the cell that had the formula in originally. By putting a $ sign before the letter and number of the cell reference does this. Is there any way that when you create the formula in the first instance it can be done as an absolute formula? ie, when I select the function box, and say for instance create an =sum formula, the formula will be created as (eg) =sum(c2:c20) is there any way I get the formula to create as =sum($c$2:$c$20) without having to manually putting in the $ signs. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formulas to cells absolute rows and variable columns | Excel Discussion (Misc queries) | |||
Automatically making formulas "Absolute" or "$ Relative" | Excel Discussion (Misc queries) | |||
Worksheet doesn't permit F4 absolute referencing tool in formulas | Excel Discussion (Misc queries) | |||
Automatic linewrap with formulas displayed | Excel Worksheet Functions | |||
Automatic Sequential renumbering within formulas | Excel Worksheet Functions |