ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cell protection short cut button (https://www.excelbanter.com/excel-worksheet-functions/227380-cell-protection-short-cut-button.html)

Bert

Cell protection short cut button
 
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.

Bob Umlas, Excel MVP

Cell protection 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

"Bert" wrote:

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.



All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com