| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all formulae in a worksheet from absolute to relative
When I am building a worksheet, I use $ a lot to permit copying. After I am
satisfied with the result, I want to convert all the formulas from absolue to relative. But the only way I know to do it is one cell at a time. Isn't there an easier way? -- Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cells from Relative to Absolute Reference | Excel Discussion (Misc queries) | |||
| Changing formulas from relative to absolute | Excel Discussion (Misc queries) | |||
| Changing relative to absolute for a column | Excel Worksheet Functions | |||
| changing relative to absolute | Excel Discussion (Misc queries) | |||
| Formula - relative or absolute ref, keeps changing | New Users to Excel | |||
Threaded Mode
