Worksheet Tab Protection Icon in Excel 2011 | Excel Semi-Pro

Worksheet Tab Protection Icon in Excel 2011

by Gregory on May 11, 2011

There are times when you see something new and immediately know what it means. That’s what happened to me when I opened a file from a colleague and realized the padlock icon on the worksheet tab meant that the worksheet was protected. I was right.

Lock Icon on Worksheet Tab

Since I had opened this file in Excel 2011 (Mac) I immediately wondered if the Excel 2010 Window’s version had the same feature.

That would be a no.

It sure is nice to know that a worksheet is protected beforehand, instead of finding out by trial and error that a good number of Ribbon items are grayed out and not functional. It seems in Excel 2010 there is no real overt clue that a worksheet is protected.

Too bad. I like the intuitively obvious lock icon on the worksheet tab.

Maybe they’ll include this nice little feature when they program the next Windows version of Excel.

Related Posts Plugin for WordPress, Blogger...
Venus May 16, 2011 at 8:21 am

Wow, I’ve never seen this before. I don’t work with Excel 2011, and I agree with you, this would be a great feature in any version. It kind of makes me jealous.

stephane August 5, 2011 at 7:49 am

I find this icon very unpleasant.

Gregory August 5, 2011 at 11:19 am

@stephane I’m curious as to why you find the icon unpleasant.

Comments on this entry are closed.

Previous post:

Next post: