Moving cells without changing the formulas

  • Thread starter Thread starter juliejg1
  • Start date Start date
J

juliejg1

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?
 
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
 
Back
Top