If not protect cells then

[Guest]

How can i protect column? For example i have table with 10 columns, what
will i do to to protect columns A to D?

Thank you very much

 

[Govind]

Hi,

You can only protect a sheet. If you want to protect a specific range
then protect a entire worksheet, leave the range you want to protect and
select the entire worksheet.Then go to format cells and go to protection
tab and uncheck the "Locked" checkbox.

Regards
Govind.

 

[Gord Dibben]

Tata

Select column E.

Hit SHIFT + END + RightArrow.

Format>Cells>Protection. Uncheck "locked"

Now Tools>Protection>Protect Sheet.

A to D will be locked.

Gord Dibben Excel MVP

 

[Guest]

Hello Mr. Dibben;

Thanks a lot for the online reply. The procedures you indicated below is
realy working but i noticed that still the entire worksheet is protected
instead the selected column.

Actually im making 15 columns Excel table shared to 3 departments. Columns
A to D are my inputs and i dont want other deparment can alter or modify on
it that is why i need to protect columns A to D. Other deparment can enter
only the columns that i allowed them and which i need them to fill up.

Is there any possibility Sir that columns A to D only can be protected?
Maybe i missed one instruction if you're successfull in protecting specific
columns. Which do you think i missed to follow?

Thank you very much for the assistance.

Tata
Cebu City Philippines

 

[Govind]

Hi,

The instructions given by Dibben & me precisely protect columns A to D
only. Follow the instructions carefully.

Regards

Govind.

 

[Gord Dibben]

Tata

Basics.......

To protect(lock) any portion of a worksheet, worksheet protection from
Tools>Protection MUST be enabled.

By default all cells are locked when protection is enabled.

You must designate to Excel which cells you want locked or unlocked.

Select all columns you wish to be unlocked(in your case, E through IV) then
Format>Cells>Protection. Remove the checkmark from "locked".

NOW.........you must enable worksheet protection.

A through D will be locked for editing. E through IV will not be locked, so
users can enter data in these columns.

Gord