Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving cells without changing the formulas
I have a spreadsheet with numerous columns of formulas. I had to take out
the columns A-V which left about 25 columns with formulas. I would like to move the remaining columns to start in column A but do not want to have to go through all of the formulas and change their references. The formulas are quite lengthy and have only some absolute references and also reference other worksheets. Is there a way to delete columns A-V without the remaining formulas changing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
Moving Changing data to new tab in workbook | Excel Worksheet Functions | |||
Moving formulas | Excel Worksheet Functions | |||
pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) |