7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel

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/join-elevate
--
~ 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