Entering data Flashcards
1
Q
Enter and move down
A
Enter
Return
2
Q
Enter and move up
A
ShiftEnter
⇧Return
3
Q
Enter and move right
A
Tab
Tab
4
Q
Enter and move left
A
ShiftTab
⇧Tab
5
Q
Complete entry and stay in same cell
A
CtrlEnter
⌃Return
6
Q
Enter same data in multiple cells
A
CtrlEnter
⌃Return
7
Q
Insert current date
A
Ctrl;
⌃;
8
Q
Insert current time
A
CtrlShift:
⌘;
9
Q
Fill down from cell above
A
CtrlD
⌘D
10
Q
Fill right from cell left
A
CtrlR
⌘R
11
Q
Copy formula from cell above
A
Ctrl’
⌘’
12
Q
Copy value from cell above
A
CtrlShift”
⌃⇧”
13
Q
Add hyperlink
A
CtrlK
⌘K
14
Q
Display AutoComplete list
A
Alt↓
⌥↓
15
Q
Flash fill
A
CtrlE
⌃E