Author name: Umesh Manral

About This Shortcut Accept Function With Auto-Complete – This shortcut allows you to accept a suggested function from the auto-complete list in the formula bar by pressing the Tab key. Keybord Shortcut key Window: Tab Mac: Tab Example

About This Shortcut Display Insert Dialog box – This shortcut displays the Insert dialog box, which allows you to insert rows, columns, or cells into a worksheet. Keybord Shortcut key Window: Ctrl + ( + ) Mac: Cmd + Shift + ( + ) Example

About This Shortcut Insert Selected Number of Rows – The shortcut command inserts selected number of rows. Keybord Shortcut key Window: Ctrl + ( + ) Mac: Cmd + Shift + ( + ) Example

About This Shortcut Insert Selected Number of Columns – The shortcut key inserted selected number of columns. Keybord Shortcut key Window: Ctrl + ( + ) Mac: Cmd + Shift + ( + ) Example

About This Shortcut Display Delete Dialog box – This shortcut displays the Delete dialog box, which allows you to delete rows, columns, or cells from a worksheet. Keybord Shortcut key Window: Ctrl + ( – ) Mac: Cmd + ( – ) Example

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

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

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

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

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