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.

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

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.