Moving columns in multiple worksheets

  • Thread starter Thread starter Eugene
  • Start date Start date
E

Eugene

I've got a workbook that has 5 worksheets in it. Each
worksheet has the exact same structure. Columns A thru X
are used. What I need to do is move columns U,V and W
between C and D. Is there a way to do the column move in
all 5 worksheets without having to do 5 individual tasks?
 
Group the sheets before you do it. Click on the first, hold down shift and then click on the last
sheet. Now do your moves. Don't forget to ungroup when you are done, either by clicking on a
single tab somewhere, or right clicking on a tab and selecting ungroup.
 
If all worksheets have exactly the same structure click on the first work
sheet, hold down shift and click on the last worksheet - this will group all
the sheets. You can them make the changes you want in one sheet and they
will be applied to all sheets.
 
Back
Top