Skip to content
Excel Off The Grid Logo
Member login      Free gift
  • Home
  • Blog
  • Newsletter
  • Books
  • Training Academy

Category: PivotTables

How To Create Sheets For Each Item In PivotTable Field

How To Create Sheets For Each Item In PivotTable Field

Posted on May 4, 2023May 3, 2023 by Excel Off The Grid

Some Excel features hide in plain sight. They are there, but nobody thinks to click the button. In this post, we are covering one of those features. We are looking at how to create separate sheets for each item in a PivotTable field with the Show Report Filter Pages feature. Excel users love PivotTables because Read More

Posted in Blog, Office Scripts, PivotTables, VBA Leave a comment
Clear old items from a PivotTable filter list

Clear old items from a PivotTable filter list

Posted on January 6, 2022October 31, 2022 by Excel Off The Grid

It’s a question that every PivotTable user has had to ask at some point: How to clear old items from a PivotTable filter list? Look at the screenshot below, we can see Delta in the PivotTable filter box and the slicer, but there is no Delta in the source data table. How can that happen? Read More

Posted in Blog, PivotTables Leave a comment

Awards

Microsoft MVP:

Where to find me

YouTube:

 

Twitter:
Follow @exceloffthegrid

Books

100 Excel Macros Book

Tell me more…

Recent Posts

  • How to FILTER by a list in Excel (including multiple lists)
  • Excel number formats for accounting & finance you NEED to know
  • How to expand columns dynamically in Power Query
  • How to run Excel macros from Power Automate Desktop
  • How To Create Sheets For Each Item In PivotTable Field
Theme by Out the Box
  • Home
  • Blog
  • Newsletter
  • Books
  • Training Academy
  • About
  • Terms and conditions
  • Privacy policy
  • Affiliate disclosure
  • Contact