MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I move a group of cells and formulas?

Posted by dalton on February 15, 2002 10:45 PM

I have a 12 spreadsheets representating the twelve months of the year and I need to move a group of cells and their formulas to a different part of the Jan sheet.
I would like to have that move also take place on the other 11 sheets. What would be the easiest way to do that?

Posted by Andy Gee on February 16, 2002 3:48 AM

Re: How to move a group of cells and formulas?

Make a backup.

If the cells are in the same relative location on each sheet, simply click the first sheet tab (jan?), hold shift and click the last tab (dec?). Move the cells by selecting them, pressing control+x (cut). Select the destination (top left cell) and press control+v (paste). Make sure it all works and then save