• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Unhide Columns in Excel

March 1, 2021 by Andrew Childress
Hide columns in Excel

Is something just... missing from your spreadsheet? Maybe it's a hidden column! Here's a guide on how to unhide columns in Excel.

Is something just… missing from your spreadsheet? Maybe it’s a hidden column! Here’s a guide on how to unhide columns in Excel.

Hidden columns are useful if the spreadsheet is becoming a bit messy. Sometimes, spreadsheet creators will hide columns to make the file more readable. The problem is that if you aren’t familiar with the file, you might miss out on the important details that you need to know.

Let’s learn how to find and unhide columns in Excel.

How to Spot Hidden Columns in Excel

So, how do you know if you have hidden columns? If you know the alphabet, you can spot a hidden column. It will show up as a missing letter when reviewing the spreadsheet’s column labels.

At the top of Excel’s grid, keep an eye out for non-consecutive letters in the spreadsheet. In the example below, you can see that column C isn’t visible, and in its place is a thick double line. This shows that you might need to unhide columns in Excel.

Hidden column Excel

How to Unhide Columns in Excel

Ready to unhide and reveal the secret of the spreadsheet? It’s simple to unhide columns in Excel.

Check out the example below. All you have to do is highlight the columns surrounding the hidden column, and then right-click. Choose Unhide. Presto! You can now see your hidden column, restored into view.

unhide columns animation

How to Unhide Every Column

What if your spreadsheet has many hidden columns? Or, maybe you don’t have time reciting the alphabet while scanning for missing columns? Let’s learn how to unhide all columns without checking each column one-by-one.

Start by clicking the arrow in the upper-left corner of Excel’s grid. This selects all rows and columns across the entire spreadsheet.

Select all Excel

Then, use this keyboard shortcut to unhide all columns:

Ctrl + Shift + 9

Now, all of your columns are back in view.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Merge Cells in ExcelMerge Cells in Excel
Next Post:Pie Chart in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top