Hi There,

1.
Can someone give me suggestion about data entry on a huge Excel Spreadsheet?
What is the best approach to this? I often found that user always got
confused in this rows & rows and columns & columns of spreadsheet that they
need to enter some data?
What would you do to clear the confusion?

2.
Is there a way to do a Data Validation that will validate the data for user
to input an "X" only in one cell out of the three cells in a row?
This is a data collection process after a survey. Ex: there are 3 answers
to a question, and only one answer should be selected.
Is there a way to validate this in Excel. Please keep in mind that there
are more than one questions, and each question has different set of answers.

Thank you,
Neon520