Unable to Unhide Columns or Rows in Excel

It may not be a protection issue

There are certain situations when you can’t “unhide” columns on the left and/or rows at the top and it is not a sheet protection issue.

It is also not an unhiding issue. It is caused by Freeze Panes. It depends where you are when you set your Freeze Panes.

Freeze Pane is in the View ribbon.

Freeze Panes keeps certain rows at the top and columns to the left as you scroll around. But it can also stop you from seeing certain rows and columns.

If you have scrolled to the right and then set your Freeze Panes then it can stop you seeing the columns on the left.

If you have scrolled down the sheet and then set your Freeze Panes it can stop you seeing the rows at the top.

The easy solution if you want to see or unhide the rows or columns is to remove the Freeze Panes. The easy way to do that is to press in sequence

Alt w f f

This is a toggle command so you can also use it to apply Freeze Panes.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.