Page 16 - Code & Click - 8

3. On the Data tab, click the Subtotal button in the Outline group.

Excel displays a message to include the headings of the column in your
selected data.

3

4. Click the Yes button. 4

The Subtotal dialog box appears. 5
5. Select the column on which the subtotals should be applied 6
from the At each change in drop-down list.
6. Select the function to calculate the subtotals from the Use 7
function drop-down list.
7. Select the column(s) whose subtotals should be calculated from
the Add subtotal to list of options.
8. Click the OK button. 8

Excel applies the subtotals as per the selected criteria and displays the worksheet as shown in
the image.

To remove the subtotals from a list of values:

1. Select a cell in the list on which subtotals are applied.
2. On the Data tab, click the Subtotal button in the Outline group.
3. In the Subtotal dialog box, click the Remove All button.
Excel removes all subtotals and grand totals from the list of values.

DATA VALIDATION 3
Data validation is a feature in Excel which is used to control what values a user can enter into a cell.
It restricts the type of values that can be entered in a cell and can provide the user with instructions
for entering information in a cell.

14