Unhide option is disabled in Excel

Question

Hi,

Usually we get unhide option when we select a range of columns or rows which has hidden columns/rows. But I am getting that option disabled. I can hide any row or column but I cannot unhide it!

Please see below image. I hid column H. Now I am selecting columns G to I, right click. I should get Unhide option enabled so that I can view column H again. I am getting that disabled.

Please help.

Thanks.

Answer 1

Hi Abh,

It seems that you enable some add-ins in your Excel 2016 applications. I suggest you run Excel 2016 in Safe Mode to check if the issue goes away. If yes, I suggest you disable some add-ins to see the result in the normal mode.

Meanwhile, I suggest you check if you are using the latest version of the Excel 2016 application. If no, update the version first, restart the computer and then do a test to see the outcome.

Moreover, upload a full screenshot of the Account page in the Excel 2016 application you are using. You can access the page via File>Account.

Note: Remove any private information before uploading the screenshots.

Thanks,

Cliff

Answer 2

Hi Abh,

May I know if you need further help on this issue?

Thanks,

Cliff