Knowledgebase: Microsoft Excel
Use data forms (Data menu, Form command).
Posted by - NA - on 17 April 2006 01:03 AM
Solution:

Move to the same field in the next record.
DOWN ARROW

Move to the same field in the previous record.
UP ARROW

Move to each field in the record, then to each command button.
TAB and SHIFT+TAB

Move to the first field in the next record.
ENTER

Move to the first field in the previous record.
SHIFT+ENTER

Move to the same field 10 records forward.
PAGE DOWN

Start a new, blank record.
CTRL+PAGE DOWN

Move to the same field 10 records back.
PAGE UP

Move to the first record.
CTRL+PAGE UP

Move to the beginning or end of a field.
HOME or END

Extend selection to the end of a field.
SHIFT+END

Extend selection to the beginning of a field.
SHIFT+HOME

Move one character left or right within a field.
LEFT ARROW or RIGHT ARROW

Select the character to the left within a field.
SHIFT+LEFT ARROW

Select the character to the right within a field.
SHIFT+RIGHT ARROW

(145 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion