Essential keyboard shortcuts 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