Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking selected cells on multiple worksheets
I would like to lock only a few cells on many worksheets
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking selected cells on multiple worksheets
Tell us the criteria for locking these cells or are they a fixed address in
each sheet? Mike "Andre" wrote: I would like to lock only a few cells on many worksheets |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking selected cells on multiple worksheets
By default, all cells are locked. To lock only some cells and leave
the rest unprotected, you need to first unlock all cells. To do this, click the select-all button -- the gray box above the row number and to the left of the column letters (or press CTRL A twice) -- and then go to the Format menu, chose Cells, then the Protection tab, and uncheck the "Locked" option. Click OK. Then, select the cells that you want to lock. go back to the format cells dialog and check the "Locked" option. When you Protect the worksheet, only those cells will be locked. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 5 Dec 2008 03:48:12 -0800, Andre wrote: I would like to lock only a few cells on many worksheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do multiple cells get selected when i click only one cell? | Excel Discussion (Misc queries) | |||
Locking non-blank cells of all worksheets before closing the workb | Excel Discussion (Misc queries) | |||
Print selected pages from multiple worksheets | Excel Discussion (Misc queries) | |||
Locking Cells or worksheets | Excel Worksheet Functions | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) |