How to Use a Pivot Filter in Excel

2 CQ

Pivot tables can sort, sum, or provide the average of data in an Excel spreadsheet. Learn how to edit these powerful pivot filters to suit your needs!

  • Recommended Recommended
  • History & In Progress History
  • Browse Library
  • Most Popular Library

Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

Start Interview

    You don't have any lessons in your history.
    Just find something that looks interesting and start learning!

    5 Comments
    500 characters max

    Azeb C
    how to filter spreadsheet before print
    appreciate appreciated
     –  reply
     –  delete
    500 characters max

    Athira A
    Thank you. This lesson was really helpful
    appreciate appreciated
     –  reply
     –  delete

    Kevin Lehrbass
    You're welcome Athira.
    appreciate appreciated
     –  reply
     –  delete
    500 characters max

    Barbara B
    I am in Excel 2010, I don't see where the ALL and sort section is... for sorting a column
    appreciate appreciated
     –  reply
     –  delete

    Kevin Lehrbass
    Hi Barbara. Sorry for such a late response. To sort a column select 'Data' on the ribbon at the top and then you'll see the 'Sort' text and icon.
    appreciate appreciated
     –  reply
     –  delete
    500 characters max