Entering Data Shortcuts Flashcards
1
Q
Enter Text and Move Down
A
Enter
2
Q
Enter Text and Move Right
A
Tab
3
Q
Enter Text and Move Up
A
Shift + Enter
4
Q
Enter Text and Move Left
A
Shift + Tab
5
Q
Complete Entry and Stay In Same Cell
A
Ctrl + Enter
6
Q
Enter Same Data In Multiply Cells
A
Ctrl + Enter
7
Q
Copy Formula From Cell Above
A
Ctrl + ‘
8
Q
Copy Value From Cell Above
A
Ctrl + Shift + “
9
Q
Add Hyperlink
A
Ctrl + K
10
Q
Insert Current Date
A
Ctrl + ;
11
Q
Insert Current Time
A
Ctrl + :
12
Q
Display Autocomplete List
A
Alt + Down Arrow
13
Q
Flash Fill
A
Ctrl + E
14
Q
Fill Down
A
Ctrl + D
15
Q
Fill Right
A
Ctrl + R
