Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly. We’ve listed our favorites below.
Control-Down/Up Arrow = Moves to the top or bottom cell of the current column Control-Left/Right Arrow = Moves to the cell furthest left or right in the current row
Control-Shift-Down/Up Arrow = Selects all the cells above or below the current cell
Shift-F11 = Creates a new blank worksheet within your workbook
F2 = opens the cell for editing in the formula bar
Control-Home = Navigates to cell A1
Control-End = Navigates to the last cell that contains data
Alt-= = Autosums the cells above the current cell
Excel is arguably one of the best programs ever made, and it has remained the gold standard for nearly all businesses worldwide. But whether you’re a newbie or a power user, there's always something left to learn. Or do you think you've seen it all and done it all? Let us know what we've missed in the comments.