Moving columns in multiple worksheets

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?
 
K

Ken Wright

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.
 
J

JS

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top