how to protect a column in a spreadsheet
 

I know you can hide columns and I know you can password protect a
spreadsheet. But is there a way to just protect one column in a spreadsheet?
I want the user to be able to see the values in, say, column B but not be
able to change anything in that column. Its a simple spreadsheet. Take
what's in column A, multiply by value in column B (don't want users to be
able to change this number) and put the final number in column C.

Thank you!

how to protect a column in a spreadsheet
 

Just as you would protect individual cells:

Format Cells... Protection

but first select the column rather than just a cell.
--
Gary''s Student - gsnu200720


"andi" wrote:

I know you can hide columns and I know you can password protect a
spreadsheet. But is there a way to just protect one column in a spreadsheet?
I want the user to be able to see the values in, say, column B but not be
able to change anything in that column. Its a simple spreadsheet. Take
what's in column A, multiply by value in column B (don't want users to be
able to change this number) and put the final number in column C.

Thank you!

how to protect a column in a spreadsheet
 

I could not get this to work. When I leave the sheet unprotected, the column
remains unprotected (even after formatcells protection) and it tells me
that locking cells has no effect unless the worksheet is protected. So
then I protected the worksheet, no password required, can't edit any cells.
Any other ideas?

"Gary''s Student" wrote:

Just as you would protect individual cells:

Format Cells... Protection

but first select the column rather than just a cell.
--
Gary''s Student - gsnu200720


"andi" wrote:

I know you can hide columns and I know you can password protect a
spreadsheet. But is there a way to just protect one column in a spreadsheet?
I want the user to be able to see the values in, say, column B but not be
able to change anything in that column. Its a simple spreadsheet. Take
what's in column A, multiply by value in column B (don't want users to be
able to change this number) and put the final number in column C.

Thank you!

how to protect a column in a spreadsheet
 

I think you misunderstood, first select the whole sheet, then do
formatcellsprotection, then deselect locked, now select your column, do
the same but check locked. Finally password protect the sheet


--
Regards,

Peo Sjoblom


"andi" wrote in message
...
I could not get this to work. When I leave the sheet unprotected, the
column
remains unprotected (even after formatcells protection) and it tells me
that locking cells has no effect unless the worksheet is protected. So
then I protected the worksheet, no password required, can't edit any
cells.
Any other ideas?

"Gary''s Student" wrote:

Just as you would protect individual cells:

Format Cells... Protection

but first select the column rather than just a cell.
--
Gary''s Student - gsnu200720


"andi" wrote:

I know you can hide columns and I know you can password protect a
spreadsheet. But is there a way to just protect one column in a
spreadsheet?
I want the user to be able to see the values in, say, column B but not
be
able to change anything in that column. Its a simple spreadsheet.
Take
what's in column A, multiply by value in column B (don't want users to
be
able to change this number) and put the final number in column C.

Thank you!

how to protect a column in a spreadsheet
 

Peo is absolutly correct. With the lock thou what do you want to lock out?
each thing in the checkoff list protects a different thing.

Peo Sjoblom wrote:
I think you misunderstood, first select the whole sheet, then do
formatcellsprotection, then deselect locked, now select your column, do
the same but check locked. Finally password protect the sheet

I could not get this to work. When I leave the sheet unprotected, the
column
[quoted text clipped - 22 lines]

Thank you!

--
Message posted via http://www.officekb.com

how to protect a column in a spreadsheet
 

yes! thank you - that did it!

"Peo Sjoblom" wrote:

I think you misunderstood, first select the whole sheet, then do
formatcellsprotection, then deselect locked, now select your column, do
the same but check locked. Finally password protect the sheet


--
Regards,

Peo Sjoblom


"andi" wrote in message
...
I could not get this to work. When I leave the sheet unprotected, the
column
remains unprotected (even after formatcells protection) and it tells me
that locking cells has no effect unless the worksheet is protected. So
then I protected the worksheet, no password required, can't edit any
cells.
Any other ideas?

"Gary''s Student" wrote:

Just as you would protect individual cells:

Format Cells... Protection

but first select the column rather than just a cell.
--
Gary''s Student - gsnu200720


"andi" wrote:

I know you can hide columns and I know you can password protect a
spreadsheet. But is there a way to just protect one column in a
spreadsheet?
I want the user to be able to see the values in, say, column B but not
be
able to change anything in that column. Its a simple spreadsheet.
Take
what's in column A, multiply by value in column B (don't want users to
be
able to change this number) and put the final number in column C.

Thank you!

how to protect a column in a spreadsheet
 

By default, all cells are protected when sheet protection is enabled.

Hit CTRL + a(twice in 2003) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK out.

Select the cells you want protected and FormatCellsProtection

Check "locked".

ToolsProtectionProtect Sheet. Note the options when protecting.

Supply a password and OK.

Excel's internal security is weak but this will prevent overwriting by accident.


Gord Dibben MS Excel MVP

On Thu, 10 May 2007 10:29:01 -0700, andi wrote:

I know you can hide columns and I know you can password protect a
spreadsheet. But is there a way to just protect one column in a spreadsheet?
I want the user to be able to see the values in, say, column B but not be
able to change anything in that column. Its a simple spreadsheet. Take
what's in column A, multiply by value in column B (don't want users to be
able to change this number) and put the final number in column C.

Thank you!