Excel hide columns with +

From this article, you'll learn how to unhide columns in Excel 2016 - 2007. It will teach you to show all hidden columns or just the ones you select, how to unhide first column, and more.

The possibility to hide columns in Excel is really helpful.

It's possible to conceal some columns by using the Hide feature or by setting the column width to zero.

How to unhide column a and b in excel

If you happen to work with Excel files where some columns are hidden, you may want to know how to unhide columns in Excel to view all data.

In this post I'll share how to show hidden columns using the standard Excel Unhide option, a macro, the Go To Special functionality and Document Inspector.

How to unhide all columns in Excel

Whether you have one or several hidden columns in your table, you can easily display them all at once using the Excel Unhide option.

1. Click on a small triangle in the upper-left corner of your table to select the entire worksheet.
   

   Tip.

   You can also press the keyboard shortcut Ctrl+A several times until the entire list is highlighted.

2. Now
   show hidden columns in excel shortcut
   display hidden columns in excel