Search This Blog

Sunday 2 June 2013

Filter Excel Tables from Table Headings




When you create a table in Excel, you can now click on the down arrow in the header cell and use the menu positioned to the upper left of it to filter the display—in other words, you can display only rows that contain subtotals and totals, or one or more specific rows that you select by checking a box in a list. You can display only rows that match a specific background color, or use the checkboxes to show or hide individual rows.



 

No comments:

Post a Comment