| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing relative to absolute
Hello
I have a lot of functions in which there are relatative reference ranges, is there a n easier way change them to absolute other than selecting each cell individually and hitting F4?. Like can I select a range of cells and press a button and those cells change to absolute |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| Absolute vs Relative path | Excel Discussion (Misc queries) | |||
| changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
| How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions | |||
Threaded Mode
