Excel Tutorial #121: Selecting All Dependents (Ctrl + Shift + })

Excel Tutorial #121: Selecting All Dependents (Ctrl + Shift + })

In this Excel tutorial we're going look at a series of Microsoft Excel tips, tricks and keyboard shortcuts.

We’ll cover how to select all dependents for a given cell or set of cells within a Microsoft Excel worksheet; we’ll discuss two methods for achieving this, starting with the Microsoft Excel keyboard shortcut Ctrl + Shift + }.

This is video 121 of 175 in our "Excel Mastery" Tutorial Series, a set of Excel tutorials for beginners as well some tutorials for advanced users of MS Excel. We’ll cover the Excel basics, and then move on more advanced Excel tips & tricks!

In this Excel training tutorial we’ll be using a version of Microsoft Excel 2013; however, the Excel tips, tricks, and keyboard strategies included in this video series should also work with Microsoft Excel 2010 and Microsoft Excel 2016.

We wanted to create an easy to follow, easy to understand, basic excel tutorial, a simple tutorial, one that shows how Excel is fun!

No matter what version of Microsoft Office you’re using (whether that be Office 2010, Office 2013, Office 2016, or perhaps even an older version) learning basic Excel, as well as tips & tricks on how to really use the program is important in today’s world!

If you have questions, comments, suggestions, criticisms, or ideas, please feel free to post them in the comments section of this video! We love interacting with students, fellow YouTubers, instructors, and entrepreneurs.

We want to help! Let us know what you think of this video!

Cheers,

Tolan & the ProductivityMe Teaching Team

PS- In case you’re interested, check out these other Excel help, productivity, keyboard shortcut resources and tutorials below.

Excel Tutorials & Support Resources:

https://support.office.com/en-us/article/Excel-2013-videos-and-tutorials-aaae974d-3f47-41d9-895e-97a71c2e8a4a

http://answers.microsoft.com/en-us/office

https://support.office.com/en-us/excel

http://www.lynda.com/Excel-training-tutorials/192-0.html

https://www.udemy.com/tutorials/learn-excel

http://www.gcflearnfree.org/excel2016

http://www.gcflearnfree.org/excel2013

http://www.gcflearnfree.org/excel2010

http://www.gcflearnfree.org/excel2007

http://www.gcflearnfree.org/excel2003

http://www.gcflearnfree.org/excelformulas

http://www.gcflearnfree.org/excel-tips

http://spreadsheets.about.com/od/excel101/a/Excel_beg_guide.htm

Microsoft Excel Keyboard Shortcuts:

https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-6a4319ef-8ea9-45d1-bd98-f238bf953ba6?CorrelationId=e3ab74bd-789a-4c13-88ea-2531cfa48821&ui=en-US&rs=en-US&ad=US

You might also want to consider:

http://chandoo.org/wp/excel-basics/

http://www.excel-easy.com/