Changes to Mulitple Worksheets

M

Mac Landers

If I have a workbook with multiple worksheets that all have the same format
just didn't products and numbers, is there a way to apply a change to one
worksheet and it will change in all of the other worksheets? Is there one
easy step instead of manually updating each worksheet?
 
M

Mac Landers

If you highlight all of the worksheets (click on the 1st one and then hit
control and click on the other worksheets you wish to change) it is called
"Grouping." Once you make a change to the 1st spreadsheet it changes the
rest. Right click on any of the tabs to "Ungroup Sheets" after you are done.
 

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

Embed the same Excel multiple times 0
Visio to Excel 0
Syncing between source worksheet and dependent worksheets 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
How to update a value from a linked worksheet back to the master worksheet? 0
Editing an "IF" function across a worksheet/excel file 2
Tracked changes by multiple people modified to one 0

Top