Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel should lock individual cells or range only
In excel you have to protect the entire worksheet and then select a range
that can be edited. You should also have a function if you want to protect individual cells only or a range of cells and the rest of the worksheet can be edited ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel should lock individual cells or range only
Your first statement is untrue, thus leading you to believe your second
statement to be true. By default all cells are locked when the sheet is protected. Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked" and OK. Select the cells you wish to lock and FormatCellsProtection. Check "locked" and OK. Now ToolsProtectionProtect Sheet. This is mandatory!! You can set a password to unprotect. These can easily be broken in Excel but will keep your formulas from being accidentally overwritten. Gord Dibben Excel MVP On Fri, 30 Jun 2006 09:21:02 -0700, centrality wrote: In excel you have to protect the entire worksheet and then select a range that can be edited. You should also have a function if you want to protect individual cells only or a range of cells and the rest of the worksheet can be edited ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN I EXPAND A RANGE IN A FUNCTION BEYOND 30 CELLS IN EXCEL? | Excel Discussion (Misc queries) | |||
Is there an add-in that will lock the cells like later versions of Excel? | New Users to Excel | |||
How to partially lock the cells in Excel? | Excel Discussion (Misc queries) | |||
How to center a title across a range of cells in Excel ? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel |