higlighting worksheets

[emilr17]

I have a group of 70 worksheets. I want to apply a change to about 50 of
them that are in the middle. Is there a way of higlighting or selecting which
worksheets I want to apply the change to?

 

[M Kan]

You can hold down CTRL and then pick multiple worksheets or hold down SHIFT
and select your two end points, which will select everything in between.

Once you have multiple sheets selected, any formatting changes or new
information entered in one sheet (e.g., date, row/column insertions, etc)
will be applied to all sheets, so be careful.

 

[Bernard Liengme]

Use Help to lean about "grouping"
The entry in XL2003 is called: Select one or multiple worksheets
best wishes

 

[Max]

Just a precaution .. Remember to *ungroup* after you've done all the work on
the grouped sheets. Right-click on any grouped sheet > Ungroup Sheets.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik