If you can’t see certain rows or columns in Microsoft Excel 2016, it may be because they are hidden. Here’s how to unhide rows or columns.
- 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.
Stuart’s tip did not work for me, however, when I selected all rows & columns, clicked on ‘View’ tab, then clicked on Freeze Panes, and had the option to unfreeze. That worked!
Stuart’s tip worked for unhiding rows. I had already tried, unsuccessfully, to unhide the typical way and tips from other posts.
Thank you Stuart!
Here’s the simple way, using shortcut
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
I’ve tried it and works in excel 2007, 2010 and 2013.
Does not seem to work when columns A to E are hidden and cells F1 to H1 are merged.