Search

How to select all worksheets to Excel group

 

If your Excel workbook contains too many worksheets, selecting all worksheets to Group is not easy. To select all worksheets to Excel workbook, follow any of below methods.

1 - Right-click any worksheet Tab and click "Select All Sheets" from menu

To select all worksheets to Group edit mode, right-click any worksheet Tab and click "Select All Sheets" from the menu.

Select All Worksheets to Group

You can see that all worksheets are selected to Group, as shown in below image. White-colored Tabs are the worksheets in the Group. Note that all are white-colored Tabs.

All Worksheets are selected to Group

2 - Press "Ctrl", "Shift" and "Page Down" keys together.

Another easy way to select all worksheets is by selecting the first worksheet Tab by clicking on it, and then pressing "Ctrl", "Shift" and "Page Down" keys together. You need to press "Ctrl", "Shift" and "Page Down" keys together repeatedly until all worksheets are added to Group. By pressing "Ctrl", "Shift" and "Page Down" keys together, worksheets are selected one by one. But it is more easier than selecting individual worksheets in Excel workbook.

3 - Using "Shift" key and mouse click.

Select the first worksheet Tab by clicking on it and then press and hold "Shift" key. Scroll to the last worksheet Tab by using worksheet Tab scroll arrows and click on the last worksheet Tab. All the worksheets from first worksheet Tab to the last worksheet Tab are selected to Group.

 

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• How to change the Column width in Excel worksheet
• Excel AutoFit Column Width
• How to hide or unhide Rows in Excel worksheet
• How to hide or unhide Columns in Excel worksheet
• Maximum rows and columns in Excel Worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Examples of Range Addresses in Excel worksheet
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• How to select Multiple Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to change the default font and size in Excel
• How to Move or Copy entire worksheet within an Excel workbook
• How to Move or Copy entire worksheet to another Excel workbook