ABCDEFG
1
Our Favorite Keyboard Shortcuts
2
3
CommandShortcut (PC)Shortcut (Mac)
4
5
Navigate spreadsheet
6
Move to beginning of rowHomeFn + Left Arrow
7
Move to beginning of sheetCtrl + Home⌘ + Fn + Left Arrow
8
Move to end of section of dataCtrl + Left/Right/Up/Down Arrow⌘ + Left/Right/Up/Down Arrow
9
Scroll to active cellCtrl + Backspace⌘ + Backspace
10
Move to next sheetAlt + Down ArrowOption + Down Arrow
11
Move to previous sheetAlt + Up ArrowOption + Up Arrow
12
13
14
Common actions
15
Show common keyboard shortcutsCtrl + /⌘ + /
16
Search the menusAlt + /Option + /
17
Clear formattingCtrl + \⌘ + \
18
RedoCtrl + y⌘ + y
19
FindCtrl + f⌘ + f
20
Paste values onlyCtrl + Shift + v⌘ + Shift + v
21
Fill rangeCtrl + Enter⌘ + Enter
22
Select rowShift + SpaceShift + Space
23
Select columnCtrl + SpaceCtrl + Space
24
Insert rows aboveCtrl + Alt + = (with rows selected)⌘ + Option + = (with rows selected)
25
Insert columns to the leftCtrl + Alt + = (with columns selected)⌘ + Option + = (with columns selected)
26
Delete rowsCtrl + Alt + - (with rows selected)⌘ + Option + - (with rows selected)
27
Delete columnsCtrl + Alt + - (with columns selected)⌘ + Option + - (with columns selected)
28
29
30
Format cells
31
Left alignCtrl + Shift + l⌘ + Shift + l
32
Center alignCtrl + Shift + e⌘ + Shift + e
33
Right alignCtrl + Shift + r⌘ + Shift + r
34
Remove bordersAlt + Shift + 6Option + Shift + 6
35
Insert linkCtrl + k⌘ + k
36
Format as currencyCtrl + Shift + 4Ctrl + Shift + 4
37
Format as percentageCtrl + Shift + 5Ctrl + Shift + 5
38
39
40
Edit notes and comments
41
Insert/edit noteShift + F2Shift + F2
42
Insert/edit commentCtrl + Alt + m⌘ + Option + m
43
44
45
46
47
48
Our Favorite Formulas
49
(These are all for Google Sheets, but many are exactly the same in Excel.)
50
51
SUMAdds the selected cells together.
52
IFAllows you to use "if this, then that" logic.
53
NOTReturns the opposite of a logical value.
54
COUNTCounts the numbers selected cells.
55
COUNTIFCounts items in a range based on a conditional statement.
56
ISBLANKLets you know if a cell is blank. Really useful in combination with other formulas.
57
UNIQUEProduces a list of only unique values in a range (aka, gets rid of any duplicates).
58
CONCATTakes two items and combines them together. Like taking a first name and a last name column and turning them into a full name column.
59
ROUNDAllows you to round numbers to any place.
60
CONVERTConverts measurements from one unit to another.
61
62
63
64
65
66
Our Favorite General Tips
67
(These are all for Google Sheets, but many are exactly the same in Excel.)
68
69
Right clicking brings up lots of quick commands you can use directly from a row, column, or cell.
70
If you select some cells of data, the bottom right corner of the screen will show you a lot of quick information (a count, a sum, the min and max in the range, etc.)
71
You can reference cells in other sheets, and even in other files. Cutting/pasting cells doesn't mess up the references directed at them.
72
Use dollar signs when referencing cells if you need to lock the column or row you're referencing. Then when you drag to copy that formula to other cells it won't move those locked off references.
73
Dragging the corner of the cell or a set of selected cells to do a "smart fill" of more cells. For example, cells with Mon, Tue, and Wed in them will automatically insert Thur on the next cell.
74
Automatically split data in selected cells by a specific paramater by going to "Data" in the menu and then "Split text to columns".
75
Copying, then right clicking to paste, allows you to go into the "Paste Special" menu. There's lots of useful stuff in there, like "Transpose" which can take data in a row and change it to a column.
76
Clicking "Format" in the menu and then "Conditional formatting" will allow you to add all sorts of automatic styling to your spreadsheets based off of various critera.
77
Use "&" as a way to add text within formulas.
78
79
80
81
82
83