Helpful Keyboard Shortcuts and Sheets Formulas
Keyboard shortcuts that make things easier
Keyboard Shortcuts
Applies to all Windows devices. Apple products may have different shortcuts for some functions.
Shortcut | Function |
Ctrl + X | Cut |
Ctrl + C | Copy |
Ctrl + V | Paste |
Ctrl + Shift + V | Paste without original formatting |
Ctrl + A | Select All Items |
Ctrl + P | |
Ctrl + S | Save |
Ctrl + Shift + S | Save As |
Ctrl + = | Zoom In |
Ctrl + – | Zoom Out |
Ctrl + Z | Undo |
Ctrl + Shift + Z or Ctrl + Y Varies from program to program | Redo |
Ctrl + H | Open Browser History |
Ctrl + F | Search Keywords within page |
Ctrl + N | New Window |
Ctrl + T | New Tab |
Ctrl + W | Close Tab |
Ctrl + Shift + T | Reopen last closed tab |
Alt + F4 | Close All Tabs |
F5 | Refresh |
Windows + G | Screen Recorder |
Windows + H | Speech to text transcription |
Windows + N | Desktop Notification History |
Windows + V | Clipboard History |
Shortcuts for Google Docs
Shortcut | Function |
Ctrl + Alt + 1 through 6, Ctrl + Alt + 0 | Apply Headings, Normal Text |
Ctrl + B | Bold Text |
Ctrl + I | Italicize Text |
Ctrl + U | Underline Text |
Ctrl + Enter | Insert Page Break |
Ctrl + K | Insert Link |
Ctrl + Alt + M | Insert Comment |
Ctrl + O | Open Document |
Ctrl + / | View all Keyboard Shortcuts |
Formulas for Google Sheets
Formulas that we use the most while working in sheets.
Formula | Function |
|---|---|
=SUM( ) | Adds all values within brackets |
=ABS( ) | Turns all negative values into positive |
='Sheet Name'!Cell | Imports data from a cell in a different sheet |