Excel Shortcut: Select all Precedents
About This Shortcut Select All Precedents – When you press CTRL + Shift+ {, you can choose direct or indirect predecessors of the current cell. Keybord Shortcut key Window: Ctrl…
Read MoreBlog
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.
Excel Shortcut: Select Direct Precedents
About This Shortcut Select Direct Precedents – CTRL+ [ selects all the cells in the selection that are directly referred to by formulas. Keybord Shortcut key Window: Ctrl + […
Read MoreExcel Shortcut: Select Current Region
About This Shortcut Select Current Region – The keyboard shortcut will select all of the cells on the worksheet, even the blank ones. Keybord Shortcut key Window: Ctrl + A…
Read MoreExcel Shortcut: Select Current Region Around Active Cell
About This Shortcut Select Current Region Around Active Cell – Ctrl+ Shift + * lets you choose the area around the active cell. Keybord Shortcut key Window: Ctrl + Shift…
Read MoreExcel Shortcut: Select Cells With Comments
About This Shortcut Select Cells With Comments – The shortcut key selects all cells that have comments in them. Keybord Shortcut key Window: Ctrl + Shift + O Mac: Fn…
Read MoreExcel Shortcut: Display go to Dialog box
About This Shortcut Display ‘Go To’ Dialog box – You can use the F5 shortcut to quickly go to a certain cell in a worksheet. The keyboard shortcut brings up…
Read MoreExcel Shortcut: Toggle ‘Extend Selection’ Mode
About This Shortcut Toggle ‘Extend Selection’ Mode – The keyboard shortcut selects the formula bar from the current cursor location to the end of the bar. Keybord Shortcut key Window:…
Read MoreExcel Shortcut: Cancel ‘Extend Selection’ Mode
About This Shortcut Cancel ‘Extend Selection’ Mode – The F8 key is useful to turn the extended selection mode on or off. Keybord Shortcut key Window: Esc Mac: Esc Example:
Read MoreExcel Shortcut: Extend Selection to Last Cell in Worksheet
About This Shortcut Extend Selection to Last Cell in Worksheet – It lets you choose a cell all the way back to the beginning of the worksheet. Keybord Shortcut key…
Read MoreExcel Shortcut: Extend Selection to First Cell in Worksheet
About This Shortcut Extend Selection to First Cell in Worksheet – It takes control of all the data or words in a cell from where your cursor is to where…
Read More