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 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 the cell starts. Keybord Shortcut key Window: Ctrl + Shift + Home Mac: Fn + Ctrl + Shift + ← Example:
Excel Shortcut: Extend Selection to First Cell in Worksheet Read Post »
About This Shortcut Extend Selection to Start of row (s) – It is useful for making selections on the left side of the screen. Keybord Shortcut key Window: Shift + Home Mac: Fn + Shift + ← Example:
Excel Shortcut: Extend Selection to Start of row Read Post »
About This Shortcut Extend Selection Left one Screen – The keys are useful for screen selections to the right. Keybord Shortcut key Window: Alt + Shift + PgUp Mac: Fn + Shift + Alt + ↑ Example:
Excel Shortcut: Extend Selection Left one Screen Read Post »
About This Shortcut Extend Selection Right one Screen – The keys are useful for screen selections to the right. Keybord Shortcut key Window: Alt + Shift + PgDn Mac: Fn + Shift + Alt + ↓ Example:
Excel Shortcut: Extend Selection Right one Screen Read Post »
About This Shortcut Extend Selection Down one Screen – It moves the selections one screen down. Keybord Shortcut key Window: Shift + PgDn Mac: Fn + Shift + ↓ Example:
Excel Shortcut: Extend Selection Down one Screen Read Post »
About This Shortcut Extend Selection up one Screen – When you press Shift+Page Up, the selection moves up one screen. Keybord Shortcut key Window: Shift + PgUp Mac: Fn + Shift + ↑ Example:
Excel Shortcut: Extend Selection up one Screen Read Post »
About This Shortcut Extend the Selection to the Last Cell Down that Contains Data, or to the next cell that contains data, or to the last row- CTRL+SHIFT+ARROW DOWN selects the whole column from the current cell down to the end of the column. This works differently for each column in the same Excel file.
Excel Shortcut: Extend the Selection to the Last Cell Down Read Post »
About This Shortcut Extend the Selection to the Last Cell up That Contains Data, or to the next cell that contains data, or to the first row- CTRL+SHIFT+ARROW UP moves the cursor to the top of the current cell, but it does different things in different columns of the same Excel file. Keybord Shortcut key
Excel Shortcut: Extend the Selection to the Last Cell up Read Post »
About This Shortcut Extend the Selection to the Last Cell on the Left that Contains Data, or to the next cell that contains data, or to the first column- The shortcut lets you change or delete the whole word that was before your cursor. Keybord Shortcut key Window: Ctrl + Shift + ← Mac: Cmd
Excel Shortcut: Extend the Selection to the Last Cell on the Left Read Post »
About This Shortcut Extend the Selection to the Last Cell on the Right That Contains Data, or to the next cell that contains data, or to the last column- The shortcut lets you change or delete the whole word that comes after your cursor. Keybord Shortcut key Window: Ctrl + Shift + → Mac: Cmd
Excel Shortcut: Extend the Selection to the Last Cell on the Right Read Post »