Is there a way to...
If you want to limit input to a certain range:
Select range
Format Cells Protection Tab Untick locked
Tools Protection Protect Sheet Make sure only tick is against "Select unlocked cells"
Set a password
OK
Re-type password
This will restrict users from selecting any cells other than the range you
specified. This keeps your data entry in the one place.
"caviking" wrote:
How do I mark the end of a spreadsheet? I want the cursor to jump down one
row and over to the first column instead of keep moving to the right and out
of my six cell spreadsheet. I am trying to simplify data entry by avoiding to
take the hand of the 10 key pad. Is this possible?
Thanks in advance for any help on this.
|