Arrow Keys

Movement in Cells

Ctrl+Home

Move to Beginning of Worksheet

Ctrl+PgDn

Switches between Worksheet Tabs(Right to Left)

Ctrl+PgUp

Switches between Worksheet from Left to Right

Ctrl+Tab

Go to Next Tab

Ctrl+Shift+Tab

Go to Previous Tab

Enter

Moves One Cell down in Selected Cell Range

Shift+Enter

Moves One Cell Up in Selected Cell Range

Home

Moves to Cell in Upper Left Corner of Window

PgDn

Select Cell in Next Screen in Same Column

PgUp

Select Cell in Previous Screen in Same Column

Tab

Move one cell to Right

Shift+Tab

Move one cell to Left

Ctrl+Arrow Keys

Select All Worksheet

Shift+PgDn

Select Cell Range from Current Cells to Next Screen of Same Column

Shift+PgUp

Select Cell Range from Current Cells to Previous Screen of Same Column

Alt+F11

Display MS Visual Basic Editor

F7

Display Spelling Check Dialog Box

Alt+F8

Display Macros Dialog Box to Run,Edit or Delete Macros

Alt+Space

Display Control Menu from Program Window

Ctrl+1

Display Format Cells Dialog Box

Ctrl+F1

Display Task Pane on Right Side of Program Window

Ctrl+G

Display Go to Dialog Box

Ctrl+H

Display Replace Dialog Box

Ctrl+F

Go to Find Dialog Box

Ctrl+P

Display Print Dialog Box

Ctrl+Shift+=

Display Insert Dialog Box

Shift+F10

Display Context Menu of Selected Item

Ctrl+O

Display Open Dialog Box

Alt+Enter

Starts New Line in Same Cell

Backspace

Clears the content of the active cell to reedit cell content

Ctrl+'

Enters the current time

Ctrl+;

Enters the current date

Ctrl+B

Applies or removes bold formatting

Ctrl+C

Copies the selected cells

Ctrl+D

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below

Ctrl+End

Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column

Ctrl+Enter

Fills the selected cell range with the current entry

Ctrl+I

Applies or removes italic formatting

Ctrl+N

Create New workbook

Ctrl+K

Displays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks

Ctrl+S

Saves the active file with its current file name, location, and file format

Ctrl+Shift+'

Enters the current time

Ctrl+Shift+;

Enters the current time

Ctrl+U

Applies or removes underlining

Ctrl+V

Paste

Ctrl+W

Closes the selected workbook window

Ctrl+X

Cuts the selected cells

Ctrl+Y

Repeats the last command or action, if possible

Ctrl+Z

Undo

F1

Help

F11

Insert chart

F12

Displays the Save As dialog box to save the file with a different name, type or location

F2

Edits the active cell and positions the insertion point at the end of the cell contents

F4

Repeats the last action of adding or deleting the Whole Row/Column