Excel Shortcuts Flashcards
1
Q
Copy
A
Ctrl + C
2
Q
Paste
A
Ctrl + V
3
Q
Edit cell content
A
F2
4
Q
Add line break inside a cell (2 options)
A
Alt + Enter or Ctrl + J
5
Q
Undo
A
Ctrl + Z
6
Q
Redo
A
Ctrl + Y
7
Q
Autosum
A
Alt =
8
Q
Date stamp
A
Ctrl + ;
9
Q
Time stamp
A
Ctrl + shift + ;
10
Q
Open blank workbook
A
Ctrl + N
11
Q
Move to the next worksheet
A
Ctrl + page down
12
Q
Move to the previous worksheet
A
Ctrl + page up
13
Q
Switch between Excel workbooks
A
Ctrl + Tab
14
Q
Select data in the current region
A
Ctrl + A
15
Q
Move to first cell in the same row
A
Home
16
Q
Move to cell A1
A
Ctrl + Home
17
Q
Open a workbook
A
Ctrl + O
18
Q
Save a workbook
A
Ctrl + S
19
Q
Close a workbook
A
Ctrl + W
20
Q
Insert a new worksheet
A
Shift + F11
21
Q
Bold
A
Ctrl + B
22
Q
Bring up format dialog box
A
Ctrl + 1
23
Q
Repeat last edit
A
F4
24
Q
Enter data but stay on the same cell
A
Ctrl + Enter
25
Move to the cell on the right
tab
26
Flash Fill
Ctrl + E
27
Go to special
Ctrl + G
28
Insert a note
Shift + F2
29
Move to the bottom of the data region
Ctrl + down arrow
30
Move to the last used cell on the worksheet
Ctrl + End
31
Insert a new cell/row/column
Ctrl +
32
Delete a cell/row/column
Ctrl -
33
Select the row
Shift + Space
34
Select the column
Ctrl + Space
35
Replace
Ctrl + H
36
Create a link to somewhere
Ctrl + K
37
Insert chart (same worksheet)
Alt + F1
38
Insert chart (new worksheet)
F11
39
Debug formula
F9
40
Filter (toggle)
Ctrl + Shift + L
41
Create a 2nd instance of Excel (from Power Query)
Windows Key, then hold down Alt, Click Excel and then Yes
42
Highlight all columns in Power Query
Ctrl + A
43
What is a quick way to set print titles?
Highlight the rows & columns you want to set as titles, then type "print_titles" in name box (top right)
44
Quick way to move rows or columns
Shift + drag
