insert a row on ALL sheets

B

bw

I have a spreadsheet with 12 sheets in it, one for each
month of the year. Is there a way to insert a row on all
12 sheets at once or do I have to go into each sheet and
insert the row one at a time? In other words, do I have to
do it 12 times or is there a way to do it only once and
have it affect all 12 sheets?

Thanks,
BW
 
P

Paul

bw said:
I have a spreadsheet with 12 sheets in it, one for each
month of the year. Is there a way to insert a row on all
12 sheets at once or do I have to go into each sheet and
insert the row one at a time? In other words, do I have to
do it 12 times or is there a way to do it only once and
have it affect all 12 sheets?

Thanks,
BW
Click to expand...

Group the worksheets: Click the tab of the first, then hold down SHIFT
whilst clicking the tab of the last. Or, hold down CTRL whilst clicking
individual tabs to toggle them into, or out of, the group.
Then whatever you do to one (such as inserting a row) will be done to them
all.
Don't forget to ungroup immediately afterwards!!! (Right click a tab and use
Ungroup Sheets.)
 
T

Tracey

Select each sheet tab at the bottom of the screen (in your
case click on all the month tabs) make sure they are all
highlighted and insert your rows. Just make sure that you
unselect before you make any other changes.

Good luck.
Tracey
 
Top