Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheets equaling other worksheets | Excel Worksheet Functions | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |