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.
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:
- Right click on the column header (ie: the letter above the column)
- Click hide
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.
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?
- Click on the column header to the left of the hidden column
- Continue to hold down the mouse key and drag the cursor to the column header to the right of the missing column
- When the columns that surround the hidden column are selected, right click
- Click unhide
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:
- Select the entire spreadsheet by clicking in the gray rectangle in the upper left corner of the spreadsheet
- With the entire spreadsheet selected, right click and select unhide
Here’s the findings:
- For row height =0.68, we will see a “noticeable” row, so that we know the row is not hidden.
Row 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.
This entry was posted in Excel Basic, Excel Tips and tagged Hide, Unhide. Bookmark the permalink.