If you can’t see certain rows or columns in Microsoft Excel, it may be because they are hidden. Here’s how to unhide rows or columns.
Note: The steps illustrated are from desktop client versions of Microsoft Excel as well as Excel 365. Mobile versions have the same menus, but may require slightly different steps.
- Select the columns or rows that are before and after the one you would like to unhide.
- Select the “Home” tab.
- In the “Cells” area, select “Format” > “Hide & Unhide” > “Unhide Columns” or “Unhide Rows” as desired.
- The column or row should now be unhidden.
You can also use a shortcut to hide or unhide rows and columns
- Ctrl + Shift + 0 => to unhide the hidden columns within the selection
- Ctrl + Shift + 9 => to unhide the hidden rows within the selection
- Ctrl + 0 => to hide the selected columns
- Ctrl + 9 => to hide the selected rows
Why doesn’t hiding and unhiding work when I use these steps?
You may have to unfreeze the selection first. Click on the View tab, then select on Freeze Panes > Unfreeze Panes.