How To Unhide A Column Excel

Unhiding a column in Excel can be a real lifesaver when you’re working on a spreadsheet and realize that an important column has disappeared. I’ve been there, and it’s always a relief to know how to quickly bring it back. Let’s dive into the process of unhiding a column in Excel.

Step 1: Identify the Hidden Column

First things first, it’s crucial to identify which column is hidden. This might sound obvious, but when you have a large dataset, it’s easy to overlook a hidden column. Look for a double line between the column letters, which usually indicates a hidden column.

Step 2: Select the Columns Around the Hidden One

Once you’ve identified the hidden column, select the columns on either side of it. This is important because when you unhide a column, it affects the neighboring columns as well.

Step 3: Unhide the Column

Now, this is where the magic happens. Right-click on any of the selected column headers, and from the menu that appears, choose “Unhide.” If you’ve selected the correct adjacent columns, the hidden column should reappear like a magician’s trick.

Step 4: Adjust the Column Width if Needed

Sometimes, when you unhide a column, the width may not align with the rest of the spreadsheet. Simply hover your mouse on the right border of the column header until you see a double-headed arrow, then click and drag to adjust the width to your liking.


Unhiding a column in Excel is a simple yet essential skill that can save you a lot of frustration. The next time you find yourself in a situation where a column seems to have vanished, you’ll be armed with the knowledge to bring it back in seconds. Before you go, remember that practice makes perfect, so don’t hesitate to try it out on a sample spreadsheet.