Excel allows you to work on several worksheets simultaneously by grouping them together. When worksheets are grouped, any formatting, data entry or changes you make to the active sheet are made to every sheet in the group. Grouping sheets is a quick way to apply formatting to or delete several sheets at once. When multiple worksheets are grouped together, [Group] appears in the title bar on top of the worksheet window.
To Group Worksheets
- Click the tab of the first worksheet in your group.
- Hold down the Ctrl key and then click the tabs of any additional sheets you want to include in your group.
- To group all worksheets, right-click on any worksheet tab and choose Select All Sheets from contextual menu.
To Ungroup Worksheets
- Click the tab of any worksheet not in your group
- Or
- Right-click the tab of any grouped worksheet and select Ungroup Sheets from the pop-up menu.
Similar Posts:
- Using 3-D Formulas and References in Excel
- Easily Move or Copy a Worksheet in Excel
- Change Worksheet Tab Color in Excel
- Reposition Worksheets in Excel
- Grouping & Sorting Records in Access 2007 Reports
- Grouping Objects in PowerPoint 2007
- Using Web Page Preview in Excel 2007
Comments on this entry are closed.