Office Cheat Sheet: Excel, PowerPoint, Outlook, Google Sheets, Notion
One page for the office stack: Microsoft Excel, PowerPoint and Outlook, plus Google Sheets and Notion. Excel and Google Sheets are placed next to each other on purpose, because the two spreadsheets share most navigation and selection keys but diverge on formula entry and formatting; having both tables on the same page makes the differences visible. Microsoft Word is not on this bundle: its reference is large enough to stand alone.
Every row is copied from the tool's own reference page without editing. Notion's block-level shortcuts (slash commands, toggles, Markdown-style prefixes) are included because they are the keystrokes people ask about most when switching from a document editor to a block editor.
- Excel (90)
- PowerPoint (50)
- Outlook (17)
- Google Sheets (44)
- Notion (89)
Excel — 90 entries, full reference
| Shortcut | Action | Notes |
|---|---|---|
| F2 | Edit Cell | Enter edit mode for selected cell. |
| Enter | Confirm & Move Down | Confirm input and move down. |
| Shift + Enter | Confirm & Move Up | Confirm input and move up. |
| Tab | Confirm & Move Right | Confirm input and move right. |
| Shift + Tab | Confirm & Move Left | Confirm input and move left. |
| Ctrl + D | Fill Down | Copy top cell content down to selected range. |
| Ctrl + R | Fill Right | Copy left cell content right to selected range. |
| Ctrl + ; | Today's Date | Insert current date as fixed value. |
| Ctrl + Shift + : | Current Time | Insert current time as fixed value. |
| Alt + Enter | New Line in Cell | Insert line break within same cell. |
| Ctrl + Enter | Fill Selection | Fill all selected cells with same value. |
| Ctrl + Delete | Delete to End | Delete from cursor to end of cell. |
| Delete | Delete Content | Delete content of selected cells. |
| Ctrl + - | Delete Cells/Rows/Columns | Delete selected cells, rows, or columns. |
| Ctrl + Shift + + | Insert Cells/Rows/Columns | Insert new cells, rows, or columns. |
| Ctrl + 1 | Format Cells | Open Format Cells dialog for all formatting options. |
| Ctrl + B | Bold | Make selected text bold or unbold. |
| Ctrl + I | Italic | Make selected text italic or remove italic. |
| Ctrl + U | Underline | Add or remove underline from text. |
| Ctrl + 5 | Strikethrough | Add or remove strikethrough from text. |
| Ctrl + Shift + & | Apply Border | Apply border to selected cells. |
| Ctrl + Shift + _ | Remove Border | Remove borders from selected cells. |
| Alt + H + H | Fill Color | Change cell background color. |
| Alt + H + F + C | Font Color | Change font color. |
| Ctrl + Shift + ! | Thousand Separator | Add thousand separator to numbers. |
| Ctrl + Shift + $ | Currency Format | Apply currency format. |
| Ctrl + Shift + % | Percentage Format | Apply percentage format. |
| Ctrl + Shift + ^ | Scientific Format | Apply scientific notation format. |
| Ctrl + Shift + # | Date Format | Apply date format (day-month-year). |
| Ctrl + Shift + @ | Time Format | Apply time format. |
| Ctrl + Shift + ~ | General Format | Apply general number format. |
| Ctrl + Home | Go to A1 | Jump to cell A1 (start of worksheet). |
| Ctrl + End | Last Cell | Jump to last used cell. |
| Ctrl + Arrow | Jump to Edge | Jump to edge of data region in arrow direction. |
| Home | Start of Row | Go to first column of current row. |
| Ctrl + Page Up | Previous Sheet | Move to previous worksheet. |
| Ctrl + Page Down | Next Sheet | Move to next worksheet. |
| Ctrl + G | Go To | Open Go To dialog to jump to specific cell. |
| F5 | Go To | Same as Ctrl+G - opens Go To dialog. |
| Ctrl + Backspace | Show Active Cell | Scroll to make active cell visible. |
| Page Up/Down | Screen Navigation | Move one screen up or down. |
| Ctrl + A | Select All | Select entire worksheet. |
| Ctrl + Space | Select Column | Select entire current column. |
| Shift + Space | Select Row | Select entire current row. |
| Ctrl + Shift + Space | Select Data Region | Select entire current data region. |
| Shift + Arrow | Extend Selection | Extend selection in arrow direction. |
| Ctrl + Shift + Arrow | Extend to Edge | Extend selection to edge of data. |
| Shift + Home | Select to Row Start | Extend selection to start of row. |
| Ctrl + Shift + Home | Select to A1 | Select from current cell to A1. |
| Ctrl + Shift + End | Select to Last | Select from current cell to last used cell. |
| = | Start Formula | Begin entering a formula. |
| Alt + = | AutoSum | Automatically insert SUM function. |
| F4 | Toggle Reference | Toggle between absolute/relative reference types ($A$1, A$1, $A1, A1). |
| Ctrl + ` | Show Formulas | Toggle between showing values and formulas. |
| F9 | Calculate All | Calculate all worksheets in all open workbooks. |
| Shift + F9 | Calculate Sheet | Calculate only active worksheet. |
| Ctrl + Alt + F9 | Force Calculate | Force recalculation of all formulas. |
| Ctrl + T | Create Table | Convert selected range to Excel table. |
| Ctrl + Shift + L | Toggle Filter | Add or remove AutoFilter. |
| Alt + Down | Open Filter | Open filter dropdown for selected column. |
| Ctrl + Shift + O | Select Comments | Select all cells with comments. |
| F3 | Paste Name | Paste defined name into formula. |
| Ctrl + F3 | Name Manager | Open Name Manager to define/edit names. |
| Ctrl + F | Find | Open Find dialog to search for data. |
| Ctrl + H | Replace | Open Find and Replace dialog. |
| Shift + F4 | Find Next | Find next occurrence of search term. |
| Ctrl + Shift + F4 | Find Previous | Find previous occurrence of search term. |
| Ctrl + 9 | Hide Rows | Hide selected rows. |
| Ctrl + Shift + 9 | Unhide Rows | Unhide rows in selection. |
| Ctrl + 0 | Hide Columns | Hide selected columns. |
| Ctrl + Shift + 0 | Unhide Columns | Unhide columns in selection. |
| Alt + H + O + I | AutoFit Column | Auto-fit column width to content. |
| Alt + H + O + A | AutoFit Row | Auto-fit row height to content. |
| Ctrl + N | New Workbook | Create new workbook. |
| Ctrl + O | Open | Open existing file. |
| Ctrl + S | Save | Save current workbook. |
| F12 | Save As | Open Save As dialog. |
| Ctrl + P | Open Print dialog. | |
| Ctrl + W | Close | Close current workbook or document. |
| Ctrl + F4 | Close Window | Close current window. |
| Alt + F4 | Exit Excel | Quit Excel application. |
| Ctrl + F6 | Next Window | Switch to next window. |
| Ctrl + Tab | Switch Workbooks | Switch between open workbooks. |
| Alt + F11 | VBA Editor | Open Visual Basic Editor. |
| Ctrl + F1 | Toggle Ribbon | Show or hide the ribbon. |
| Alt + F1 | Chart | Create chart from selected data. |
| F2 | Edit Cell | Edit active cell. |
| Ctrl + F9 | Minimize | Minimize workbook window. |
| Ctrl + F10 | Maximize | Maximize/restore workbook window. |
| Shift + F11 | New Sheet | Insert new worksheet. |
PowerPoint — 50 entries, full reference
| Shortcut | Action | Notes |
|---|---|---|
| Ctrl + N | New Presentation | Create a new blank presentation. |
| Ctrl + O | Open | Open an existing presentation file. |
| Ctrl + S | Save | Save the current presentation. |
| Ctrl + Shift + S | Save As | Save with a new name or format. |
| Ctrl + P | Open the print dialog. | |
| F5 | Start Slideshow from Beginning | Start presenting from the first slide. |
| Shift + F5 | Start from Current Slide | Start presenting from the current slide. |
| Esc | End Slideshow | Exit presentation mode. |
| Ctrl + W | Close | Close the current presentation. |
| Ctrl + Z | Undo | Undo the last action. |
| Ctrl + Y | Redo | Redo the last undone action. |
| F12 | Save As Dialog | Open Save As dialog directly. |
| Ctrl + M | New Slide | Insert a new slide after the current one. |
| Ctrl + D | Duplicate Slide | Duplicate the selected slide. |
| Delete | Delete Slide | Delete the selected slide. |
| Ctrl + C | Copy | Copy the selected object or text. |
| Ctrl + X | Cut | Cut the selected object or text. |
| Ctrl + V | Paste | Paste the copied content. |
| Ctrl + A | Select All | Select all objects on the current slide. |
| Ctrl + G | Group | Group the selected objects. |
| Ctrl + Shift + G | Ungroup | Ungroup grouped objects. |
| Tab | Next Object | Select the next object on the slide. |
| Shift + Tab | Previous Object | Select the previous object on the slide. |
| Ctrl + Enter | Next Placeholder | Move to the next text placeholder. |
| Ctrl + B | Bold | Apply or remove bold formatting. |
| Ctrl + I | Italic | Apply or remove italic formatting. |
| Ctrl + U | Underline | Apply or remove underline. |
| Ctrl + Shift + > | Increase Font Size | Increase the font size. |
| Ctrl + Shift + < | Decrease Font Size | Decrease the font size. |
| Ctrl + E | Center Align | Center-align the text. |
| Ctrl + L | Left Align | Left-align the text. |
| Ctrl + R | Right Align | Right-align the text. |
| Ctrl + J | Justify | Justify-align the text. |
| Ctrl + Space | Clear Formatting | Remove all text formatting. |
| Ctrl + = | Subscript | Apply subscript formatting. |
| Ctrl + Shift + = | Superscript | Apply superscript formatting. |
| Page Up | Previous Slide | Go to the previous slide. |
| Page Down | Next Slide | Go to the next slide. |
| Ctrl + Home | First Slide | Go to the first slide. |
| Ctrl + End | Last Slide | Go to the last slide. |
| Alt + F9 | Toggle Guides | Show or hide slide guides. |
| Ctrl + F | Find | Search for text. |
| Ctrl + H | Find & Replace | Find and replace text. |
| N or Right | Next Slide | Advance to the next slide during presentation. |
| P or Left | Previous Slide | Go back to the previous slide. |
| B | Black Screen | Toggle a black screen to pause attention. |
| W | White Screen | Toggle a white screen. |
| Ctrl + P | Pen Tool | Activate pen tool to draw on slides. |
| E | Erase Drawings | Erase pen annotations. |
| S | Stop/Resume Auto Advance | Pause or resume automatic slide advance. |
Outlook — 17 entries, full reference
| Shortcut | Action | Notes |
|---|---|---|
| Ctrl + N | New Email | Create a new email message. |
| Ctrl + R | Reply | Reply to selected email. |
| Ctrl + Shift + R | Reply All | Reply to all recipients. |
| Ctrl + F | Forward | Forward selected email. |
| Ctrl + Enter | Send | Send the email. |
| Ctrl + E | Search | Activate search bar. |
| Ctrl + Q | Mark Read | Mark email as read. |
| Ctrl + U | Mark Unread | Mark email as unread. |
| Ctrl + Shift + G | Flag | Flag email for follow-up. |
| Delete | Delete | Delete selected email. |
| F9 | Send/Receive | Send and receive all emails. |
| Ctrl + 1 | Switch to Mail | Switch to mail view. |
| Ctrl + 2 | Switch to Calendar | Switch to calendar view. |
| Ctrl + 3 | Switch to Contacts | Switch to contacts view. |
| Ctrl + 4 | Switch to Tasks | Switch to tasks view. |
| Ctrl + Y | Go to Folder | Navigate to a different folder. |
| Alt + S | Send | Send the email. |
Google Sheets — 44 entries, full reference
| Shortcut | Action | Notes |
|---|---|---|
| Ctrl + C | Copy | Copy the selected cells. |
| Ctrl + X | Cut | Cut the selected cells. |
| Ctrl + V | Paste | Paste the copied content. |
| Ctrl + Shift + V | Paste Values Only | Paste values without formatting. |
| Ctrl + Z | Undo | Undo the last action. |
| Ctrl + Y | Redo | Redo the last undone action. |
| Ctrl + A | Select All | Select the entire sheet. |
| Ctrl + F | Find | Search cell contents. |
| Ctrl + H | Find & Replace | Find and replace content. |
| Delete | Delete Content | Delete the content of selected cells. |
| F2 | Edit Cell | Enter edit mode for the selected cell. |
| Escape | Cancel Edit | Cancel the current edit. |
| Ctrl + Home | Go to A1 | Jump to the first cell of the spreadsheet. |
| Ctrl + End | Go to Last Cell | Jump to the last cell with data. |
| Ctrl + Right | Right Edge | Jump to the right edge of the data range. |
| Ctrl + Left | Left Edge | Jump to the left edge of the data range. |
| Ctrl + Down | Bottom Edge | Jump to the bottom edge of the data range. |
| Ctrl + Up | Top Edge | Jump to the top edge of the data range. |
| Ctrl + G | Go to Range | Navigate to a specific cell address or range. |
| Tab | Move Right | Move to the cell on the right. |
| Shift + Tab | Move Left | Move to the cell on the left. |
| Enter | Move Down | Move to the cell below after input. |
| Ctrl + Shift + + | Insert Row/Column | Insert a row or column at the selected position. |
| Ctrl + - | Delete Row/Column | Delete the selected row or column. |
| Ctrl + Space | Select Column | Select the entire current column. |
| Shift + Space | Select Row | Select the entire current row. |
| Ctrl + Shift + 9 | Hide Rows | Hide the selected rows. |
| Ctrl + Shift + 0 | Hide Columns | Hide the selected columns. |
| Ctrl + B | Bold | Apply or remove bold formatting. |
| Ctrl + I | Italic | Apply or remove italic formatting. |
| Ctrl + U | Underline | Apply or remove underline. |
| Alt + Shift + 5 | Strikethrough | Apply strikethrough to selected text. |
| Ctrl + Shift + 1 | Number Format | Apply number format with 2 decimal places. |
| Ctrl + Shift + 3 | Date Format | Apply date format. |
| Ctrl + Shift + 4 | Currency Format | Apply currency format. |
| Ctrl + Shift + 5 | Percent Format | Apply percentage format. |
| Ctrl + D | Fill Down | Copy the content of the top cell downward. |
| Ctrl + R | Fill Right | Copy the content of the left cell rightward. |
| Ctrl + E | Smart Fill | Auto-fill based on detected patterns. |
| F4 | Toggle Absolute/Relative Reference | Cycle through $A$1 → A$1 → $A1 → A1. |
| Ctrl + ` | Show Formulas | Toggle between showing values and formulas. |
| Ctrl + ; | Insert Today's Date | Insert the current date into the cell. |
| Ctrl + Shift + : | Insert Current Time | Insert the current time into the cell. |
| Ctrl + Shift + Enter | Array Formula | Enter as an array formula. |
Notion — 89 entries, full reference
| Shortcut | Action | Notes |
|---|---|---|
| Ctrl + F | Search inside a page | |
| Ctrl + P or Ctrl + K | Open search or jump to a recently viewed page | |
| Ctrl + L | Copy a page's URL | |
| Ctrl + [ | Go to back a page | |
| Ctrl + ] | Go forward a page | |
| Ctrl + K | Go to the previous database page (while in database peek view) | |
| Ctrl + J | Go to the next database page (while in database peek view) | |
| Ctrl + Shift + L | Toggle between dark mode and light mode | |
| Enter | Insert a line of text | |
| Shift + Enter | Create a line break within a block of text | |
| Ctrl + Shift + M | Create a comment | |
| Ctrl + B | Bold text (text selected) | |
| Ctrl + I | Italicize text (text selected) | |
| Ctrl + U | Underline text (text selected) | |
| Ctrl + Shift + S | Strikethrough (text selected) | |
| Ctrl + E | Inline code (text selected) | |
| Shift + Tab | Un-nest content | |
| Ctrl + Alt/Shift + 0 | Create text | |
| Ctrl + Alt/Shift + 1 | Create an H1 heading | |
| Ctrl + Alt/Shift + 2 | Create an H2 heading | |
| Ctrl + Alt/Shift + 3 | Create an H3 heading | |
| Ctrl + Alt/Shift + 4 | Create a to-do checkbox | |
| Ctrl + Alt/Shift + 5 | Create a bulleted list | |
| Ctrl + Alt/Shift + 6 | Create a numbered list | |
| Ctrl + Alt/Shift + 7 | Create a toggle list | |
| Ctrl + Alt/Shift + 8 | Create a code block | |
| Ctrl + Alt/Shift + 9 | Create a new page, or turn whatever you have on a line into a page | |
| Ctrl + + | Zoom in | |
| Ctrl + - | Zoom out | |
| Ctrl + Shift + U | Go up one level in the page hierarchy | |
| Ctrl + R or Ctrl + D | Fill cells right or down (respectively) when you have multiple cells selected (a table) | |
| *, -, or + then Space | Create a bulleted list | |
| [] then Space | Create a to-do checkbox | |
| 1., a., or i. then Space | Create a numbered list | |
| # then Space | Create an H1 heading | |
| ## then Space | Create an H2 sub-heading | |
| ### then Space | Create an H3 sub-heading | |
| > then Space | Create a toggle list | |
| " then Space | Create a quote block | |
| Esc | Select the block you're currently in. Or to clear selected blocks | |
| Ctrl + A once | Select the block your cursor is in | |
| Space | Open a selected image in full-screen. Or to exit full-screen | |
| Arrow Keys | Select a different block | |
| Shift + Click | Select another block and all blocks in between | |
| Backspace or Delete | Delete selected blocks | |
| Ctrl + D | Duplicate the blocks you've selected | |
| Ctrl + / | Edit or change one or more selected blocks | |
| Ctrl + Alt/Alt + T | Expand or close all toggles in a toggle list | |
| Ctrl + Shift + H | Apply the last text or highlight color you used | |
| Ctrl + Enter | Modify the current block you're in. Modify means: | |
| @ | Mention a person — type then another workspace member's name to get their attention on something. They'll be notified | |
| [[ | Link a page — type then the name of another page in your workspace to create a link to it. If you change the name | |
| + | Create a sub-page — type then the name of the sub-page you want to nest within your current page. Use your cursor or arr | |
| Ctrl + N | Create a new page | |
| Ctrl + Shift + N | Open a new Notion window | |
| Alt + Shift + Click | Open a page as a new window | |
| Ctrl + Click | Open a link as a new Notion tab | |
| Ctrl + T | Create a new Notion tab | |
| /text | Or /plain creates a new text block | |
| /page | Creates a new page (and will open it automatically when you press enter) | |
| /bullet | Creates a bulleted list | |
| /num | Creates a numbered list | |
| /todo | Creates a to-do list with checkboxes | |
| /toggle | Creates a toggle list | |
| /div | Creates a light gray divider | |
| /quote | Creates a quote block of larger text | |
| /h1 | Or /# creates a large heading | |
| /h2 | Or /## creates a medium-sized heading | |
| /h3 | Or /### creates a small heading | |
| /link | Creates a link to another page in your workspace | |
| /mention | Lets you mention a page or a person in your workspace | |
| /date | Or /reminder lets you add a timestamp or reminder to your page | |
| /equation | Lets you add a TeX formula in line with your text | |
| /emoji | Brings up the emoji picker | |
| /image | Will bring up the option to upload or embed an image, or add one from Unsplash | |
| Lets you paste in a URL to any PDF so it will display inline on your page | ||
| /book | Lets you paste in a URL to any website to create a web bookmark | |
| /video | Lets you upload a video file or embed a video from YouTube, Vimeo, etc | |
| /audio | Lets you upload an audio file or embed a recording from SoundCloud, Spotify, etc | |
| /code | Creates a code block where you can write and copy any snippet of code | |
| /file | Lets you upload any file from your computer or create an embed | |
| /embed | Lets you add any one of the 500+ embeds that work with Notion | |
| /duplicate | Creates an exact copy of the current block | |
| /moveto | Lets you move that block to a different page | |
| /delete | Deletes the current block | |
| /toc | Creates a Table of Contents block | |
| /button | Or /template gives you a template button that duplicates any combination of blocks you define | |
| /bread | Inserts a breadcrumb menu that shows where your current page is in your workspace | |
| /math | Or /latex lets you write mathematical equations and symbols using TeX |
Rows on this page are identical to the per-tool reference pages; the per-tool pages carry source links and category notes. Other bundles: CLI Essentials · AI Coding Tools · Cloud & DevOps · Design Tools · AI Prompt Commands · all bundles.