higlighting worksheets
 

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?

higlighting worksheets
 

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.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"emilr17" wrote:

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?

higlighting worksheets
 

Use Help to lean about "grouping"
The entry in XL2003 is called: Select one or multiple worksheets
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"emilr17" wrote in message
...
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?

higlighting worksheets
 

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
---
"emilr17" wrote:
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?