| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LOCK columns
Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent
accidental changes to the data? Thanks. |
|
#2
|
|||
|
|||
|
Have you considered looking in HELP index for protection?
-- Don Guillett SalesAid Software "Rebecca" wrote in message ... Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent accidental changes to the data? Thanks. |
|
#3
|
|||
|
|||
|
Rebecca
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. Gord Dibben Excel MVP On Fri, 25 Feb 2005 17:39:03 -0800, "Rebecca" wrote: Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent accidental changes to the data? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print excel columns on less pages | Excel Discussion (Misc queries) | |||
| How do I lock hidden columns? | Excel Worksheet Functions | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
| The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Linear Mode
