Microsoft Office Tutorials and References
In Depth Information
1. Right-click on the toolbar or on any menu and click Customize .
2. Go to the Commands tab and select Edit under Categories .
3. Scroll down the list under Commands and click on Select Visible Cells. Drag the
icon to your menus area. The icon will be there to select visible cells only. See
The only difference in Excel 2011 is the way to activate the Subtotal.
Open Excel 2011. Use Data
Subtotal. Figure 25.16 shows the Data Menu
and the Subtotals menu.
FIGURE 25.12 Subtotal Menu Grouped by Number of Children
FIGURE 25.13 Grouped Data