Modifying several worksheets simultaneously

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.
 
O

OssieMac

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.
 
S

Shane Devenshire

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.
 
K

K_Macd

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)
 

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

Top