Excel Shortcut: Expand or Collapse the Formula bar
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…
Read MoreCategory: Excel Shortcuts
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.
Excel Shortcut: Display Function Arguments Dialog box
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 +…
Read MoreExcel Shortcut: Open Name Manager
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…
Read MoreExcel Shortcut: Create name from values in row
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…
Read MoreExcel Shortcut: Paste Name Into Formula
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…
Read MoreExcel Shortcut: Accept Function With Auto-Complete
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.…
Read MoreExcel Shortcut: Display Insert Dialog box
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…
Read MoreExcel Shortcut: Insert Selected Number of Rows
About This Shortcut Insert Selected Number of Rows – The shortcut command inserts selected number of rows. Keybord Shortcut key Window: Ctrl + ( + ) Mac: Cmd + Shift…
Read MoreExcel Shortcut: Insert Selected Number of Columns
About This Shortcut Insert Selected Number of Columns – The shortcut key inserted selected number of columns. Keybord Shortcut key Window: Ctrl + ( + ) Mac: Cmd + Shift…
Read MoreExcel Shortcut: Display Delete Dialog box
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…
Read More