Video: Hide Or Unhide Columns On A Mac
Excel expert Dennis Taylor helps Excel for Mac 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks. He begins with his top 10 productivity boosters, and then highlights navigation, display, and selection techniques to keep you moving quickly. The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the 'Ten Tiny Tips' chapter for a quick productivity boost. Instructor.
In this video, I’m going to teach you the shortcut on how to group and ungroup rows and columns. In the previous video, I showed you how to hide and unhide rows and columns. In contrast, this is all about grouping and ungrouping rows and columns which is actually the same thing except for one key difference. Join Sally Norred for an in-depth discussion in this video Hiding rows, columns, and sheets, part of Google Sheets Essential Training. Let's take a look at how to hide andunhide rows, columns, and sheets in a Google Sheet spreadsheet.There are several situations where hiding rows andcolumns in a spreadsheet can come in handy. In this video, we'll cover shortcuts for hiding and unhiding rows and columns. To hide columns, use Control + 0. You can also work with multiple columns at the same time. To unhide columns again, make a selection that spans the hidden columns, and use Control Shift 0. To hide rows, use Control + 9.
Excel expert Dennis Taylor has 25+ years experience in spreadsheet authoring and training. Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator.
Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the US and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado. By: Nick Brazzi course. 8h 13m 16s.
5,512 viewers. Course Transcript - Voiceover Anytime you're inserting or deleting columns and rows, or cells, you're likely to be using, not the menu at the top of the screen, nor the ribbon menu system, the right-mouse button is likely to work best there, the same is true when you're hiding columns and rows, or unhiding columns and rows. In this worksheet here, I'm about to print this, I don't want to print columns D and E, nor do I want to print column I, so I'll drag across columns D and E, and now holding down the command key, I'll select column I, right click, and simply hide those columns. Later, I might want to get them back.
If I simply want to get back the columns between C and F, I could drag across here, and either right-click and unhide, that's one way, or undoing it with command + Z momentarily, dragging across here, and simply double clicking either this boundary, or the right boundary of column F, either way, brings back the data as well too, and I can do the same thing, of course, between columns A. Practice while you learn with exercise files.
Watch this course anytime, anywhere. Course Contents. Introduction Introduction. 1. Top Ten Shortcuts 1. Top Ten Shortcuts. 2.
Display and Navigation Shortcuts 2. Display and Navigation Shortcuts. 3. Selection Shortcuts 3. Selection Shortcuts. 4. Data Entry and Editing Shortcuts 4.
Data Entry and Editing Shortcuts. 5. Formatting Shortcuts 5. Formatting Shortcuts. 6. Drag-and-Drop Techniques 6. Drag-and-Drop Techniques.
7. Formula Shortcuts 7.
Formula Shortcuts. 8. Operational Shortcuts 8. Operational Shortcuts. 9. Data Management Techniques 9.
Data Management Techniques. 10. Tips for Using Charts and Visual Objects 10. Tips for Using Charts and Visual Objects.
11. Ten Tiny Tips 11.
Video Hide Or Unhide Columns On A Macro
Ten Tiny Tips. Conclusion Conclusion.