Document Editing Problems

Unhide Columns and Troubleshoot a Gray Area in Excel for the Web

Amos GikundaAmos Gikunda Nov 18, 2026 869 views

Question details

The user wants to remove a gray area on the right side of a worksheet and reveal any hidden columns.

Unhide Columns and Troubleshoot a Gray Area in Excel for the Web
Product
Microsoft Excel for the web
Device & OS
not provided
Scenario
Copying, navigating, and pasting cells in a worksheet.
Observed behavior
A blank gray area appears on the right side of Excel while the user works with cells.
Before you start

Open the affected workbook in Excel for the web and check the column letters near the gray area for gaps. A gap in the sequence can indicate hidden columns.

Solution 1Recommended

Unhide all columns in the worksheet

Use this method when you are unsure which columns are hidden or need to check the entire sheet.

1
Select the worksheet

Click the Select All corner above row 1 and to the left of column A. Alternatively, click a cell and press Ctrl+A twice.

2
Unhide the columns

Right-click a column header in the selected worksheet and choose Unhide.

3
Check the gray area

Look at the column headers and the right side of the worksheet to see whether the missing columns and cells are visible.

Unhide all columns in the worksheet
If the gray area remains: Unhiding columns only addresses hidden columns. If the area remains, it may have another cause.
Free Microsoft Office alternative

Work with Hidden Columns in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open your Excel workbook in WPS Spreadsheets to work with its columns, though WPS does not fix a display issue in Excel for the web itself.

Show hidden worksheet columns in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for an easier transition from ExcelWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

How can I tell whether columns are hidden in Excel for the web?

Check the column letters for a gap, such as C followed by F. Select the headers on either side, right-click a selected header, and choose Unhide.

How do I unhide the first column if column A is missing?

Click the Select All corner above row 1 and to the left of the column headers. Right-click a column header and choose Unhide.

What should I do if unhiding columns does not remove the gray area?

Check whether the column letters are now consecutive. If they are and the gray area remains, hidden columns may not be its cause.

Can I select the whole worksheet without using the mouse?

Click a cell in Excel for the web and press Ctrl+A twice to select the full worksheet. You can then right-click a column header and choose Unhide.