Only two columns allowed to enter data?

G

G Lam

Hi, is it possible to have only two columns, say, Column B & E in a
worksheet to allow user entering data?
How can I do that?
Thank you.
GL
 
D

duane

format those cells as unlocked (make sure the rest are locked), and the
turn on worksheet protection (tools, protection
 
G

Gord Dibben

By default all cells are "locked" when sheet is protected.

Select columns B and E.

Format>Cells>Protection. Unlock the cells(take checkmark out of option box).

OK your way out.

Tools>Protection>Protect Sheet. This is a must!!

If using Excel 2002 or 2003 note the options you can select when the Sheet
Protect dialog comes up.

Gord Dibben Excel MVP
 
Top