7 keyboard shortcuts (plus variations) on how to select cells and ranges on a worksheet.

-- LINKS --
DOWNLOAD THE WORKBOOK ► https://www.excelcampus.com/keyboard-shortcuts/select-cells-ranges/

*** 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: https://youtu.be/IbEXB9X5kRo
- 2 Keyboard Shortcuts to Select a Column with Blank Cells in Excel: https://youtu.be/b8By_uVpBw8
- Excel Filters Training - Keyboard Shortcuts - Part 2 of 3: https://youtu.be/Z1_oq-uPUBU
- Excel Shortcut to Select Rows or Columns with Blanks Cells by Moving Selection: https://youtu.be/KM8MYrdaoNc


#MicrosoftExcel #MSExcel #YouTubeForLearning #excelcharts