| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protecting specific columns in a worksheet
How can I protect two columns in a sheet. Eg. I could enter data in any cell
except in the cells of colums K and M. -- Many Thanks. Regards, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
protecting specific columns in a worksheet
"Polochilde" wrote in message
... How can I protect two columns in a sheet. Eg. I could enter data in any cell except in the cells of colums K and M. -- Many Thanks. Regards, You need to lock the cells. How you do that depends on the version of Excel you have - press F1 and read the help file for 'lock cells' |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
protecting specific columns in a worksheet
Select the whole worksheet ( Ctrl A )
Format menu ( Ctrl 1) Protection tab uncheck "lock" OK Select columns K and M Ctrl 1 Protection tab CHECK " lock " OK Protect whole worksheet : toolsprotectionprotect sheet and choose a password, password again OK "Polochilde" wrote: How can I protect two columns in a sheet. Eg. I could enter data in any cell except in the cells of colums K and M. -- Many Thanks. Regards, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
protecting specific columns in a worksheet
Thank you. This was very helpful.
-- Many Thanks. Regards, "FC" wrote: Select the whole worksheet ( Ctrl A ) Format menu ( Ctrl 1) Protection tab uncheck "lock" OK Select columns K and M Ctrl 1 Protection tab CHECK " lock " OK Protect whole worksheet : toolsprotectionprotect sheet and choose a password, password again OK "Polochilde" wrote: How can I protect two columns in a sheet. Eg. I could enter data in any cell except in the cells of colums K and M. -- Many Thanks. Regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting specific columns within a worksheet | Excel Worksheet Functions | |||
| protecting specific parts of my worksheet. | New Users to Excel | |||
| How To Lock Cells and Columns without Protecting Worksheet | Excel Worksheet Functions | |||
| can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions | |||
| Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
Hybrid Mode
