Excel 2013

Filter data in a Table

When you put your data in a table, filtering controls are added to he table headers automatically.

excel 2013

For quick filtering, do this:

  1. Click the arrow in the header of the column you want to filter.
  2. In the list of text or numbers, uncheck the (Select All) box at the top of the list, and then check the boxes of the items you want to show in your table - Tip: To see more items in the list, drag the handle in the bottom-right corner of the filter gallery to enlarge it.

  3. excel 2013
  4. Click OK - The filtering arrow in the table header will change to indicae a filter is applied. Click it to change or clear the filter.

  5. excel 2013

Filter by specific text or numbers

  1. Click on arrow in the table header of the column you want to filter.
  2. If the column has numbers, click Number Filters. If the column has text entries, click Text Filters.
  3. Pick the filtering option you want, and then enter your filtering conditions.

For example, to show number above a certain amount, pick Greater Than Or Equal To, and then enter the other number you have in mind in the adjacent box.

excel 2013

To filter by two conditions, enter filtering condition in both sets of boxes, and pick And. for both conditions to be true, and Or for either of the conditions to be true.

Filter items by Colour

If you have applied different cell or font colours or a coniditional format, you can filter by the colours or icons that are shown in your table.

  1. Click the arrow in the table header of the column that has colour formating or conditional formatting applied.
  2. Click Filter by Colour and then pick the cell colour, font colour, or icon you want to filer by - The types of colour options you will have available depend on the types of fomat you have applied.

  3. excel 2013

Create a slicer to filter your table data

In Excel 2010, slicers where added as a new way to filter Pivot Table data. In Excel 2013, you can also create slicers to filter you table data. a slicer is really useful becouse it clearly indicates what data is shown in your table after you filter your data.

excel 2013
  1. Click anywhere in the table to show the Table Tools on the ribbon.

  2. excel 2013
  3. Click Design > insert Slicer.

  4. excel 2013
  5. In the Insert Slicers dialog box, check the boxes you want to create slicers for.
  6. Click OK - A slicer appear for each table header you checked in the Insert Slicers dialog box.
  7. In each slicer, click the items you want to show in your table - To choose more than one item, hold down Ctrl, and then pick the items you want to show.

Tip - To change how the slicers look, click the slicer to show to Slicer Tools on the ribbon, and then apply a slicer style or change setting on the Options tab.

back to menu