How would I prevent users of a spreadsheet from deleting or adding columns
while still allowing data entry into all cells?

Thanks!
CC

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

Worked Great, thanks for your direction.

CC

"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

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

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

I am trying to work on a spread sheet, and i need to lock the information in
column a, so that i can type info into column b. i have tried to freeze it
but it only freezes halfway down the page. yet when i try to protect it, i
can't input any info in at all.

your help is greatly appreciated.


Chris

Freeze is a feature that keeps a certain part of the worksheet in view -
nothing to do with locking which prevents users from change data.

Two steps:
Select the cell that you want the user to be able to change; in the Format
dialog unlock these cells
On the Tools menu (in pre Excel 2007 versions), protect the worksheet
Now users can change only the unlocked cells
Note that in the protect step you can add a password fore unlocking; this is
OK for non-critical use but any one with Excel competence can find and
install a password unlocking utility.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Chris1234" wrote in message
...


I am trying to work on a spread sheet, and i need to lock the information
in
column a, so that i can type info into column b. i have tried to freeze it
but it only freezes halfway down the page. yet when i try to protect it, i
can't input any info in at all.

your help is greatly appreciated.


Chris

Hi,
I am using the latest version of Microsoft excel (.xlsx).
In a column, I just want one cell to be filled (at any time) and rest as
locked; but that cell could vary/be different.
And I should also be able to delete that cell and then be able to write on
any other cell on the same column (only one cell should be filled at any time
and rest should automatically be blocked). And I want this for say 100 rows.
E.g.:
Column A is the €˜timing slot; Row 1 is with the €˜staff name; and column B
to ZZ are blank where I will be putting €˜yes in each column but for one cell
only and if I try to enter €˜yes in another cell in the same column €“ it
must not allow me to do so until I delete the earlier entered/completed cell
(ie until I don't delete the €˜yes in the other cell of this column).
Thank you very much in advance.

On Monday, October 12, 2009 at 6:17:03 PM UTC+8, SK wrote:
Hi,
I am using the latest version of Microsoft excel (.xlsx).
In a column, I just want one cell to be filled (at any time) and rest as
locked; but that cell could vary/be different.
And I should also be able to delete that cell and then be able to write on
any other cell on the same column (only one cell should be filled at any time
and rest should automatically be blocked). And I want this for say 100 rows.
E.g.:
Column A is the €˜timing slot; Row 1 is with the €˜staff name; and column B
to ZZ are blank where I will be putting €˜yes in each column but for one cell
only and if I try to enter €˜yes in another cell in the same column €“ it
must not allow me to do so until I delete the earlier entered/completed cell
(ie until I don't delete the €˜yes in the other cell of this column).
Thank you very much in advance.

Hi,
How about in Google sheet? how to lock the columns and raw to another user and they should not able to delete or add any columns and raw but able to type or input to the cells.
Thanks in advance.