• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Focusing on Specific Data Usi... > Limiting the Data That Appears on th...

Limiting the Data That Appears on the Screen

Excel spreadsheets can hold as much data as you need them to, but you might not want to work with all of the data in a worksheet at the same time. For example, you might want to see the sales figures for your company during the first third, second third, and final third of a month. You can limit the data shown in a worksheet by creating a filter, which is a rule that selects rows to be shown in a worksheet.


To create a filter, you click the cell in the group you want to filter and use the Data menu to turn on AutoFilter. When you turn on AutoFilter, which is a built-in set of filtering capabilities, a down arrow button appears in the cell that Excel recognizes as the column’s label.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint