Excel for Mac tips

Hide rows or columns on a Mac

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

You can hide or unhide rows or columns in your spreadsheet to show only the data you want.

Hide columns
  1. Select the column or columns that you want to hide.

    Tip: To select non-adjacent columns, hold the Command key and select the columns.

  2. Control + click any selected column, and then select Hide.

Unhide columns
  1. Select the columns around the columns that you want to unhide.

  2. Control + click any selected column, and select Unhide.
    Or, double-click the boundary between the selected columns.

    Tip: To unhide all hidden columns, select the upper left-hand corner SelectAll to select the entire worksheet, right-click any column, and select Unhide.

Want more?

Discover more courses like this at LinkedIn Learning

Excel 2016 for Mac Help

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 wanna 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.

I can do the same thing of course between columns A and J.

Let me again undo with command Z.

If I know that these columns are hidden, and I can see the thicker line there, and maybe some other columns way off to the right that I'm not looking at, or maybe I'm not sure, but I want to make sure that all hidden columns are brought back, click in the upper left hand corner, right click any column, and unhide, all hide all hidden columns re-emerge.

Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at linkedin.com/learning.

Enjoy one month of free access to LinkedIn Learning

Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.

Benefits
  • Get unlimited access to over 4,000 video courses.

  • Receive personal recommendations based on your LinkedIn profile.

  • Stream courses from your computer or mobile device.

  • Take courses for every level – beginner to advanced.

  • Practice while you learn with quizzes, exercise files, and coding windows.

  • Choose a plan for yourself or your entire team.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×