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.
Peter de Bruijn says
February 20, 2018 at 11:35 amI agree with the first comment w/r/t the freeze option
Tom says
November 3, 2017 at 5:54 pmAgreed with the other posts that my issue was a combination of unhide plus unfreeze panes. With the panes still frozen the rows and colums would not unhide. Seems like MSFT needs to make it easier to prompt users somehow, or have the unhide override the freeze panes issue. It took me quite a while to figure this out and I’ve been using Excel for 10+ years.
Aaron Arutunian says
October 25, 2017 at 6:54 pmThank you Brad! I too had to “Unfreeze Panes” before i could see column A.
Brad Dyer says
June 27, 2016 at 8:39 amStuart’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!
Susan says
June 7, 2016 at 8:47 amStuart’s tip worked for unhiding rows. I had already tried, unsuccessfully, to unhide the typical way and tips from other posts.
Thank you Stuart!
Stuart says
April 4, 2016 at 11:18 amHere’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.
Barton says
March 1, 2016 at 1:12 pmDoes not seem to work when columns A to E are hidden and cells F1 to H1 are merged.