Author name: Umesh Manral

About This Shortcut Hide (Filter Out) Pivot Table Item – This shortcut key is used to hide (filter out) a pivot table item. Keybord Shortcut key Window: Ctrl + ( – ) Mac: Ctrl + ( – )

About This Shortcut Unhide (Clear Filter on) Pivot Table Item – This shortcut key is used to unhide (clear filter on) a pivot table item. Keybord Shortcut key Window: Alt + H, S C Example

About This Shortcut Insert Pivot Chart – This shortcut key is used to insert a pivot chart in Excel. Keybord Shortcut key Window: Alt + N, S Z C Example

About This Shortcut Move to Next Control – This shortcut key is used to move to the next control or cell in a dialog box or form. Keybord Shortcut key Window: Tab Mac: Tab

About This Shortcut Move to Previous Control – This shortcut key is used to move to the previous control or cell in a dialog box or form. Keybord Shortcut key Window: Shift + Tab Mac: Shift + Tab

About This Shortcut Move to Next Tab – This shortcut key is used to move to the next tab in a dialog box or form. Keybord Shortcut key Window: Ctrl + Tab Mac: Ctrl + Tab

About This Shortcut Move to Previous Tab – This shortcut key is used to move to the previous tab in a dialog box or form. Keybord Shortcut key Window: Ctrl + Shift + Tab Mac: Ctrl + Shift + Tab

About This Shortcut Accept and Apply – This shortcut key is used to accept and apply the changes in a dialog box or form. Keybord Shortcut key Window: Enter Mac: Return Example

About This Shortcut Check and Uncheck box – This shortcut key is used to check and uncheck a checkbox in a dialog box or form. Keybord Shortcut key Window: Space Mac: Space Example

About This Shortcut Cancel and Close the Dialog box – This shortcut key is used to cancel and close the dialog box or form without applying any changes. Keybord Shortcut key Window: Esc Mac: Esc Example