Formatting Issues

How to Unhide Excel Columns When Ctrl+Shift+0 Does Not Work

Aamir Naveed Akram Oct 8, 2026 869 views

Question details

The user needs alternative ways to unhide columns in a spreadsheet because the standard Ctrl+Shift+0 keyboard shortcut is unresponsive.

How to Unhide Excel Columns When Ctrl+Shift+0 Fails

Product: Microsoft Excel
Device & OS: Windows
Scenario: Attempting to unhide previously hidden columns to view or edit hidden data in an Excel workbook.
Observed behavior: The Ctrl+Shift+0 shortcut does not trigger the unhide action, typically due to Windows keyboard mapping overrides, regional settings, or software updates.

Before you start

Ensure your worksheet is not protected with a password, as worksheet protection disables the ability to format, hide, or unhide columns regardless of the method you use.

Solution 1Recommended

Use the Right-Click Context Menu

The fastest and most reliable alternative to the keyboard shortcut is using your mouse to access the right-click menu.

This method bypasses any keyboard shortcut conflicts caused by Windows settings or third-party applications. It works identically across all versions of Excel.

Select adjacent columns

Click and drag your mouse over the column headers on both sides of the hidden column. For example, if column C is hidden, click on column B's header and drag to column D's header.

Open the context menu

Right-click anywhere on the highlighted column headers.

Unhide the columns

Select 'Unhide' from the dropdown menu to instantly reveal the hidden columns.

Tip for Hiding Column A: If column A is hidden, you cannot click both sides of it. Instead, type 'A1' into the Name Box (located to the left of the formula bar), press Enter, then right-click the selected column header area and choose Unhide.

Solution 2

Use the Excel Ribbon Menu

Use Excel's built-in formatting tools on the ribbon if you prefer navigating through the official application menus.

WPS Spreadsheet Solution

Seamlessly Manage and Format Spreadsheets with WPS Office

WPS Office provides a highly intuitive interface for all spreadsheet operations, allowing you to hide and unhide rows or columns effortlessly without encountering shortcut conflicts. It is fully compatible with your existing Microsoft Excel files.

1. Open your file in WPS: Launch WPS Spreadsheets and open your existing .xlsx or .xls file.
2. Select adjacent columns: Highlight the column letters on both the left and right sides of your hidden columns.
3. Unhide via right-click: Right-click the selected headers and choose 'Unhide' from the context menu.
4. Alternative Ribbon method: You can also go to the Home tab, click on 'Rows and Columns', and select 'Unhide Columns'.

100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Bypasses conflicting regional keyboard shortcut issues for basic formatting tasksFree, lightweight, and fast-loading alternative for everyday spreadsheet needsFamiliar ribbon interface ensures a zero-learning-curve transition

microsoft office alternative - wps office

Frequently Asked Questions

Why did Ctrl+Shift+0 suddenly stop working in Excel?

This shortcut is often hijacked by Windows regional and language settings. Specifically, Windows uses Ctrl+Shift to switch between different keyboard layouts or input languages. When enabled at the operating system level, Windows intercepts the shortcut before it reaches Excel.

How can I change my Windows settings so Ctrl+Shift+0 works again?

Go to Windows Settings > Time & Language > Language (or Typing) > Advanced keyboard settings > Input language hot keys. Select 'Between input languages', click 'Change Key Sequence', and set both columns to 'Not Assigned'. Click OK to apply the changes.

Is there a different keyboard shortcut to unhide columns?

Yes. Instead of pressing keys simultaneously, you can use the ribbon access keys. Press and release the 'Alt' key, then press 'H' (for Home), 'O' (for Format), 'U' (for Hide & Unhide), and finally 'L' (for Unhide Columns).

How do I unhide all columns in the entire worksheet at once?

Click the small 'Select All' triangle button in the top-left corner of the worksheet where the row numbers and column letters intersect (or press Ctrl+A). Then, right-click any column header and select 'Unhide'.

Document & File Issues