How 2 lock row and column delete/add but allow data entry?
Please drop the all caps.......hard on the ears and difficult to read.
Please do not hijack existing posts when you could post your own.
To freeze column A select B1 and WindowFreeze Panes.
Gord Dibben MS Excel MVP
On Wed, 7 May 2008 10:24:01 -0700, VMJACOBS
wrote:
HOW DO I LOCK ONE COLUMN (NOT TO SCROLL) WHILE THE OTHERS ON THE SPREADSHEET
CONTINUE TO SCROLL
"Gord Dibben" wrote:
CTRL + a(twice in 2003) to select all cells.
FormatCellsProtection. Uncheck "locked" and OK
ToolsProtectionProtect Sheet.
Note the checkbox options to allow or disallow features.
Provide a password if required but be aware that this type of password is easily
cracked but will keep casual users from inserting columns.
Gord Dibben MS Excel MVP
On Wed, 21 Mar 2007 16:00:08 -0700, CC Santa Monica
wrote:
How would I prevent users of a spreadsheet from deleting or adding columns
while still allowing data entry into all cells?
Thanks!
CC
|