View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Boo Boo is offline
external usenet poster
 
Posts: 21
Default 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.