How do I prevent data from being entered into a particular cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a spreadsheet that has columns that automatically totals test
scores. I have noticed that on more that one occasion I accidentally entered
an amount in the totals column which screwed up my calculation. How do I
prevent myself from accidentally entering data in a totals column?
 
One way:

Select the cells where information CAN be entered. CHoose
Format/Cells/Protection and uncheck the Locked checkbox.

Choose Tools/Protection/Protect Sheet... (password optional).
 
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
Cell not calculating after importing data 2
Can I get a cell to automatically rezero after entering a value. H 1
Limiting raw score entries and possible pop up message alert? 1
requiring column entries 1
How do I sum numbers based on other data 6
How do I get data into next available cell in column? 1
Excel 2003 formula problem 1

Back
Top