Information on sheet 1 to make changes in all sheets of workbook

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I have a workbook with monthly sheet tabs. Column A is a
listing of clients. How can I insert rows into sheet 1
(Jan) that will adjust all other sheets in workbook the
same?
 
Hi Sharon

Click on the first tab and hold down the shift button and click on the last
tab. All the tabs will shoe white, indictaing they are grouped.
Insert your rows on sheet 1, and the operation will be repated across all
sheets that are grouped.

Click on any individual sheet tab afterwards to ungroup them.
 
Back
Top