cells

G

Guest

Hello everyone...

I just have a quick question. I am using Excel 2003. I have a row of
cells, and I only want someone to be able to fill in (let's say) the number
5. Is there a way to "lock" the cell so they can't put another number in the
cell?

All help is greatly appreciated.

Very Respectfully,
Seabee Sweetie
 
G

Guest

Click on Data>Validation the complete the dialog to Allow - whole number,
Data - equal to, Value - 5 then click OK
 

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

Displaying zeros in cells 2
Bypass unlocked cell on protected worksheet in Excel 2003? 8
Numbers showing Up Centered in Cell ? 1
How to filter rows data based on background color of individual cells 1
fill any random cell in a column and block all other cells 5
How To Have A Cell Be Blank If... 2
Lookup Column Headings and Sum the Rows 3
Cell Reference & formula 5

Top