7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel




About this tutorial:

Video duration: 00:06:34
In this video I share 7 keyboard shortcuts (plus variations) on how to select cells and ranges on a worksheet. These save time with navigating the worksheet, especially when working with large data sheets.

Download the example Excel file and read the post:

Here are the main keyboard shortcuts.
1. Select Last Used Cell on the Sheet: Ctrl+End (0:15)
2. Select First Cell on the Sheet: Ctrl+Home (1:33)
3. Select Last Used Cell in a Range: Ctrl+Arrow Keys (2:02)
4. Select Multiple Cells: Shift+Arrow Keys (3:19)
5. Select Range of Used…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads