Multiple Sheet Selections in MS Excel
- by Carol Bratt on 20071112 @ 12:30AM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: sheet tab, multi-sheet selection, shift, ctrl, task)
Perhaps you would like to change the column widths or apply special formatting to a range of cells in several sheets of Excel Workbook. It's a real pain to have to make the same changes separately to each sheet.
There are several ways to select several sheets to create a multi-sheet selection.
To select contiguous sheets, follow the steps below:
- Click a sheet tab.
- Click Shift and keep it depressed while clicking a second sheet tab.
Excel will select both clicked sheets and all the sheets in between. To select non-contiguous sheets follow the steps below:
- Click CTRL and keep it depressed while clicking sheet tabs.
- Excel will select all of the clicked sheets.
To select all sheets, follow the steps below:
- Right-click a sheet tab and select Select All Sheets.
To select the current sheet and the previous sheet:
- Click Shift + Ctrl + Page Up.
To select the current sheet and the following sheet:
- Click Shift + Ctrl + Page Down.
Errors occur when you forget that you're working with a multi-sheet selection. Be mindful that when you do something to the current sheet, Excel repeats for every sheet in the selection.
If you make changes to a selection of sheets when you meant to change only the current sheet, you may have a lot of damage to repair.
You can avoid mayhem by cancelling a multi-sheet selection task as soon as you complete your multi-sheet tasks.
To do so:
- Click an unselected sheet or right-click a selected sheet tab and choose Ungroup Sheets.
Something else you didn't know about Excel, huh?
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
