Modifying several worksheets simultaneously

  • Thread starter Thread starter dollsbears etc
  • Start date Start date
D

dollsbears etc

When one right clicks on a worksheet tab name, there is the option "Select
all sheets".

Is there the option to select only some of the work sheets in a workbook, so
that only those selected are modified simultaneously?

For example, if an entry was made into cell t58 on one of the selected work
sheets, cell t58 would be modified on all of the selected work sheets.
However, cell t58 would not be modified in those worksheets not selected.
 
Also if you select one worksheet tab then hold the Shift key and select
another worksheet tab then all worksheets in between the two are selected.
 
Hi,

You can select adjacent tab by holding down the Shift key and pressing
Ctrl+PgUp or Ctrl+PgDn as many times as you want to.
 
Pretty useful feature but beware that you ungroup the sheets when you no
longer want to make universal changes. You can do a lot of damage very
quickly.
(either select a sheet outside of the group or right click on the sheet tab
and select ungroup)
 
Back
Top