How to Unhide Missing Columns A Through C in Excel
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.

- 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.
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.
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.
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.
Right-click on any visible column letter header (such as D or E) at the top of the worksheet.
Select 'Unhide' from the right-click context menu. Columns A, B, and C should now be visible.

Locate Column A Using the Go To Feature
If standard selection fails, you can force Excel to navigate directly to a cell within the hidden columns (like A1) to reveal them.
Check and Unfreeze Panes
Sometimes columns are not actually hidden but are instead frozen out of view because the user scrolled to the right while 'Freeze Panes' was active.
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. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet file.
- 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. Unhide the columns: Navigate to the Home tab, click the 'Row and Column' button, select 'Hide and Unhide', and choose 'Unhide Columns'.

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.




