Chapter 8: Focusing on Specific Data Using Filters

Page 166	To find a subset of data in a list
	Click the top cell in the column to filter. On the Data menu, point to Filter and then click AutoFilter . Click the down arrow that appears, and from the list of unique column values that appears, click the value to use as the filter.
166	To create a custom filter
	Click the top cell in the column to filter. On the Data menu, point to Filter and then click AutoFilter . Click the down arrow, and then click (Custom ) in the list. In the upper left box of the Custom AutoFilter dialog box, click the down arrow,and from the list that appears, click a comparison operator. Type the arguments for the comparison in the boxes at the upper right, and click OK .
166	To remove a filter
	On the Data menu, point to Filter and then click AutoFilter .
166	To filter for a specific value
	Click the top cell in the column to filter. On the Data menu, point to Filter and then click AutoFilter . Click the down arrow, and then, from the list of unique column values that appears, click the value for which you want to filter.
171	To find a total
	Select the cells with the values to be summed. The total appears on the status bar, in the lower right corner of the Excel window.
171	To edit a function
	Click the cell with the function to be edited. On the Insert menu, click Function . Edit the function in the Function Arguments dialog box.
171	To allow only numeric values in a cell
	Click the cell to be modified. On the Data menu, click Validation . Click the Settings tab. In the Allow box, click the down arrow, and from the list that appears, click Whole number . Click OK .