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.
You Might Also Like
Hide and Unhide Rows and Columns in Google Sheets
Freeze or Unfreeze Panes, Columns, and Rows in Excel
Word 2016 & 2013: Divide Page Into Columns
Word 2019/2016: How to Hide or Unhide Text- Enable Slashes (/) in Excel 2016
Excel 2016: How to Install and Use Macros- Excel 2016: How to Lock or Unlock Cells
- Excel 2019 & 2016: Force "Open as Read Only" Prompt
Peter de Bruijn says
I agree with the first comment w/r/t the freeze option
Tom says
Agreed 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
Thank you Brad! I too had to “Unfreeze Panes” before i could see column A.
Brad Dyer says
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!
Susan says
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!
Stuart says
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.
Barton says
Does not seem to work when columns A to E are hidden and cells F1 to H1 are merged.