Entering Data Flashcards
1
Q
Enter data and move down
A
ENTER
2
Q
Entering data and move up
A
SHIFT + ENTER
3
Q
Enter data and move right
A
TAB
4
Q
Enter data and move left
A
SHIFT + TAB
5
Q
Enter and data and stay in same cell
A
CTRL + ENTER
6
Q
Enter same data in multiple cells (after copying, then selecting cells)
A
ENTER
7
Q
Insert current date
A
CTRL + ;
8
Q
Insert current time
A
CTRL + SHIFT + :
9
Q
Fill down from cell above
A
CTRL + D
10
Q
Fill right from cell on left
A
CTRL + R
11
Q
Copy formula from cell above (formula is exact copy)
A
CTRL + ‘
12
Q
Copy value from cell above
A
CTRL + SHIFT + “
13
Q
Insert hyperlink
A
CTRL + K
14
Q
Display AutoComplete list
A
ALT+ (down arrow)
15
Q
Flash fill
A
CTRL + E
