Unhide columns in excel shortcut mac

Hide and Unhide Rows and Columns in Microsoft Excel (with Shortcuts)

by Avantix Learning Team | Updated January 29, 2022

Applies to: Microsoft^® Excel^® 2013, 2016, 2019 and 365 (Windows)

You can hide or unhide columns or rows in Excel using the context menu, using a keyboard shortcut or by using the Format command on the Home tab in the Ribbon.

You can quickly unhide all columns or rows as well.

Some users may want to hide all of the unused columns to the right and unused rows below the data to clean up the workspace and display only relevant information to team members or clients.

You will not be able to hide or unhide rows or columns if the worksheet has been protected with a password (and you don't have the password to unprotect it), if content has been disabled or if the file is read only.

Recommended article:How to Lock and Protect Excel Worksheets and Workbooks

Selecting columns or rows in Excel

It's important to be able to quickly select columns or rows in Excel if you want to hide them.

To selec

how to unhide grouped columns in excel shortcut

how to unhide first column in excel shortcut