Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Wednesday, July 25, 2018

EXCEL DATA FORMS SHORTCUT KEYS

EXCEL DATA FORMS SHORTCUT KEYS

TAB /SHIFT +TAB
Purpose:Use this excel shortcut key to Move to the next / previous field which can be edited. Move to the next / previous option.

ENTER /SHIFT +ENTER
Purpose:Use this excel shortcut key to Move to the first field in the next / previous record.

PAGE DOWN /PAGE UP
Purpose:Use this excel shortcut key to Move to the same field 10 records forward / back. Move one screen down / one screen up in a worksheet.

CTRL +PAGE DOWN
Purpose:Use this excel shortcut key to Move to a new record.

CTRL +PAGE UP
Purpose:Use this excel shortcut key to Move to the first record.

HOME /END
Purpose:Use this excel shortcut key to Move to the beginning / end of a field.

1 comment:

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...