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