Tuesday 4 January 2011

Some Excel and other MS Office Shortcuts

Short Cut Action
Ctrl + A Select All
Ctrl + B Bold
Ctrl + C Copy
Ctrl + D Fill Down
Ctrl + F Find
Ctrl + G Go To
Ctrl + H Find and Replace
Ctrl + I Italic
Ctrl + K Insert Hyperlink
Ctrl + L Create Table
Ctrl + M Insert - New Page in Powerpoint
Ctrl + N New Book
Ctrl + O Open
Ctrl + P Print
Ctrl + R Fill Right
Ctrl + S Save
Ctrl + T Create Table
Ctrl + U Underline
Ctrl + V Paste
Ctrl + W Close with Saving
Ctrl + X Cut
Ctrl + Y Redo
Ctrl + Z Undo
Ctrl + 1 Format Cells Excel - Go to Mail in Outlook
Ctrl + 2 Bold - Go to Calendar in Outlook
Ctrl + 3 Italic
Ctrl + 4 Underline
Ctrl + 5 Strikethrough
Ctrl + 9 Delete Row
Ctrl + + Add Row/Column
Ctrl + - Delete Row/Column
Alt + E + S + V Paste Special
Alt + E + S + E Transpose
Alt + N + V + T Insert Pivot Table
Alt + N + V + C Insert Pivot Chart
Alt + D + F + F Apply/Unapply Filter
Alt + W + F + F Freeze/Unfreeze Panes
Alt + D + G + G Group Cells
aLT + D + G + U Ungroup Cells
F1 Help
F4 Autocomplete
F5 Go To in Excel - Presentation in Powerpoint - Refresh page in Internet Explorer
F11 Insert Chart
F12 Save As
Alt + I + W Insert Sheet
Alt + I + R Insert Row
Alt + I + C Insert Column
Alt + V + P View Print Layout
Alt + V + N View Normal Layou

No comments:

Post a Comment