Multiple Sheet Selections in MS Excel

Dennis Faas's picture

Many times you make the same changes to multiple sheets in an Excel Workbook. Perhaps you would like to change the column widths or apply special formatting to a range of cells in several sheets.

Creating a group of selected sheets allows you to perform the task just once, thereby saving time and narrowing the margin for errors.

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 everything you do to the current sheet, Excel also does to 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 canceling 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.

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!

Rate this article: 
No votes yet