Skip to content

Instantly share code, notes, and snippets.

@pebreo

pebreo/excel.md

Created December 8, 2015 06:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pebreo/5e2bf5ce1a0c9595628b to your computer and use it in GitHub Desktop.
Save pebreo/5e2bf5ce1a0c9595628b to your computer and use it in GitHub Desktop.
Download ZIP
Excel shortcuts
Raw
excel.md

Shortcuts

Fill handle - double click to autofill the formula values for blank rows of a tables
F3 - paste list
F4 - cycle through cell reference type (absolute, relative, mixed)
CTRL-T - create table
CTRL-A - open function dialog
CTRL-Z- undo 

HOME - 
CTRL-END -

Functions

=IFERROR()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment