Unhide Columns and Troubleshoot a Gray Area in Excel for the Web
Question details
The user wants to remove a gray area on the right side of a worksheet and reveal any hidden columns.

- 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.
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.
Unhide all columns in the worksheet
Use this method when you are unsure which columns are hidden or need to check the entire sheet.
Click the Select All corner above row 1 and to the left of column A. Alternatively, click a cell and press Ctrl+A twice.
Right-click a column header in the selected worksheet and choose Unhide.
Look at the column headers and the right side of the worksheet to see whether the missing columns and cells are visible.

Unhide columns between visible column headers
Use this method when the column letters reveal a specific hidden range.
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.

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.




