Apps Microsoft Office Productivity How-To

How to Unhide Rows and Columns in Excel

Learn how to unhide specific rows, all rows, specific columns, and all columns in Excel to reveal all the hidden data.

Learn how to unhide specific rows, all rows, specific columns, and all columns in Excel to reveal all the hidden data.

by Raj Kumar

Hidden rows and columns in Excel can lead to missing data in your spreadsheets, causing confusion or errors in your work. Thankfully, Excel provides several ways to unhide these rows and columns, ensuring you have full access to all your data.

Unhiding Rows in Excel

Identifying hidden rows in Excel is straightforward. If a row number is missing and there’s a double line between adjacent row numbers, it indicates that a row is hidden between them.

Select the rows above and below the hidden row by clicking on their row numbers. For example, if row 2 is hidden between rows 1 and 3, select rows 1 and 3.
Right-click on the selected rows and choose Unhide from the context menu. This will reveal the hidden row.

Alternatively, you can use the Ribbon commands to unhide rows:

Select the rows surrounding the hidden row.
Navigate to the Home tab on the Excel ribbon.
Click on the Format option in the Cells group.
In the dropdown menu, hover over Hide & Unhide and select Unhide Rows.

You can also adjust the row height to reveal a hidden row:

Place your cursor on the boundary between the row numbers of the rows above and below the hidden row. The cursor will change to a double-headed arrow.
Click and drag downward to adjust the row height and unhide the hidden row.

Unhiding Multiple Rows or All Rows

To unhide multiple hidden rows or all hidden rows in your worksheet, you can select all the rows:

Click the Select All button at the top-left corner of the worksheet, or press Ctrl + A to select the entire worksheet.
Right-click anywhere on the selected row numbers and choose Unhide from the context menu.

Unhiding Columns in Excel

Hidden columns in Excel can also conceal important data. Similar to rows, hidden columns can be identified by missing column letters and a double line between column headers.

To unhide a hidden column using the right-click method:

Select the columns adjacent to the hidden column by clicking on their column letters. For example, if column B is hidden between columns A and C, select columns A and C.
Right-click on the selected columns and choose Unhide from the context menu. The hidden column will now be visible.

You can also use the Ribbon to unhide columns:

Select the columns surrounding the hidden column.
Go to the Home tab on the Excel Ribbon.
Click on the Format option in the Cells group.
Hover over Hide & Unhide and select Unhide Columns.

To unhide a column by adjusting its width:

Place your cursor on the boundary between the column headers of the columns adjacent to the hidden column. The cursor will change to a double-headed arrow.
Click and drag to the right to adjust the column width and reveal the hidden column.

Unhiding Multiple Columns or All Columns

To unhide multiple hidden columns or all hidden columns in your worksheet:

Select the entire worksheet by clicking the Select All button at the intersection of the row numbers and column letters, or press Ctrl + A.
Right-click on any column header and choose Unhide from the context menu.

By following these methods, you can easily unhide any rows or columns in your Excel worksheet, ensuring all your data is visible for analysis and presentation.

Keep reading

More from Apps

All Apps guides →