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.
 
You must log in or register to reply here.

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

Similar Threads

Retrieve information from one workbook to another 1
Start sheet in a workbook 2
Reference to sheet name in another workbook 3
Can I group or link sheets in seperate workbooks? 1
Excel, assign cells in multiple worksheets from one sheet 1
Need a Macro to combine 1-5 sheets in one sheet 1
Sharing workbooks limitations - Merged Cells 12
Copy sheet to different workbook sizing error message 2

Back
Top