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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving cells without changing the formulas
Highlight the 25 columns, then CTRL-H (Find & Replace):
Find What: = Replace With: xyz= click Replace all This will have changed all the formulae to text strings, so now you can delete columns A to V. Then highlight all 25 columns again, and CTRL-H: Find What: xyz= Replace With: = click Replace all This should now change all the text strings back to formulae, with the original references unchanged. Hope this helps. Pete On Dec 18, 2:07 pm, juliejg1 wrote: 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? |
Reply |
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) |