Top Excel Keyboard Shortcuts You DON'T Know (For Making a Special Selection)
Top Excel Keyboard Shortcuts You DON'T Know (For Making a Special Selection)
In this Excel tutorial we’ll discuss the top 14 keyboard shortcuts for making a special selection in Microsoft Excel.
More specifically, we’ll cover:
00 Introduction to Making a Special Selection (Section 10) (Introduction to Making a Special Selection (Section 10))
01 Displaying the "Go-To" Dialog Box (Ctrl + G)
02 Selecting Cells with Comments (Ctrl + Shift + O)
03 Selecting the Current Region around Active Cell (Ctrl + Shift + 8)
04 Selecting the Current Region (Ctrl + A)
05 Selecting Row Differences (Ctrl + \)
06 Selecting Column Differences (Ctrl + Shift + |)
07 Selecting Direct Precedents (Ctrl + [)
08 Selecting All Precedents (Ctrl + Shift + {)
09 Selecting Direct Dependents (Ctrl + ])
10 Selecting All Dependents (Ctrl + Shift + })
11 Selecting Visible Cells Only (Alt + ;)
12 Selecting a Table Row (Shift + Spacebar)
13 Selecting a Table Column (Ctrl + Spacebar)
14 Selecting a Table (Ctrl + A)
This is video 10 of 20 in our “Top Excel Keyboard Shortcuts You DIDN'T Know” Series.
For those of you interested, go ahead and…
Download the corresponding Excel Files Here: https://goo.gl/YKKJqZ
Checkout the ProductivityMe Top Excel Keyboard Shortcuts You DIDN'T Know Playlist Here: https://goo.gl/n5Lx38
We want to help you master Microsoft Excel- Let us know what you think of this video!
Feel free to give us a thumbs up, a thumbs down, or leave a comment. Your feedback is much appreciated!!!
Cheers,
Tolan
Top Excel Keyboard Shortcuts You DIDN'T Know Series (20 Individual Videos)
(Again- you can find the entire play list here: https://goo.gl/n5Lx38 ) Otherwise, check out the individual videos…
#01: Using the File Menu • Top Excel Keyboard Shortcuts You DON'...
#02: Using the Ribbon in Excel • Top Excel Keyboard Shortcuts You DON'...
#03: Using Menus & Dialog Boxes • Top Excel Keyboard Shortcuts You DON'...
#04: Using Workbooks • Video
#05: Modifying Columns & Rows • Top Excel Keyboard Shortcuts You DON'...
#06: Navigating within Excel • Top Excel Keyboard Shortcuts You DON'...
#07: Making a Selection • Top Excel Keyboard Shortcuts You DON'...
#08: Working with the Active Cell • Top Excel Keyboard Shortcuts You DON'...
#09: Extending a Selection • Top Excel Keyboard Shortcuts You DON'...
#10: Making a Special Selection • Top Excel Keyboard Shortcuts You DON'...
#11: Entering Data in Excel • Video
#12: Editing Cells & Cell Contents • Top Excel Keyboard Shortcuts You DON'...
#13: Using Spellcheck, Help, and Other Features • Top Excel Keyboard Shortcuts You DON'...
#14: Copying & Pasting • Top Excel Keyboard Shortcuts You DON'...
#15: Working with Borders • Top Excel Keyboard Shortcuts You DON'...
#16: Using General Formatting Tricks • Top Excel Keyboard Shortcuts You DON'...
#17: Applying a Specific Number Formatting • Top Excel Keyboard Shortcuts You DON'...
#18: Using Formulas within Excel • Top Excel Keyboard Shortcuts You DON'...
#19: Diving into at Filters, Tables, & Charts • Top Excel Keyboard Shortcuts You DON'...
#20: Utilizing Excel Objects, Macros, & Pivot Tables • Top Excel Keyboard Shortcuts You DON'...