Skip to content

Latest commit

 

History

History
91 lines (81 loc) · 4.5 KB

msoffice.md

File metadata and controls

91 lines (81 loc) · 4.5 KB
Raw
layout title
../../layouts/CheatSheet.astro
Microsoft Office Cheatsheet

Synopsis

Microsoft Office is a family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas. It has various applications, including Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, Microsoft OneNote, Microsoft Publisher, Microsoft Teams, Microsoft OneDrive, and Microsoft SharePoint.

Microsoft Word Shortcuts

Shortcut Description
Ctrl + A Select all
Ctrl + B Bold
Ctrl + C Copy
Ctrl + D Delete
Ctrl + E Center
Ctrl + F Find
Ctrl + G Go to
Ctrl + H Replace
Ctrl + I Italic
Ctrl + J Justify
Ctrl + K Insert hyperlink
Ctrl + L Left align
Ctrl + M Indent
Ctrl + N New
Ctrl + O Open
Ctrl + P Print
Ctrl + Q Increase indent
Ctrl + R Right align
Ctrl + S Save
Ctrl + T Decrease indent
Ctrl + U Underline
Ctrl + V Paste
Ctrl + W Close
Ctrl + X Cut
Ctrl + Y Redo
Ctrl + Z Undo

Microsoft Excel Shortcuts

Shortcut Description
Ctrl + Shift + Enter Insert a line break in a cell
Ctrl + Shift + F3 Insert a function
Ctrl + Shift + F4 Insert a function argument
Ctrl + Shift + F9 Insert a worksheet name
Ctrl + Shift + F10 Insert a cell reference
Ctrl + Shift + F11 Insert a defined name
Ctrl + Shift + F12 Insert a constant
Ctrl + Shift + F5 Insert a range name
Ctrl + Shift + F6 Insert a cell address
Ctrl + Shift + F7 Insert a workbook name
Ctrl + Shift + F8 Insert a column reference
Ctrl + Shift + F1 Insert a row reference
Ctrl + N Create a new workbook
Ctrl + O Open an existing workbook
Ctrl + S Save a workbook/spreadsheet
Ctrl + W Close the current workbook
Ctrl + F4 Close Excel
Ctrl + PageDown Move to the next sheet
Ctrl + PageUp Move to the previous sheet
Alt + A Go to the Data tab

Formula in Excel

Formula Description
=SUM(A1:A10) Sum of cells A1 to A10
=AVERAGE(A1:A10) Average of cells A1 to A10
=COUNT(A1:A10) Count of cells A1 to A10
=MAX(A1:A10) Maximum of cells A1 to A10
=MIN(A1:A10) Minimum of cells A1 to A10
=IF(A1>A2,"A1 is greater than A2","A1 is less than A2") If A1 is greater than A2, then return "A1 is greater than A2", else return "A1 is less than A2"
=IF(A1>A2,"A1 is greater than A2") If A1 is greater than A2, then return "A1 is greater than A2"

Microsoft PowerPoint Shortcuts

Shortcut Description
Ctrl + 1 Bullets
Ctrl + 2 Numbering
Ctrl + 3 Multilevel list
Ctrl + 4 Decrease indent
Ctrl + 5 Increase indent
Ctrl + 6 Decrease indent
Ctrl + 7 Increase indent
Ctrl + 8 Decrease indent
Ctrl + 9 Increase indent
Ctrl + 0 Normal view