Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROTECTING CELLS
I am having trouble protecting some cells. I mark all the required cells to
be locked, then apply the Protect to the spreadsheet. Some cells are locked and some are not. What's up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROTECTING CELLS
Hi there try this make sure the sheets to be protected are not selected but
only those that will not be protected and uncheck the locked cell box in protection tab and then go and to review and protect your sheet you 'll be ok "LOCKING CELLS" wrote: I am having trouble protecting some cells. I mark all the required cells to be locked, then apply the Protect to the spreadsheet. Some cells are locked and some are not. What's up? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PROTECTING CELLS
EXCEL 2007
This may help you:- Take the following actions assuming that the range that you wish to, "lock" is D 83 to D 85. 1. Go into you Worksheet and click on cell to the left of column A and above the number 1. This should highlight the whole Worksheet. 2. Ctrl + 1 (at the same time) / Custom Lists pane should launch (sometimes this window has a different name because there is a bug in the software here) / go to the Protection tab / remove the tick (check) from the Locked field and hit OK. 3. Now go back to your Worksheet and highlight cells D83 to D 85 only / Ctrl + 1 again / Custom Lists should launch / go to Protection tab again and place a tick (check) in the Locked field / OK. 4. Home tab / Cells group / Format / Protect Sheet / Protect Sheet window should launch / put a password of your choice in / hit OK / put password in again / OK. 5. Now to test that it has worked go back to cells D 83 to D 85. If you try to enter info into any of those 3 cells you will not be able to but you will be able to see the formulas there. 6. You should be able to enter data into all other cells in the Worksheet. If my comments have helped please hit Yes. Thanks. "LOCKING CELLS" wrote: I am having trouble protecting some cells. I mark all the required cells to be locked, then apply the Protect to the spreadsheet. Some cells are locked and some are not. What's up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting Cells | Excel Discussion (Misc queries) | |||
protecting the cells | Excel Discussion (Misc queries) | |||
Protecting Cells | Excel Discussion (Misc queries) | |||
Protecting cells | Excel Discussion (Misc queries) | |||
Protecting Cells | Excel Worksheet Functions |