Spacebar toggle in PivotTable Fields pane

Question

Hello,&nbsp;&nbsp;Suddenly yesterday (after an Excel update) I am unable to use the spacebar to check/uncheck check boxes in the PivotTable Fields pane.&nbsp;&nbsp;Do I have to change a setting somewhere in Excel to activate this feature again or is there a new key to press that will check/uncheck the check boxes?&nbsp;Thank you,&nbsp;LHubb4

chris_m65 · Answer

LHubb4&nbsp;Have you found a solution? I've been dealing with the same issue since last week.Thank you.

sergeibaklan · Answer

LHubb4&nbsp;
Afraid such setting doesn't exist, if only some key in registry. Have no idea why that was removed.

darren780 · Answer

Same issue here, I haven't found a solution, has anyone?

vinod_dubey · Answer

Darren780&nbsp;&amp; AllAnyone found any solutions for this, its a unwanted issue and time taking without using spacebar in the pane area.Can some microsoft guy look into it

sergeibaklan · Answer

Vinod_Dubey&nbsp;
Afraid that's by design now (ok, new design). It will be more productive if you send a frown from Help-&gt;Send feedback or vote for&nbsp;Excel - PivotTable Field List - enable (re-enable?) use of spacebar for field selection · Community (microsoft.com)

Forum Discussion

Spacebar toggle in PivotTable Fields pane

Share

Resources