Use the Header Row You can use the Header Row to Sort and Filter the data.   3. Try It: Use the Header Row Filters Select the Sales Rep Filter. Sort the Column A to Z.   Try This, Too: Filter the Data Filter the Sales Reps: Connie and Niki.   What Do You See? Only the Rows where Connie or Niki are the Sales Reps are shown. The other rows are hidden.   What Else Do You See? This Table has Banded Rows. Does the formatting update when you choose different Filters?   Where Have You Seen This Before? The Header Row is used to create Mail Merge Fields in Microsoft Word, too. Exam 77-420 Microsoft Excel 2013 3. Create Tables 3.3 Filter and Sort aTable: Filter Records