Microsoft Excel stores and analyses data worldwide. Excel is still the go-to data analytics tool despite newer tools. Its many features simplify data organization. Moreover, Excel shortcuts speed up data manipulation. Excel uses shortcuts, and Excel shortcut keys speed up our work and boost productivity. These shortcut keys work with most Windows versions of Excel.
About This Shortcut Delete Selected Number of Rows – The shortcut key deletes the selected number of rows. Keybord Shortcut key Window: Ctrl + ( – ) Mac: Cmd + ( – ) Example
Excel Shortcut: Delete Selected Number of Rows Read Post »
About This Shortcut Delete Selected Number of Columns – It deletes the selected number of columns in Excel. Keybord Shortcut key Window: Ctrl + ( – ) Mac: Cmd + ( – ) Example
Excel Shortcut: Delete Selected Number of Columns Read Post »
About This Shortcut Delete Contents of Selected Cells – This shortcut deletes the contents of the selected cells. Keybord Shortcut key Window: Delete Mac: Fn + Delete Example
Excel Shortcut: Delete Contents of Selected Cells Read Post »
About This Shortcut Hide Columns – This shortcut hides the selected column(s) in the worksheet. Keybord Shortcut key Window: Ctrl + ( 0 ) Mac: Ctrl + ( 0 ) Example
Excel Shortcut: Hide Columns Read Post »
About This Shortcut Hide Rows – This shortcut hides the selected row(s) in the worksheet. Keybord Shortcut key Window: Ctrl + ( 9 ) Mac: Ctrl + ( 9 ) Example
Excel Shortcut: Hide Rows Read Post »
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 »
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 »
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 »
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 »
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 »