Entering data
Entering data
Shortcut | Windows | Mac |
---|---|---|
Enter and move down | Enter | Return |
Enter and move up | ShiftEnter | ⇧Return |
Enter and move right | Tab | Tab |
Enter and move left | ShiftTab | ⇧Tab |
Complete entry and stay in same cell | CtrlEnter | ⌃Return |
Enter same data in multiple cells | CtrlEnter | ⌃Return |
Insert current date | Ctrl; | ⌃; |
Insert current time | CtrlShift: | ⌘; |
Fill down from cell above | CtrlD | ⌘D |
Fill right from cell left | CtrlR | ⌘R |
Copy formula from cell above | Ctrl‘ | ⌘‘ |
Copy value from cell above | CtrlShift“ | ⌃⇧“ |
Add hyperlink | CtrlK | ⌘K |
Display AutoComplete list | Alt↓ | ⌥↓ |
Flash fill | CtrlE | ⌃E |