View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
juliejg1 juliejg1 is offline
external usenet poster
 
Posts: 81
Default Moving cells without changing their 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?