200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Operating within a Cell – Microsoft Excel Shortcuts

Operating within a Cell

Cells are where the magic happens within Excel. They hold your data and text, can be grouped to create beautiful graphs, and are truly the organizational cornerstone of your spreadsheet. Each shortcut in this section will help you better move within a cell, as well as add and extract data.

Enter data and move down
Enter
Return
Enter data and move up
Shift Enter
Shift Return
Enter data and move right
Tab
Tab
Enter data and move left
Shift Tab
Shift Tab
Complete entry
Ctrl Enter
Control Enter
Enter the same data in multiple cells
Ctrl Enter
Control Enter
Insert current date into a cell
Ctrl ;
Control ;
Insert current time into a cell
Ctrl Shift :
Control Shift :
Paste from cell above
Ctrl D
Control D
Paste from cell left
Ctrl R
Control R
Copy formula from cell above
Ctrl '
Control '
Add a hyperlink
Ctrl K
⌘ K
Display autocomplete menu
Alt Down
Option Down
Flash fill
Ctrl E