Formatting Issues

How to Unhide Missing Columns A Through C in Excel

Jason MillerJason Miller Oct 29, 2026 873 views

Question details

The user is unable to view or restore hidden columns A, B, and C in their worksheet, and standard refreshing does not make them visible.

How to Unhide Missing Columns A Through C in Excel
Product
Excel
Device & OS
not provided
Scenario
Attempting to restore the visibility of the first three columns (A through C) to access or format the data within them.
Observed behavior
Columns A through C remain hidden and inaccessible, even after refreshing the worksheet.
Before you start

Ensure that your worksheet is not protected by a password, as sheet protection restricts formatting changes such as unhiding columns. Check the Review tab to unprotect the sheet if necessary.

Solution 1Recommended

Use the Select All Method to Unhide Columns

Because columns A through C are at the very beginning of the sheet, you cannot select the columns on both sides. Selecting the entire worksheet ensures the hidden columns are included before you apply the unhide command.

This is the most reliable and straightforward method when the first column (Column A) is hidden.

1
Select the entire worksheet

Click the small triangle button in the top-left corner of the worksheet, exactly where the row numbers and column letters intersect. Alternatively, press Ctrl + A on your keyboard.

2
Open the context menu

Right-click on any visible column letter header (such as D or E) at the top of the worksheet.

3
Unhide the columns

Select 'Unhide' from the right-click context menu. Columns A, B, and C should now be visible.

Use the Select All Method to Unhide Columns
Shortcut Tip: After selecting the entire worksheet, you can also go to Home > Format > Hide & Unhide > Unhide Columns.
Seamless Spreadsheet Management

Unhide Columns and Manage Data Effortlessly in WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive and familiar interface to manage, format, and organize your data. Whether you need to unhide missing columns, unfreeze hidden panes, or apply advanced filters, WPS Office equips you with all the essential tools in a free, lightweight application.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet file.
  2. 2. Select the entire sheet: Click the blank square in the top-left corner (above row 1 and left of column A) to highlight the whole worksheet.
  3. 3. Unhide the columns: Navigate to the Home tab, click the 'Row and Column' button, select 'Hide and Unhide', and choose 'Unhide Columns'.
Fully compatible with Microsoft Excel (.xlsx, .xls) files without formatting loss.Easily accessible Format menus for hiding and unhiding rows or columns.Lightweight software that launches quickly and runs smoothly on all devices.Free built-in premium templates and advanced data analysis features.
QA img-9

Frequently Asked Questions

Why is the Unhide option greyed out in Excel?

If the Unhide option is disabled or greyed out, your worksheet or workbook is likely protected. You must navigate to the Review tab and click 'Unprotect Sheet' or 'Unprotect Workbook'. You may be prompted to enter a password if the creator set one.

Is there a keyboard shortcut to unhide columns?

Yes. First, select the columns surrounding the hidden ones (or press Ctrl + A to select the entire sheet), then press Ctrl + Shift + 0 (zero) on your keyboard. Note that on some Windows PCs, this shortcut is reserved by the system for switching keyboard layouts and must be disabled in Windows Settings to work in Excel.

Can adjusting column width unhide columns A through C?

Yes. Sometimes columns are not technically 'hidden' but have their width set to zero. You can select the entire worksheet (Ctrl + A), hover your cursor over the boundary of a visible column header until it turns into a double-headed arrow, and double-click to auto-fit the column widths, which will restore the narrow columns.

Does applying a filter hide columns permanently?

No, standard data filtering only hides rows that do not match your filter criteria, not columns. If whole columns are missing, the issue is related to the Hide command, a zero column width, or frozen panes.