Top Excel Keyboard Shortcuts You DON'T Know (For Modifying Columns & Rows)
Top Excel Keyboard Shortcuts You DON'T Know (For Modifying Columns & Rows)
In this Excel tutorial we’ll discuss the top 17 keyboard shortcuts for modifying columns and rows in Microsoft Excel.
More specifically, we’ll cover:
01 Displaying the Insert Dialog Box (Ctrl + Shift + "=")
02 Inserting Rows (Ctrl + Shift + "=")
03 Inserting Columns (Ctrl + Shift + "=")
04 Displaying the Delete Dialog Box (Ctrl + "-")
05 Deleting Rows (Ctrl + "-")
06 Deleting Columns (Ctrl + "-")
07 Deleting Cells (Ctrl + "-")
08 Deleting Contents of Selected Cells (Delete)
09 Hiding Columns (Ctrl + 0)
10 Unhide Columns (Ctrl + Shift + 0)
11 Hiding Rows (Ctrl + 9)
12 Unhide Rows (Ctrl + Shift + 9)
13 Grouping Columns or Rows (Alt + Shift + →)
14 Ungrouping Columns or Rows (Alt + Shift + ←)
15 Opening the Group Dialog Box (Alt + Shift + →)
16 Opening the Ungroup Dialog Box (Alt + Shift + ←)
17 Hiding or Showing the Outline Symbols for Groups (Ctrl + 8)
This is video 05 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'T Kno...
#02: Using the Ribbon in Excel • Top Excel Keyboard Shortcuts You DON'T Kno...
#03: Using Menus & Dialog Boxes • Top Excel Keyboard Shortcuts You DON'T Kno...
#04: Using Workbooks • Video
#05: Modifying Columns & Rows • Top Excel Keyboard Shortcuts You DON'T Kno...
#06: Navigating within Excel • Top Excel Keyboard Shortcuts You DON'T Kno...
#07: Making a Selection • Top Excel Keyboard Shortcuts You DON'T Kno...
#08: Working with the Active Cell • Top Excel Keyboard Shortcuts You DON'T Kno...
#09: Extending a Selection • Top Excel Keyboard Shortcuts You DON'T Kno...
#10: Making a Special Selection • Top Excel Keyboard Shortcuts You DON'T Kno...
#11: Entering Data in Excel • Video
#12: Editing Cells & Cell Contents • Top Excel Keyboard Shortcuts You DON'T Kno...
#13: Using Spellcheck, Help, and Other Features • Top Excel Keyboard Shortcuts You DON'T Kno...
#14: Copying & Pasting • Top Excel Keyboard Shortcuts You DON'T Kno...
#15: Working with Borders • Top Excel Keyboard Shortcuts You DON'T Kno...
#16: Using General Formatting Tricks • Top Excel Keyboard Shortcuts You DON'T Kno...
#17: Applying a Specific Number Formatting • Top Excel Keyboard Shortcuts You DON'T Kno...
#18: Using Formulas within Excel • Top Excel Keyboard Shortcuts You DON'T Kno...
#19: Diving into at Filters, Tables, & Charts • Top Excel Keyboard Shortcuts You DON'T Kno...
#20: Utilizing Excel Objects, Macros, & Pivot Tables • Top Excel Keyboard Shortcuts You DON'T Kno...