• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


10 Excel Tips For Increased Productivity

July 4, 2014 by Mark 4 Comments

Excel Tip #4: Filter Your Data

If you are working with a spreadsheet with a large set of data, you may be able to speed up your work by filtering the data to only display the information you are concerned with at the moment.

For example, if you have a spreadsheet with sales data for your company across all the regions it operates in, you can filter the data by region to show only that region’s results.

To filter your data:

  1. Click the cell in the top left of your data set.
  2. Click the Data tab, then the Filter button in the Sort & Filter group.
  3. There should be some arrows like a drop-down menu in each of the cells in the top row.
  4. Click on the arrow in the column you want to filter by.
  5. Place a check mark next to each data group you are interested in.
  6. Click OK.
  7. You can filter by more than one column, so if you want to only see the sales from the East region in May, you can filter by both the Region and Date columns.
  8. Your data will now only show the data you want to see.
  9. To see all data again, click the arrow button again, and click the Select All option.

Excel Tip Filter Data

Pages: 1 2 3 4 5 6 7 8 9 10 11

Filed Under: Tips Tagged With: Automatic, Cell, Formats, Shortcuts, Tips

Looking For More Help?

Contact us with any specific questions or feedback. We love to hear from you!

Want to level up your career? See our amazing Certificated Excel Courses and be the office Hero with your new found knowledge!

Looking for the Excel Audit Tickmark Toolbar? click here, NOW ONLY $25!

Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Categories

  • Macros (34)
  • Tips (67)
  • Uncategorized (23)



Copyright © 2023 · Magazine Pro Theme on Genesis Framework · WordPress · Log in

Login Form

Lost your password?