Excel for Microsoft 365 Introduction Quick Reference
Laminated quick reference showing step-by-step instructions and shortcuts for how to use Microsoft Excel 365 (Windows version). Last checked for accuracy September 2022. The following topics are covered:
Entering and Editing Data
Picking from a Drop-Down List
Selecting Cells
Resizing Column Width and Row Height
Inserting and Deleting Rows, Columns and Cells
Clearing Cells, Clearing Formatting
Borders, Shading, Text Color
Formatting Number Cells
Aligning and Merging Cells
Entering Dates
Entering a Sequence of Numbers
Entering Formulas & Functions
Entering SUM and Other Functions Quickly
Absolute vs. Relative Cell References.
Copying and Moving Data: Copying to Adjacent Cells; Cut, Copy, Paste; Drag & Drop.
Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting Sheets. Editing Multiple Sheets Simultaneously.
Previewing, Printing and Page Setup
Scaling to Print
Printing a Specific Area
Using Page Break Preview to Adjust Page Breaks
Repeating Rows/Columns on Every Page of a Printout
Also includes a list of Touch Actions, Selection and Movement Shortcuts.