Catalog / Microsoft Office Suite Cheatsheet
Microsoft Office Suite Cheatsheet
A comprehensive guide to Microsoft Office, covering Word, Excel, PowerPoint, and Outlook. This cheat sheet provides quick references for essential functions, shortcuts, and features to boost productivity.
Microsoft Word Essentials
Formatting Text
|
Bold |
Ctrl + B |
|
Italic |
Ctrl + I |
|
Underline |
Ctrl + U |
|
Increase Font Size |
Ctrl + ] |
|
Decrease Font Size |
Ctrl + [ |
|
Change Font |
Ctrl + Shift + F |
Document Navigation
|
Go to Beginning of Line |
Home |
|
Go to End of Line |
End |
|
Go to Beginning of Document |
Ctrl + Home |
|
Go to End of Document |
Ctrl + End |
|
Page Up |
Page Up |
|
Page Down |
Page Down |
Editing & Reviewing
|
Undo |
Ctrl + Z |
|
Redo |
Ctrl + Y |
|
Cut |
Ctrl + X |
|
Copy |
Ctrl + C |
|
Paste |
Ctrl + V |
|
Find |
Ctrl + F |
|
Replace |
Ctrl + H |
|
Spelling & Grammar |
F7 |
Microsoft Excel Essentials
Basic Formulas
|
Sum |
=SUM(A1:A10) |
|
Average |
=AVERAGE(A1:A10) |
|
Minimum |
=MIN(A1:A10) |
|
Maximum |
=MAX(A1:A10) |
|
Count |
=COUNT(A1:A10) |
|
If Condition |
=IF(A1>10,“Yes”,“No”) |
Cell Formatting
|
Format as Currency |
Ctrl + Shift + $ |
|
Format as Percentage |
Ctrl + Shift + % |
|
Format as Date |
Ctrl + Shift + # |
|
General Format |
Ctrl + Shift + ~ |
|
Add Borders |
Alt + H, B, A |
|
Merge Cells |
Alt + H, M, C |
Navigation & Selection
|
Go to Last Cell with Data |
Ctrl + End |
|
Select Entire Row |
Shift + Space |
|
Select Entire Column |
Ctrl + Space |
|
Select All |
Ctrl + A |
|
Move to Next Sheet |
Ctrl + Page Down |
|
Move to Previous Sheet |
Ctrl + Page Up |
Microsoft PowerPoint Essentials
Basic Shortcuts
|
New Presentation |
Ctrl + N |
|
Open Presentation |
Ctrl + O |
|
Save Presentation |
Ctrl + S |
|
Print Presentation |
Ctrl + P |
|
Close Presentation |
Ctrl + W |
|
Undo |
Ctrl + Z |
Slide Management
|
New Slide |
Ctrl + M |
|
Duplicate Slide |
Ctrl + Shift + D |
|
Delete Slide |
Delete |
|
Start Presentation from Beginning |
F5 |
|
Start Presentation from Current Slide |
Shift + F5 |
|
End Presentation |
Esc |
Text & Object Manipulation
|
Bold |
Ctrl + B |
|
Italic |
Ctrl + I |
|
Underline |
Ctrl + U |
|
Copy Formatting |
Ctrl + Shift + C |
|
Paste Formatting |
Ctrl + Shift + V |
|
Group Objects |
Ctrl + G |
|
Ungroup Objects |
Ctrl + Shift + G |
Microsoft Outlook Essentials
Email Management
|
New Email |
Ctrl + N |
|
Reply |
Ctrl + R |
|
Reply All |
Ctrl + Shift + R |
|
Forward |
Ctrl + F |
|
Send Email |
Alt + S |
|
Check for New Emails |
F9 |
Calendar Management
|
New Appointment |
Ctrl + Shift + A |
|
New Meeting Request |
Ctrl + Shift + Q |
|
Go to Today |
Alt + , (comma) |
|
Go to Next Day |
Alt + . (period) |
|
Day View |
Alt + 1 |
|
Week View |
Alt + 2 |
|
Month View |
Alt + 3 |
Contact Management
|
New Contact |
Ctrl + Shift + C |
|
Open Address Book |
Ctrl + Shift + B |
|
Find a Contact |
Ctrl + E |