View to show which cells are locked/unlocked

Is there a way to easily view which cells are locked / unlocked without having to go into each one and checking its' format to see if the "Locked Cell" box is ticked? This would be really handy if y...

excel

Jon Layton

Copper Contributor

Sep 21, 2018

Haytham,

Thank you, I had thought of doing it this way and it will work for my application, however I was looking for a view that would not affect my print (although for my spreadsheet I have picked a very light fill colour).

Grateful for your support.

Cheers

Haytham Amairah

Silver Contributor

Sep 21, 2018

Hi Jon,

You have many options in the Format Cells dialog box.

For example, you can use the Border or the Font color instead of the Fill color to make the effect on your existing format as less as possible.

Also, you can detect the unlocked cells in your workbook by using the Workbook Analysis which is one of the tools available in the https://support.office.com/en-us/article/Turn-on-the-Inquire-add-in-6BC668E2-F3C6-4729-8CE1-75EA20AA9D90.

Please note that the Inquire Add-in is only available in the Excel 2013 or later (Professional Plus Edition).

But the problem with this add-in is that it does not work correctly as I have some unlocked cells in my worksheet but they are not detected by the analysis as you see in the screenshot below.

I don't know what is the problem!

However, I sent feedback to Microsoft about this issue.

Regards

Forum Discussion

View to show which cells are locked/unlocked