Скачать с ютуб 7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel в хорошем качестве

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