Tips, tricks, and tutorials to help you master Excel and Google Sheets. Learn from our experts and take your spreadsheet skills to the next level.
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 MoreAbout 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 MoreAbout 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 MoreAbout 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 MoreAbout 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 MoreAbout 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 MoreAbout This Shortcut Insert Selected Number of Rows – The shortcut command inserts selected number of rows. Keybord Shortcut key Window: Ctrl + ( + ) Mac: Cmd + Shift…
Read MoreAbout This Shortcut Insert Selected Number of Columns – The shortcut key inserted selected number of columns. Keybord Shortcut key Window: Ctrl + ( + ) Mac: Cmd + Shift…
Read MoreAbout 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 MoreAbout This Shortcut Delete Selected Number of Rows – The shortcut key deletes the selected number of rows. Keybord Shortcut key Window: Ctrl + ( – ) Mac: Cmd +…
Read More