View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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.