Revealing the columns: A Comprehensive Guide on how to Unhide Columns in Excel

Learn how to easily unhide columns in Excel so you can see and work with all your data. This comprehensive guide will walk you through various methods to reveal hidden columns, ensuring your spreadsheet is fully visible and functional.

2 min readExcel Guide
Contents
  1. Unhiding Columns Using the Context Menu
  2. How to Unhide Columns Using the Home Tab
  3. Unhiding Columns with Keyboard Shortcuts
  4. Unhiding Columns Using Mouse Techniques

In this article, we will understand how to unhide columns in Excel. There are several methods to accomplish this task, and we will explore five straightforward techniques, each with demonstrations to help clarify the process.

Unhiding Columns Using the Context Menu

To reveal hidden columns in Excel, you can use the Context Menu. Follow these simple steps to unhide columns:

  • Select the Adjacent Columns: First, select the columns next to the hidden ones. For example, if Column B is hidden, you should select Columns A and C.
Excel columns A and C selected on either side of hidden column B, ready to unhide it.
  • Open the Context Menu: Right-click on the selected columns to bring up the context menu. Alternatively, you can press the “Menu” key on your keyboard, which is located between the Right Alt key and the Right Ctrl key.
Excel right-click context menu on the selected columns, with Unhide listed at the bottom below Hide and Column Width.

Choose Unhide From the context menu, click on "Unhide." This action will make the hidden column(s) visible again. After completing these steps, you will see the previously hidden Column B appear.

How to Unhide Columns Using the Home Tab

The Home tab in Excel provides various tools for managing and formatting your data effectively. One useful feature in this tab is the option to unhide columns easily.

Follow these steps to unhide columns using the Home tab:

  • Select the Area with Hidden Columns: Begin by selecting the columns around the hidden ones. Click on the header of the column to the left of the hidden columns, hold down the Shift key, and then click on the header of the column to the right of the hidden columns.
  • Navigate to the Home Tab: Click on the Home tab at the top of the Excel window.
Excel Home tab Format menu in the Cells group with Hide & Unhide expanded to show the Unhide Columns option.
  • Access the Cells Group
    In the Cells group, find and click on the "Format" option.
  • Choose Unhide Columns
    From the drop-down menu, select "Hide & Unhide," and then click on "Unhide Columns."

Once you select "Unhide Columns," the hidden columns will become visible again.

Unhiding Columns with Keyboard Shortcuts

Using keyboard shortcuts in Excel can significantly speed up the process of unhiding columns. Here are some effective shortcuts you can use:

  • ALT + H + O + U + L : This combination of keys will unhide any hidden columns in your Excel worksheet.
  • ALT + O + C + U : This is another keyboard shortcut that achieves the same result as the previous one, allowing you to quickly unhide columns.
  • CTRL + SHIFT + 0 : This shortcut specifically unhides columns that are hidden within the selected area of your worksheet.
  • Note that the last key in this combination is the number zero, not the letter "O."

Unhiding Columns Using Mouse Techniques

In addition to keyboard shortcuts, you can also use mouse techniques to unhide columns in Excel. Here’s how to do it:

Steps to Unhide Columns with the Mouse

  • Identify the Hidden Column(s) - Look for a gap or a double line between the visible column headers. This indicates that there are hidden columns in that area.
  • Hover Over the Gap- Move your cursor to the right of the hidden column(s). When positioned correctly, the cursor will change to a symbol that looks like two parallel lines with two horizontal arrows.
Excel column headers with hidden column B, its narrow gap between A and C boxed in red where the cursor drags to unhide.
  • Click on the double lines and drag them to the right. This action will reveal the hidden column(s) as you pull the boundary.
  • Once the hidden column(s) are visible, release the mouse button. You can then adjust the column width if needed to ensure the data is displayed properly.

Let’s make AP
work for you.