Only two columns allowed to enter data?

  • Thread starter Thread starter G Lam
  • Start date Start date
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
 
format those cells as unlocked (make sure the rest are locked), and the
turn on worksheet protection (tools, protection
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel Comparing two columns 1
counting blank cells within two columns 2
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Do not allow an entry in a cell if another cell has an entry. 5
How do I restrict data entry to one of two columns 2
Importing data from Excel worksheet into Excel template 2

Back
Top