Toggle pivot table field checkbox

Windows	Mac
Space	Space

About This Shortcut

This shortcut will toggle check and uncheck the checkbox for fields listed in the pivot table field list. Use to add or remove a field from a pivot table. On Windows, you can use the spacebar to toggle items that appear in row and column label filters as well.

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Just wanted to say thank you for your website. I use excel a lot and don't know it very well. Your site has been invaluable in helping me write formulas. It's well organized and well explained. Very happy to have found your site and really appreciate it as a resource.

Brian

More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles

Excel formulas and functions video training course