Excel Tutorial #122: Selecting Visible Cells Only (Alt + ;)

Excel Tutorial #122: Selecting Visible Cells Only (Alt + ;)

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 visible cells within a Microsoft Excel worksheet; we’ll discuss two methods for achieving this and how and why this might be useful, starting with the Microsoft Excel keyboard shortcut Alt + ;.

This is video 122 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:

Microsoft Excel Keyboard Shortcuts:

You might also want to consider: