Excel 2010 Shortcuts Keyboard


KeyCommandDescription
Ctrl+OWorksheet Menu Bar->File->Open...
Ctrl+SWorksheet Menu Bar->File->Save
F12Worksheet Menu Bar->File->Save As...
Ctrl+F2Worksheet Menu Bar->File->Print Preview
Ctrl+PWorksheet Menu Bar->File->Print...
Ctrl+ZWorksheet Menu Bar->Edit->Undo Column Width
Ctrl+YWorksheet Menu Bar->Edit->Repeat Clear
Ctrl+XWorksheet Menu Bar->Edit->Cut
Ctrl+CWorksheet Menu Bar->Edit->Copy
Ctrl+VWorksheet Menu Bar->Edit->Paste
Ctrl+Alt+VWorksheet Menu Bar->Edit->Paste Special...
Ctrl+DWorksheet Menu Bar->Edit->Fill->DownFill Down
Ctrl+RWorksheet Menu Bar->Edit->Fill->RightFill Right
DelWorksheet Menu Bar->Edit->Clear->ContentsClear Contents
Ctrl+FWorksheet Menu Bar->Edit->Find...
Ctrl+HWorksheet Menu Bar->Edit->Replace...
Ctrl+GWorksheet Menu Bar->Edit->Go To...
Ctrl+F1Worksheet Menu Bar->View->Task Pane
Ctrl+Shift+=Worksheet Menu Bar->Insert->Insert Cells...
Shift+F11Worksheet Menu Bar->Insert->WorksheetInsert Worksheet
Shift+F3Worksheet Menu Bar->Insert->Function...Insert Function
F3Worksheet Menu Bar->Insert->Names->Paste...Paste Names
Ctrl+Shift+F3Worksheet Menu Bar->Insert->Names->Create...
Shift+F2Worksheet Menu Bar->Insert->New Comment
Ctrl+KWorksheet Menu Bar->Insert->Hyperlink...Insert Hyperlink
Ctrl+1Worksheet Menu Bar->Format->Cells...Datasheet Formatting
Ctrl+9Worksheet Menu Bar->Format->Row->Hide
Ctrl+Shift+(Worksheet Menu Bar->Format->Row->Unhide
Ctrl+0Worksheet Menu Bar->Format->Column->Hide
Ctrl+Shift+)Worksheet Menu Bar->Format->Column->Unhide
F7Worksheet Menu Bar->Tools->Spelling...
Alt+ClickWorksheet Menu Bar->Tools->Research...
Ctrl+`Worksheet Menu Bar->Tools->Formula Auditing->Formula Auditing Mode
Alt+F8Worksheet Menu Bar->Tools->Macro->Macros...View Macros
Alt+F11Worksheet Menu Bar->Tools->Macro->Visual Basic Editor
Ctrl+Shift+LWorksheet Menu Bar->Data->Filter Menu->AutoFilter
Shift+Alt+RightWorksheet Menu Bar->Data->Group and Outline->Group...
Shift+Alt+LeftWorksheet Menu Bar->Data->Group and Outline->Ungroup...
Ctrl+TWorksheet Menu Bar->Data->List->Create Table...
Alt+F5Worksheet Menu Bar->Data->Refresh
F1Worksheet Menu Bar->Help->Microsoft Excel Help
Ctrl+OChart Menu Bar->File->Open...
Ctrl+SChart Menu Bar->File->Save
Ctrl+F2Chart Menu Bar->File->Print Preview
Ctrl+PChart Menu Bar->File->Print...
Ctrl+ZChart Menu Bar->Edit->Undo Column Width
Ctrl+YChart Menu Bar->Edit->Repeat Clear
Ctrl+XChart Menu Bar->Edit->Cut
Ctrl+CChart Menu Bar->Edit->Copy
Ctrl+VChart Menu Bar->Edit->Paste
Ctrl+Alt+VChart Menu Bar->Edit->Paste Special...
Shift+F11Chart Menu Bar->Insert->WorksheetInsert Worksheet
Ctrl+KChart Menu Bar->Insert->Hyperlink...Insert Hyperlink
Ctrl+1Chart Menu Bar->Format->Cells...
F7Chart Menu Bar->Tools->Spelling...
Alt+F8Chart Menu Bar->Tools->Macro->Macros...View Macros
Alt+F11Chart Menu Bar->Tools->Macro->Visual Basic Editor
F1Chart Menu Bar->Help->Microsoft Excel Help
F9Calculate Now
Ctrl+Shift+=Insert Cells...
Ctrl+-Delete...
Ctrl+Alt+LCell->Filter->Reapply
Shift+F2Insert CommentNew Comment
Ctrl+KHyperlink...
Ctrl+NNew
Alt+=Standard->Auto Sum->Sum
Ctrl+BBold
Ctrl+IItalic
Ctrl+UUnderline
Ctrl+Shift+%Percent Style
Ctrl+Alt+Shift+TabDecrease Indent
Ctrl+Alt+TabIncrease Indent
Shift+Alt+RightPivotTable->Query and Pivot->Group and Outline->Group...
Shift+Alt+LefttPivotTable->Query and Pivot->Group and Outline->Ungroup...
Shift+F2New Comment
Ctrl+Alt+F5Refresh All
Shift+F2New Comment
Ctrl+Shift+TTotals Row
Ctrl+0Hide
Ctrl+Shift+)Unhide
Ctrl+9Hide
Ctrl+Shift+(Unhide
Ctrl+Shift+=Insert Cells...
Ctrl+-Delete...
Shift+F2Insert CommentNew Comment
Ctrl+0Hide
Ctrl+Shift+)Unhide
Ctrl+9Hide
Ctrl+Shift+(Unhide
Ctrl+Shift+=Insert Cells...
Ctrl+-Delete...
Shift+F2Insert CommentNew Comment
Ctrl+Sh+UExpand Formula Bar
Alt+F5Refresh
Shift+Alt+RightGroup...
Shift+Alt+LefttUngroup...
Ctrl+Shift+=Insert Cells...
Ctrl+-Delete...
Ctrl+Alt+LQuery->Filter->Reapply
Shift+F2Insert CommentNew Comment
Alt+F5Refresh
Ctrl+Shift+=Insert Cells...
Ctrl+-Delete...
Shift+F2Insert CommentNew Comment
Alt+F5Refresh
Ctrl+-Delete...
Alt+F5Refresh
Shift+Alt+RightLayout->Group and Outline->Group...
Shift+Alt+LefttLayout->Group and Outline->Ungroup...
Alt+F5Refresh
Shift+Alt+RightPivot Chart Popup->Group and Outline->Group...
Shift+Alt+LeftPivot Chart Popup->Group and Outline->Ungroup...
Alt+=Sum
Alt+F5Refresh
Ctrl+Alt+LList Range Popup->Filter->Reapply
Shift+F2Insert CommentNew Comment
Ctrl+KHyperlink...
Alt+F5Refresh
Shift+F2Insert CommentNew Comment
Ctrl+Shift+=Insert Cells...
Ctrl+-Delete...
Shift+F2Insert CommentNew Comment
Ctrl+KHyperlink...
Ctrl+Shift+=Insert Cells...
Ctrl+-Delete...
Shift+F2Insert CommentNew Comment
Ctrl+ZLegacy Keyboard Support->Edit->Undo Column Width
Ctrl+YLegacy Keyboard Support->Edit->Repeat Clear
Ctrl+XLegacy Keyboard Support->Edit->Cut
Ctrl+CLegacy Keyboard Support->Edit->Copy
Ctrl+VLegacy Keyboard Support->Edit->Paste
Ctrl+Alt+VLegacy Keyboard Support->Edit->Paste Special...
Ctrl+DLegacy Keyboard Support->Edit->Fill->DownFill Down
Ctrl+RLegacy Keyboard Support->Edit->Fill->RightFill Right
DelLegacy Keyboard Support->Edit->Clear->ContentsClear Contents
Ctrl+FLegacy Keyboard Support->Edit->Find...
Ctrl+HLegacy Keyboard Support->Edit->Replace...
Ctrl+GLegacy Keyboard Support->Edit->Go To...
Ctrl+F1Legacy Keyboard Support->View->Task Pane
Ctrl+Shift+=Legacy Keyboard Support->Insert->Insert Cells...
Shift+F11Legacy Keyboard Support->Insert->WorksheetInsert Worksheet
Shift+F3Legacy Keyboard Support->Insert->Function...Insert Function
F3Legacy Keyboard Support->Insert->Names->Paste...Paste Names
Ctrl+Shift+F3Legacy Keyboard Support->Insert->Names->Create...
Shift+F2Legacy Keyboard Support->Insert->New Comment
Ctrl+KLegacy Keyboard Support->Insert->Hyperlink...Insert Hyperlink
Ctrl+1Legacy Keyboard Support->Format->Cells...Datasheet Formatting
Ctrl+9Legacy Keyboard Support->Format->Row->Hide
Ctrl+Shift+(Legacy Keyboard Support->Format->Row->Unhide
Ctrl+0Legacy Keyboard Support->Format->Column->Hide
Ctrl+Shift+)Legacy Keyboard Support->Format->Column->Unhide
F7Legacy Keyboard Support->Tools->Spelling...
Alt+ClickLegacy Keyboard Support->Tools->Research...
Ctrl+`Legacy Keyboard Support->Tools->Formula Auditing->Formula Auditing Mode
Alt+F8Legacy Keyboard Support->Tools->Macro->Macros...View Macros
Alt+F11Legacy Keyboard Support->Tools->Macro->Visual Basic Editor
Ctrl+Shift+LLegacy Keyboard Support->Data->Filter Menu->AutoFilter
Shift+Alt+RightLegacy Keyboard Support->Data->Group and Outline->Group...
Shift+Alt+LeftLegacy Keyboard Support->Data->Group and Outline->Ungroup...
Ctrl+TLegacy Keyboard Support->Data->List->Create Table...
Alt+F5Legacy Keyboard Support->Data->Refresh
Ctrl+NAdd Command->File Well->New
F12Add Command->File Well->Save As...
Ctrl+PAdd Command->File Well->Print...
Ctrl+Alt+VAdd Command->Edit Well->Paste Special...
Ctrl+FAdd Command->Edit Well->Find...
Ctrl+HAdd Command->Edit Well->Replace...
Ctrl+GAdd Command->Edit Well->Go To...
Alt+;Add Command->Edit Well->Select Visible Cells
Alt+=Add Command->Insert Well->Auto Sum->Sum
Shift+F2Add Command->Insert Well->New Comment
Ctrl+1Add Command->Format Well->Cells...Datasheet Formatting
Ctrl+BAdd Command->Format Well->Bold
Ctrl+IAdd Command->Format Well->Italic
Ctrl+UAdd Command->Format Well->Underline
Ctrl+5Add Command->Format Well->Strikethrough
Ctrl+Alt+Shift+TabAdd Command->Format Well->Decrease Indent
Ctrl+Alt+TabAdd Command->Format Well->Increase Indent
Ctrl+Shift+%Add Command->Format Well->Percent Style
Ctrl+Shift+&&Add Command->Format Well->Apply Outline Borders
Ctrl+`Add Command->Tools Well->Formula Auditing Mode
Ctrl+Shift+&&Add Command->Tools Well->Outside Borders
Shift+F2Add Command->Tools Well->New Comment
Ctrl+TAdd Command->Data Well->Create Table...
Ctrl+Shift+TAdd Command->Data Well->Totals Row
Ctrl+Alt+F5Add Command->Data Well->Refresh All
Ctrl+Alt+F5Add Command->Data Well->Refresh All
Ctrl+OBuilt-in Menus->File->Open...
Ctrl+SBuilt-in Menus->File->Save
F12Built-in Menus->File->Save As...
Ctrl+F2Built-in Menus->File->Print Preview
Ctrl+PBuilt-in Menus->File->Print...
Ctrl+ZBuilt-in Menus->Edit->Undo Column Width
Ctrl+YBuilt-in Menus->Edit->Repeat Clear
Ctrl+XBuilt-in Menus->Edit->Cut
Ctrl+CBuilt-in Menus->Edit->Copy
Ctrl+VBuilt-in Menus->Edit->Paste
Ctrl+Alt+VBuilt-in Menus->Edit->Paste Special...
Ctrl+DBuilt-in Menus->Edit->Fill->DownFill Down
Ctrl+RBuilt-in Menus->Edit->Fill->RightFill Right
DelBuilt-in Menus->Edit->Clear->ContentsClear Contents
Ctrl+FBuilt-in Menus->Edit->Find...
Ctrl+HBuilt-in Menus->Edit->Replace...
Ctrl+GBuilt-in Menus->Edit->Go To...
Ctrl+DBuilt-in Menus->Fill->DownFill Down
Ctrl+RBuilt-in Menus->Fill->RightFill Right
DelBuilt-in Menus->Clear->ContentsClear Contents
Ctrl+F1Built-in Menus->View->Task Pane
Ctrl+Shift+=Built-in Menus->Insert->Insert Cells...
Shift+F11Built-in Menus->Insert->WorksheetInsert Worksheet
Shift+F3Built-in Menus->Insert->Function...Insert Function
F3Built-in Menus->Insert->Names->Paste...Paste Names
Ctrl+Shift+F3Built-in Menus->Insert->Names->Create...
Shift+F2Built-in Menus->Insert->New Comment
Ctrl+KBuilt-in Menus->Insert->Hyperlink...Insert Hyperlink
F3Built-in Menus->Names->Paste...Paste Names
Ctrl+Shift+F3Built-in Menus->Names->Create...
Ctrl+1Built-in Menus->Format->Cells...Datasheet Formatting
Ctrl+9Built-in Menus->Format->Row->Hide
Ctrl+Shift+(Built-in Menus->Format->Row->Unhide
Ctrl+0Built-in Menus->Format->Column->Hide
Ctrl+Shift+)Built-in Menus->Format->Column->Unhide
Ctrl+9Built-in Menus->Row->Hide
Ctrl+Shift+(Built-in Menus->Row->Unhide
Ctrl+0Built-in Menus->Column->Hide
Ctrl+Shift+)Built-in Menus->Column->Unhide
F7Built-in Menus->Tools->Spelling...
Alt+ClickBuilt-in Menus->Tools->Research...
Ctrl+`Built-in Menus->Tools->Formula Auditing->Formula Auditing Mode
Alt+F8Built-in Menus->Tools->Macro->Macros...View Macros
Alt+F11Built-in Menus->Tools->Macro->Visual Basic Editor
Ctrl+`Built-in Menus->Formula Auditing->Formula Auditing Mode
Alt+F8Built-in Menus->Macro->Macros...View Macros
Alt+F11Built-in Menus->Macro->Visual Basic Editor
Ctrl+Shift+LBuilt-in Menus->Data->Filter Menu->AutoFilter
Shift+Alt+RightBuilt-in Menus->Data->Group and Outline->Group...
Shift+Alt+LeftBuilt-in Menus->Data->Group and Outline->Ungroup...
Ctrl+TBuilt-in Menus->Data->List->Create Table...
Alt+F5Built-in Menus->Data->Refresh
Ctrl+Shift+LBuilt-in Menus->Filter Menu->AutoFilter
Shift+Alt+RightBuilt-in Menus->Group and Outline->Group...
Shift+Alt+LeftBuilt-in Menus->Group and Outline->Ungroup...
F1Built-in Menus->Help->Microsoft Excel Help
Ctrl+OBuilt-in Menus->File->Open...
Ctrl+SBuilt-in Menus->File->Save
Ctrl+F2Built-in Menus->File->Print Preview
Ctrl+PBuilt-in Menus->File->Print...
Ctrl+ZBuilt-in Menus->Edit->Undo Column Width
Ctrl+YBuilt-in Menus->Edit->Repeat Clear
Ctrl+XBuilt-in Menus->Edit->Cut
Ctrl+CBuilt-in Menus->Edit->Copy
Ctrl+VBuilt-in Menus->Edit->Paste
Ctrl+Alt+VBuilt-in Menus->Edit->Paste Special...
Shift+F11Built-in Menus->Insert->WorksheetInsert Worksheet
Ctrl+KBuilt-in Menus->Insert->Hyperlink...Insert Hyperlink
Ctrl+1Built-in Menus->Format->Cells...
F7Built-in Menus->Tools->Spelling...
Alt+F8Built-in Menus->Tools->Macro->Macros...View Macros
Alt+F11Built-in Menus->Tools->Macro->Visual Basic Editor
Alt+F8Built-in Menus->Macro->Macros...View Macros
Alt+F11Built-in Menus->Macro->Visual Basic Editor
F1Built-in Menus->Help->Microsoft Excel Help