How to Unhide All Columns in Excel: A Step-by-Step Guide

Unhiding all columns in Excel is a breeze once you know how. To get started, you’ll need to select the entire spreadsheet. Then, right-click on any column header and choose ‘Unhide’ from the menu. Voilà! All your previously hidden columns will reappear. It’s as simple as that.

Step by Step Tutorial: How to Unhide All Columns in Excel

Before we dive into the steps, let’s understand what we’re aiming to achieve here. By following this tutorial, you’ll be able to reveal all the columns that you’ve hidden in your Excel spreadsheet. This can be particularly useful when you’re working with a lot of data and need to ensure that nothing is missed.

Step 1: Select the Entire Spreadsheet

Click on the triangle icon at the top-left corner of your spreadsheet to select all cells.

Selecting the entire spreadsheet is crucial because it ensures that no columns are left behind when you unhide them. This icon is located where the row numbers and column letters meet.

Step 2: Right-Click on any Column Header

Right-click on any of the column headers after you’ve selected the entire spreadsheet.

When you right-click on a column header, a context menu will pop up. This menu will give you various options, one of which is the ‘Unhide’ option we’re looking for.

Step 3: Choose ‘Unhide’ from the Menu

Select ‘Unhide’ from the context menu.

After clicking ‘Unhide’, all the columns that were hidden will instantly become visible. It’s important to note that if no columns are hidden, the ‘Unhide’ option will be greyed out.

After completing these steps, all the columns that were hidden in your Excel spreadsheet will now be visible. It’s a straightforward process that takes only a few seconds to complete.

Tips for Unhiding All Columns in Excel

  • Always make sure you’ve selected the entire spreadsheet to avoid missing any hidden columns.
  • If you’re only looking to unhide specific columns, you can select the columns surrounding the hidden ones and then right-click to unhide.
  • Remember that hiding and unhiding columns does not delete any data. It simply changes the visibility of your data.
  • Use keyboard shortcuts (Ctrl + Shift + 0) to quickly unhide columns if you prefer using the keyboard over the mouse.
  • If the ‘Unhide’ option is greyed out, it means there are no hidden columns within the selected range.

Frequently Asked Questions

What if the ‘Unhide’ option is greyed out?

If the ‘Unhide’ option is greyed out, it means that there are no hidden columns in the selected range. Make sure you’ve selected the entire spreadsheet or the specific columns surrounding the hidden ones.

Can I use a keyboard shortcut to unhide columns?

Yes, you can use the keyboard shortcut Ctrl + Shift + 0 to unhide columns in Excel.

Will unhiding columns affect my data?

No, unhiding columns in Excel will not affect the data itself. It only changes whether the data is visible or not.

What do I do if I can’t find the ‘Unhide’ option?

If you can’t find the ‘Unhide’ option, make sure that you’ve right-clicked on a column header after selecting the entire spreadsheet.

Can I unhide multiple columns at once?

Yes, by selecting the entire spreadsheet and following the steps above, you can unhide multiple columns at once.


  1. Select the entire spreadsheet by clicking on the triangle icon at the top-left corner.
  2. Right-click on any column header.
  3. Choose ‘Unhide’ from the menu.


Unhiding all columns in Excel is a straightforward process that can make a world of difference when analyzing data. Whether you’re a beginner or an experienced Excel user, knowing how to effectively manage the visibility of your columns is essential. With just a few clicks, you can ensure that no data is hidden from view, allowing for a more comprehensive analysis. Remember, the key is to select the entire spreadsheet first to ensure that no columns are left hidden. So next time you’re working with an Excel spreadsheet, don’t let hidden columns hinder your productivity. Use the steps outlined in this article to unhide all columns and get the full picture of your data.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy