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 Expand or Collapse the Formula bar – This shortcut expands or collapses the formula bar, which can be useful when you want to see more or less of the formula in the formula bar. Keybord Shortcut key Window: Ctrl + Shift + U Mac: Ctrl + Shift + U Example
Excel Shortcut: Expand or Collapse the Formula bar Read Post »
About This Shortcut Display Function Arguments Dialog box – This shortcut displays the function arguments dialog box for the selected function in a formula. Keybord Shortcut key Window: Ctrl + A Mac: Ctrl + A Example
Excel Shortcut: Display Function Arguments Dialog box Read Post »
About This Shortcut Open Name Manager – This shortcut opens the Name Manager, which allows you to manage named ranges and defined names in the current workbook. Keybord Shortcut key Window: Ctrl + F3 Mac: Fn + Ctrl + F3 Example
Excel Shortcut: Open Name Manager Read Post »
About This Shortcut Create name from values in row(s)/column(s) – This shortcut creates a new named range based on the values in the selected row(s) or column(s). Keybord Shortcut key Window: Ctrl + Shift + F3 Example
Excel Shortcut: Create name from values in row Read Post »
About This Shortcut Paste Name Into Formula – This shortcut pastes the name of a named range or defined name into a formula. Keybord Shortcut key Window: F3 Mac: F3 Example
Excel Shortcut: Paste Name Into Formula Read Post »
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
Excel Shortcut: Accept Function With Auto-Complete Read Post »
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
Excel Shortcut: Display Insert Dialog box Read Post »
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
Excel Shortcut: Insert Selected Number of Rows Read Post »
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
Excel Shortcut: Insert Selected Number of Columns Read Post »
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
Excel Shortcut: Display Delete Dialog box Read Post »