If Extend mode is turned on, select cell A1 and press → and ↓ a few times. Moves to the next pane in a worksheet that has been split.ĭisplays the Spelling dialog box (the same as clicking Spelling on the Review tab). Note: you can also select named ranges, or click Special to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc. For example, to select cell C15, in the Reference box, type C15, and click OK. Note: if you are not editing a cell, F4 repeats the last action, if possible. For example, select cell B5 below, click in the formula bar, move the insertion point in or to the right of G2, and press F4. F4Ĭycles through all 4 types of cell references (absolute, mixed reference (2x) and relative). Note: of course, first create at least one named range. For example, select cell E2 below, type =SUM(, press F3 and select a name. Note: turn off Allow editing directly in cells (File, Options, Advanced, Editing Options) and pressing F2 will move the insertion point to the formula bar. For example, select cell B6 below and press F2. Moves the insertion point to the end of the contents of the active cell.
