howto.org.in

How to Unhide Columns in Excel

Learn how to unhide columns in Excel using right-click, Format menu, keyboard shortcuts, Name Box, troubleshooting, mistakes, and FAQs.

DocumentsEdited by Pramod Tiwari
2 min read

Quick Answer

To unhide columns in Excel, select the columns on both sides of the hidden area, right-click the selection, and choose Unhide.

Methods

  • Excel workbook
  • Hidden columns
  • Mouse or keyboard
  • Worksheet access
  • Password if sheet is protected

Safety Precautions

  • Save a copy before changing important spreadsheets.
  • Do not unhide sensitive data on a shared screen.
  • Protected sheets may require permission.
  • Check formulas before deleting or moving revealed columns.
  • Be careful with filtered or grouped columns, which are different from hidden columns.

Step-by-Step Instructions

  1. Step 1

    Find hidden area

    Look for skipped column letters, such as A, B, D.

  2. Step 2

    Select surrounding columns

    Select the column before and after the hidden column.

  3. Step 3

    Right-click selection

    Right-click the selected column headers.

  4. Step 4

    Choose Unhide

    Click Unhide to reveal the hidden column.

  5. Step 5

    Use Format menu

    Go to Home > Format > Hide & Unhide > Unhide Columns if needed.

  6. Step 6

    Check protection

    If unhide fails, see whether the sheet is protected.

  7. Step 7

    Review revealed data

    Confirm formulas and data now display correctly.

Practical Example

Example: Column C is hidden, so you select columns B and D, right-click, choose Unhide, and column C appears.

Common Mistakes

  • Selecting only one side
  • Confusing hidden with filtered
  • Forgetting frozen panes
  • Trying on a protected sheet
  • Sharing sensitive revealed columns
  • Deleting columns after revealing them by mistake

Troubleshooting

Unhide does not work

Select columns on both sides or check if the sheet is protected.

Column A is hidden

Use the Name Box to select A1, then use Format > Unhide Columns.

Rows or columns look collapsed

Check grouping outline controls as well as hidden columns.

Data still missing

Check filters, hidden rows, or another worksheet.

FAQs

How do I know a column is hidden?

Column letters skip, or the border between columns looks thicker.

Can I unhide all columns at once?

Yes, select the whole sheet and use Unhide Columns.

How do I unhide column A?

Use the Name Box or select all cells, then use the Format menu.

Why can’t I unhide a column?

The sheet may be protected, filtered, grouped, or not selected correctly.

Technology2 min read

How to Lock Row in Excel

Learn how to lock a row in Excel with Freeze Panes, keep headers visible, avoid mistakes, troubleshoot, and understand protection vs freezing.

Documents2 min read

How to Wrap Text in Excel

Learn how to wrap text in Excel with the Wrap Text button, row height, line breaks, merged-cell caveats, troubleshooting, and FAQs.

Help us improve this guide

Tell us about an outdated instruction, unclear step, broken link or safety concern. Do not include passwords, account numbers, medical records or other sensitive information.

Email a correction or suggestion