7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel

7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel

Home › Other Content › 7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel
Sources from Excel Campus - Jon, • Youtube on Youtube • Published 7 years ago
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Excel Campus - Jon2018-08-22 15:49:52 Thumbnail
491,989 Views
View on YouTube View Channel
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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.