Navigation and Data Editing of MS-Office Excel 2010

                         Navigation and Data Editing

Arrow keys Move to new cells	ALT + ENTER Start new line in same cell
ALT + Display = a drop-down list	SHIFT + Arrow keys Highlight within cells
ALT + Tab = Switch programs	SHIFT + CTRL + Arrow keys Highlight contiguous items
CTRL + Pg Up/Down = Switch worksheets	BACKSPACE Delete preceding character
CTRL + Tab = Switch workbooks	DELETE Delete character to the right
CTRL + Arrow keys Go to end of contiguous range	F4 Anchor “Fix” Cells
SHIFT + Arrow keys Select a cell range	ESC Cancel a cell entry
SHIFT + CTRL + Arrow keys Highlight contiguous range	F7 Spell check
Home Move to beginning of line	SHIFT + F2 Insert a comment
CTRL + Home Move to cell “A1”	CTRL + F3 Name a cell
F5 “Go to”	ALT + N + V Pivot table
ENTER Move to cell below	ALT + N + K Insert charts
SHIFT + ENTER Move to cell above	ALT + P + S + P Page setup
TAB Move to cell to the right	ALT + A + S Sort options
SHIFT + TAB Move to cell to the left	ALT + A + F + W Data from web
BACKSPACE Delete cell and get inside
DELETE Delete cell/selection
F2 Edit/ highlight dependent cells