Using Auto Filter sample 1 pg 113 114

Using Simple AutoFilter

Example 1

To see only rows of data where column SRC contains item INV

In this case, we can use Simple AutoFilter because it will look for one particular item (INV) in one particular column (SRC).

1. Click any cell in the data area which is not empty. (Make sure the data area is not already in filtering mode. You know that data is in filtering mode if you see a small downward pointing arrow-head on the right side of every cell in the column title row (row 4).

2. Click menu Data/Filter/AutoFilter.

3. Automatically, a small downward pointing arrow-head will appear on the right side of every cell on the rows of column titles (row 4). When these arrow-heads appear, this means the data is in filtering mode (ready to be filtered).

4. Click the small arrow-head which appear on the right side of column titled SRC.

5. A list of the following choices is displayed: A11, Top 10, Custom and list of unique items.

6. Click (select) the item (source name) that you want.

Now you will see only rows of data which match the source you have selected. All the totals in row 1 will be automatically updated after a filtering operation.

7. Once done, remove the filtering mode.

Remember, while in filtering mode:

1. Do not insert a new row in the data area unless you aware at which row you are currently working.

2. You will not be able to insert a new column.

3. Do not make a copy and paste into a block of cells at one go. Copy and paste only from one cell to one cell.

4. Do not copy using Ctrl+Down keys because you may copy the content of a hidden cell.

5. You can amend or edit the data.

6. You can print as normal. Hidden rows will not be printed.

7. If you highlight a range of visible cells, effectively you are also selecting the hidden rows as well.

TIP

To select only the visible rows: Select (highlight) the data area you want. Then click menu Edit/GoTo/Specials. The Go To dialog will appear. Select Visible Cells Only and click OK. Now, hidden cells in the selected region will not be selected.

8. If you want to see all data again after the filtering, select the same arrow-head you clicked on earlier to start the filtering mode, and then select A11. Alternatively, use menu Data/Filter/Show A11.

NOT Selecting A11 from the filtering arrow will not make the arrows disappear, i.e. data is still in filtering mode. Once you no longer want to see the filtering mode, you can dismiss the filtering mode by selecting menu Data/Filter/ Show All. You will see all rows again and the filtering arrows will disappear.

114