Modifying several worksheets simultaneously
 

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.

Modifying several worksheets simultaneously
 

Press Ctrl and select the required sheets
--
If this post helps click Yes
---------------
Jacob Skaria


"dollsbears etc" wrote:

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.

Modifying several worksheets simultaneously
 

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.

--
Regards,

OssieMac


"Jacob Skaria" wrote:

Press Ctrl and select the required sheets
--
If this post helps click Yes
---------------
Jacob Skaria


"dollsbears etc" wrote:

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.

Modifying several worksheets simultaneously
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dollsbears etc" wrote:

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.

Modifying several worksheets simultaneously
 

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)
--
Ken
"Started with Visicalc in 82"