Moving within a Range Selection

Key(s)	What It Does
Enter	Moves the cell pointer. The direction depends on the setting in the Edit tab of the Options dialog box.
Shift+Enter	Moves the cell pointer up to the preceding cell in the selection
Tab	Moves the cell pointer right to the next cell in the selection
Shift+Tab	Moves the cell pointer left to the preceding cell in the selection
Ctrl+period (.)	Moves the cell pointer to the next corner of the current cell range
Shift+Backspace	Collapses the cell selection to just the active cell

Editing Keys in the Formula Bar

Key(s)	What It Does
F2	Begins editing the active cell
Arrow keys	Moves the cursor one character in the direction of the arrow
Home	Moves the cursor to the beginning of the line
End	Moves the cursor to the end of the line
Ctrl+right arrow	Moves the cursor one word to the right
Ctrl+left arrow	Moves the cursor one word to the left
F3	Displays the Paste Name dialog box when you are creating a formula
Ctrl+A	Displays the Function Arguments dialog box (after you type a function name in a formula)
Del	Deletes the character to the right of the cursor
Ctrl+Del	Deletes all characters from the cursor to the end of the line
Backspace	Deletes the character to the left of the cursor
Esc	Cancels the editing

Formatting Keys

Key(s)	What It Does
Ctrl+1	Displays the Format dialog box for the selected object
Ctrl+B	Sets or removes boldface
Ctrl+I	Sets or removes italic
Ctrl+U	Sets or removes underlining
Ctrl+5	Sets or removes strikethrough
Ctrl+Shift+~	Applies the general number format
Ctrl+Shift+!	Applies the comma format with two decimal places
Ctrl+Shift+#	Applies the date format (day, month, year)
Ctrl+Shift+@	Applies the time format (hour, minute, a.m./p.m.)
Ctrl+Shift+$	Applies the currency format with two decimal places
Ctrl+Shift+%	Applies the percent format with no decimal places
Ctrl+Shift+&	Applies border to outline
Ctrl+Shift+&	Removes all borders