Excel Shortcut: Unhide Rows
About This Shortcut Unhide Rows – This shortcut unhides any hidden rows in the worksheet. Keybord Shortcut key Window: Ctrl + Shift + ( 9 ) Mac: Ctrl + Shift + ( 9 ) Example
Excel Shortcut: Unhide Rows Read Post »
Excel Shortcut: Group Rows or Columns
About This Shortcut Group Rows or Columns (with rows/columns selected) – This shortcut groups the selected rows or columns together in the worksheet. Keybord Shortcut key Window: Alt + Shift + → Mac: Cmd + Shift + K Example
Excel Shortcut: Group Rows or Columns Read Post »
Excel Shortcut: Ungroup Rows or Columns
About This Shortcut Ungroup Rows or Columns (With Rows/Columns Selected) – This shortcut ungroups the selected rows or columns in the worksheet. Keybord Shortcut key Window: Alt + Shift + ← Mac: Cmd + Shift + J Example
Excel Shortcut: Ungroup Rows or Columns Read Post »
Excel Shortcut: Open Group Dialog Box
About This Shortcut Open Group Dialog Box (no Rows/Cols Selected) – The “Alt + Shift + →” keyboard shortcut is used to open the “Group” dialog box when no rows or columns are selected, allowing you to group selected rows or columns. Keybord Shortcut key Window: Alt + Shift + → Mac: Cmd + Shift
Excel Shortcut: Open Group Dialog Box Read Post »
Excel Shortcut: Open Ungroup Dialog box
About This Shortcut Open Ungroup Dialog Box – The “Alt + Shift + ←” keyboard shortcut is used to open the “Ungroup” dialog box, which allows you to ungroup selected rows or columns. Keybord Shortcut key Window: Alt + Shift + ← Mac: Cmd + Shift + J Example
Excel Shortcut: Open Ungroup Dialog box Read Post »
Excel Shortcut: Hide or Show Outline Symbols
About This Shortcut Hide or Show Outline Symbols – The “Ctrl + 8” keyboard shortcut is used to toggle the display of outline symbols, which are used to indicate the level of grouping in a worksheet. When the outline symbols are hidden, it can make the worksheet appear less cluttered and easier to read. Keybord
Excel Shortcut: Hide or Show Outline Symbols Read Post »
Excel Shortcut: Create Pivot Table
About This Shortcut Create Pivot Table – This shortcut key is used to create a pivot table in Excel. Keybord Shortcut key Window: Alt + N, V Example
Excel Shortcut: Create Pivot Table Read Post »
Excel Shortcut: Select Entire Pivot Table
About This Shortcut Select Entire Pivot Table – This shortcut key is used to select the entire pivot table. Keybord Shortcut key Window: Ctrl + A Mac: Cmd + A Example
Excel Shortcut: Select Entire Pivot Table Read Post »
Excel Shortcut: Group Pivot Table Items
About This Shortcut Group Pivot Table Items – This shortcut key is used to group selected items in a pivot table. Keybord Shortcut key Window: Alt + Shift + → Mac: Cmd + Shift + K Example
Excel Shortcut: Group Pivot Table Items Read Post »
Excel Shortcut: Ungroup Pivot Table Items
About This Shortcut Ungroup Pivot Table Items – This shortcut key is used to ungroup selected items in a pivot table. Keybord Shortcut key Window: Alt + Shift + ← Mac: Cmd + Shift + J
Excel Shortcut: Ungroup Pivot Table Items Read Post »