How to enable hidden rows and columns in document inspector

Occasional Visitor

Due to technical error, I was following a suggestion to disable "hidden rows and columns" in document inspector, and now I can not inspect hidden rows/columns in all my excel documents. How to enable it? 

2 Replies


If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!

Please include your Excel version, sample file, and a bit of context to help others answer your question.

Link with more Information

Welcome to your Excel discussion space!


Thank you for your understanding and patience



I know I don't know anything (Socrates)



The answer might be too late but I faced the same issue today and solved it by enabling the Hidden Rows & Columns option for Document Inspector.

Go to File > Options > Add-Ins

Then under Manage drop-down select "Disabled Items" and press Go.

Then select Hidden Rows & Columns and press Enable.