Cell protection short cut button

  • Thread starter Thread starter Bert
  • Start date Start date
B

Bert

I am using 2007 now insteat of 2003. I cant find a short cut button to lock
and unlock a cell. There was one in excel 2003 but as yet I can't find it in
2007. I know I can go into Format Cell and protection but I like the short
cut button.
 
You can add it to the QAT -- right-click any command & select Customize QAT,
select All Commands from the top dropdown, scroll to Lock Cell, and click
Add. Now it appears in the QAT.
HTH
Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Protection 3
Naming cells 2
Protect formulas which reference to unlocked cells in protected s. 5
I can still select & manipulate locked & protected cells in '07 1
worksheet protect 2
Short-cut is dead 2
Deleting Rows Containing Protected Cells 2
Please Help! Virus? Avast, Firefox, Windows update quit working 4

Back
Top