The finishing skills: work faster with shortcuts, and get your sheet out of Excel cleanly.
A printed report and a shared spreadsheet on screen
| Shortcut | Action |
|---|---|
| CtrlC / CtrlV | Copy / Paste |
| CtrlZ / CtrlY | Undo / Redo |
| CtrlS | Save |
| CtrlArrow | Jump to data edge |
| CtrlShiftArrow | Select to data edge |
| Alt+= | AutoSum |
| CtrlT | Create Table |
| Ctrl1 | Format Cells dialog |
| CtrlShiftL | Toggle filters |
| F4 | Repeat last action / cycle $ |
| CtrlE | Flash Fill |
| Alt | Show ribbon key tips |
Press and release [[Alt]] alone — Excel overlays a letter on every ribbon command. Type the letters to run any command keyboard-only. This reveals a shortcut for everything.
Excel's grid rarely prints well by default. Before printing (CtrlP):
Page Layout tab:
Print Area → select range → Set Print Area
Orientation → Landscape for wide data
Margins → Narrow
Scaling → "Fit All Columns on One Page"
Print Titles → repeat header row on every page
View → Page Break Preview (drag the blue lines)
Insert → Header & Footer (page numbers, file name, date)
| Goal | How |
|---|---|
| Fixed, uneditable copy | Save/Export as PDF |
| Live collaboration | Save to OneDrive/SharePoint → Share |
| Protect formulas | Review → Protect Sheet |
| Lock the whole file | File → Info → Protect Workbook → Encrypt with Password |
Before sharing, check for hidden data: File → Info → Check for Issues → Inspect Document. It finds hidden sheets, comments, and personal info you may not want to send.