Wednesday, January 19, 2011

How Do I Group Worksheets in Excel 2007?


1. Open the workbook containing the worksheets you want to group.
2. Group all of the worksheets in a workbook. Right-click any tab in the workbook and click 'Select All.'
3. Group adjoining worksheets. Press and hold the 'Shift' key. Click on the tab for the first worksheet in the selection you want to group and then click on the tab for the last worksheet you want to include in the group.
4. Group worksheets that are not adjoining. Press and hold the 'Ctrl' key. Click on the tab of each worksheet you want to include in the group.
5. Ungroup worksheets by right-clicking any tab in the group. Select 'Ungroup Sheets.'

Blogger news