7 keyboard shortcuts (plus variations) on how to select cells and ranges on a worksheet.
LINKS
DOWNLOAD THE WORKBOOK ► https://www.excelcampus.com/keyboard...
** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM**
https://www.excelcampus.com/joinelevate
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) https://www.excelcampus.com/blueprint ~
~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: https://www.excelcampus.com/newsletter/
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.
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 Cells in Row/Column: Ctrl+Shift+Arrow Keys (3:47)
6. Select Entire Range of Used Cells: Ctrl+Shift+Home/End (4:54)
7. Select All Cells in a Used Range: Ctrl+A (5:34)
I also explain variations and how each of these shortcuts works in different situations.
**********
EXCEL FRIENDLY ACCESSORIES WE USE (Affiliate Links When Possible): LOGITECH KEYBOARD
Check out all the tech we use and recommend at https://www.excelcampus.com/store
**********
Related Content
8 Keyboard Shortcuts for the VBA Editor in Excel: • 8 Awesome Keyboard Shortcuts For The ...
2 Keyboard Shortcuts to Select a Column with Blank Cells in Excel: • Selecting A Column With Blank Cells I...
Excel Filters Training Keyboard Shortcuts Part 2 of 3: • Excel Filters Training Keyboard Sho...
Excel Shortcut to Select Rows or Columns with Blanks Cells by Moving Selection: • Excel Shortcut to Select Rows or Colu...
#MicrosoftExcel #MSExcel #YouTubeForLearning #excelcharts