How to unhide columns in excel

It can sometimes be useful to hide and unhide columns in Excel. If you need to know how to hide a column, check if there are hidden columns or unhide a column in Excel, here’s how.

How to Hide and Unhide Columns in Excel | Hide an Excel Column | Unhide a Column in Microsoft Excel

How to Hide a Column or Unhide a Column in Microsoft Excel

Note: This post may contain affiliate links.

How to Hide Columns in Excel

If you’re like me than there’s no such thing as too much data. But, while saving a lot of information may be helpful, it may not make it easy to look at the information. Too much data can make things confusing to you and anyone with whom you’re sharing your spreadsheet. Or, what if you have some information that you don’t want others to see? Just hide those columns in Excel.

The easiest way to hide a column in excel is to:

  1. Right click on the column header (ie: the letter above the column)
  2. Click hide

Hide and Unhide Columns in Excel

See Also: Excel 101, An Introduction to Excel Basics

How to Know if a Column is Hidden in Excel

An easy way to see if a column is hidden in Excel is to scan across the column headers and see if any letters are missing. For example, in the spreadsheet below we see column A, B, C, D, E, F, G and then I. Where’s “H”? That column is hidden in this Excel spreadsheet.

How to Hide and Unhide Columns in Excel

See Also: How to create a Password Keeper in Excel (with a Free Template)

How to Unhide Columns in Excel

Now that you know how to hide columns, how do you get them back? What if you receive an excel file from someone and you notice that some columns are hidden? How do you view the hidden columns?

  1. Click on the column header to the left of the hidden column
  2. Continue to hold down the mouse key and drag the cursor to the column header to the right of the missing column
  3. When the columns that surround the hidden column are selected, right click
  4. Click unhide
Related text  How to hide apps on android

How to Hide a Column and Unhide a Column using Excel

See Also: How to Add in Excel

How to Unhide All Columns and Rows in Excel

If you have several hidden columns and/or rows and want to unhide all columns and rows in the entire spreadsheet simply:

  1. Select the entire spreadsheet by clicking in the gray rectangle in the upper left corner of the spreadsheet
  2. With the entire spreadsheet selected, right click and select unhide

Unhide all columns in Microsoft Excel

Here’s the findings:

  • For row height =0.68, we will see a “noticeable” row, so that we know the row is not hidden.

ImageRow height set at 0.68 for rows 2:6

How do I know these? Just by experiment.

Learning is a series of curiosity, observation, and trials & errors.

If the above doesn’t help you to unhide rows, there may be a chance that the hidden rows was a result from advanced filter.  You may read this post for more details.

Excel Dashboard Course

Excel Expert Course

This entry was posted in Excel Basic, Excel Tips and tagged Hide, Unhide. Bookmark the permalink.

Like this post? Please share to your friends: