higlighting worksheets

E

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

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

Bernard Liengme

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