| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking only one cell in Excel 2007
I am tring to lock only one cell in excel 2007 not the whole workbook. Can
any one help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking only one cell in Excel 2007
Hi mahan8
For every sheet in the workbook do this Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now Ctrl 1 to open the format cells dialog on the protection tab uncheck locked After you do this select the cell you want to lock Ctrl 1 to open the format cells dialog on the protection tab check locked Now protect every worksheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mahan8" wrote in message ... I am tring to lock only one cell in excel 2007 not the whole workbook. Can any one help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Locking only one cell in Excel 2007
Thank you it worked like a charm.
"Ron de Bruin" wrote: Hi mahan8 For every sheet in the workbook do this Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now Ctrl 1 to open the format cells dialog on the protection tab uncheck locked After you do this select the cell you want to lock Ctrl 1 to open the format cells dialog on the protection tab check locked Now protect every worksheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mahan8" wrote in message ... I am tring to lock only one cell in excel 2007 not the whole workbook. Can any one help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Textbox Locking | Excel Discussion (Misc queries) | |||
| "Locking" Question Regarding Excel 2007 | New Users to Excel | |||
| Outlook, Excel, Work 2007 locking up *BRAND NEW SYSTEM* | Excel Discussion (Misc queries) | |||
| The cursor is not locking onto cell in Excel | Excel Discussion (Misc queries) | |||
| excel 2007 file locking | Excel Discussion (Misc queries) | |||
Linear Mode
