Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 deleting columns and maintaining references
I have a spreadsheet with columns (U & V) that calculates percentages & sums
from columns H thru T . The data in columns N thru T is old data (previous year's data). I would like to delete columns N thru T and have the formulas (in columns U & V) now refer to columns A - M without loosing the references. Of course, with the deletion of columns N thru T, the "calculating" columns (previously U & V) become columns N & O. Is there a way to do this without loosing the cell references in the "calculating" columns so that I don't have to go back and reset the formulas? I've tried using absolute cell references without success. Any guidance on how I can accomplish this would be very much appreciated. Jack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting MS JET OLE DB references in an Excel 2003 file | Excel Discussion (Misc queries) | |||
Sorting multiple columns and maintaining grouping of information | Excel Discussion (Misc queries) | |||
Maintaining numerical order when deleting row | Excel Discussion (Misc queries) | |||
Pivot Table - Deleting data rows while maintaining them in the tot | Excel Worksheet Functions | |||
Maintaining cell references when inserting cells elsewhere | Excel Discussion (Misc queries) |