Inside Microsoft Office

Visually pick out your protected cells

Inside Microsoft Office

by Kara Hiltz

You’re right. It’s difficult to get a handle on which cells you’ve protected and which cells anyone can edit freely. There’s no reason you should need to go through every cell in your worksheet and attempt to edit it – just to see if Excel locks you out. Imagine using that method in a worksheet with over a thousand rows!

Instead, you can use conditional formatting to apply a different color only to[…]


Subscribe to Inside Microsoft Office

(get full access to archives and more)