Is this you?
To enter something in a cell just start typing; you don't have to double-click the cell or click into the formula bar.
To edit a cell, or check a formula, just press the F2 function key (in Windows). Once you've checked a formula just press the Escape key, to abandon editing.
When you are editing a cell (be it text, a formula, whatever) EITHER press the Enter key to complete your editing, OR press Escape to abandon the editing. There is no need to use the mouse. Even if you want to move to a different cell, I suggest pressing Enter first before reaching for the mouse. The Enter key (in effect) confirms your edit.
To create a formula.. type an equal sign. Don't double-click the cell or click into the formula bar.
Type the first letter or two (or three) of the function name. In the list that appears, press the Down arrow until the function you want is highlighted. Press the TAB key to select this function, or you can double-click its name in the list.

Click on the bottom cell of the ones that you want to use in your formula:

(You don't even need your mouse. You can just press the Up/Down arrows to navigate to the cell.)
Press Ctrl-Shift-Up (the Up arrow) to extend the selection upwards. If there is an empty cell in the range you'll have to press Ctrl-Shift-Up perhaps a few times to reach the top. (If you go too far up, press Ctrl-Shift-Down.)
Your data will probably have a header-cell at the top that is included in the selection:

Release the Ctrl key, using Shift-Down (without the Ctrl key) will adjust the selection so that you can exclude the top cell.
You can use Ctrl-Shift-Down, etc., if you are starting at the top and selecting downwards.
You have completed the formula. You can see it in the formula bar. But you do not need to click into the formula bar. Just press Enter to finish it.
Practice these keyboard combinations. Your productivity, and confidence with, Excel will improve.
- Double-clicking in a cell, even if it is empty
- Typing a formula in full
- Slowing dragging your mouse to highlight cells
- Trying to click in the formula bar
- Keep forgetting to finish editing a cell
To enter something in a cell just start typing; you don't have to double-click the cell or click into the formula bar.
To edit a cell, or check a formula, just press the F2 function key (in Windows). Once you've checked a formula just press the Escape key, to abandon editing.
When you are editing a cell (be it text, a formula, whatever) EITHER press the Enter key to complete your editing, OR press Escape to abandon the editing. There is no need to use the mouse. Even if you want to move to a different cell, I suggest pressing Enter first before reaching for the mouse. The Enter key (in effect) confirms your edit.
To create a formula.. type an equal sign. Don't double-click the cell or click into the formula bar.
Type the first letter or two (or three) of the function name. In the list that appears, press the Down arrow until the function you want is highlighted. Press the TAB key to select this function, or you can double-click its name in the list.

Click on the bottom cell of the ones that you want to use in your formula:

(You don't even need your mouse. You can just press the Up/Down arrows to navigate to the cell.)
Press Ctrl-Shift-Up (the Up arrow) to extend the selection upwards. If there is an empty cell in the range you'll have to press Ctrl-Shift-Up perhaps a few times to reach the top. (If you go too far up, press Ctrl-Shift-Down.)
Your data will probably have a header-cell at the top that is included in the selection:

Release the Ctrl key, using Shift-Down (without the Ctrl key) will adjust the selection so that you can exclude the top cell.
You can use Ctrl-Shift-Down, etc., if you are starting at the top and selecting downwards.
You have completed the formula. You can see it in the formula bar. But you do not need to click into the formula bar. Just press Enter to finish it.
Practice these keyboard combinations. Your productivity, and confidence with, Excel will improve.
0 Comments On This Entry
Trackbacks for this entry [ Trackback URL ]
← January 2021 →
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 |
Tags
My Blog Links
Recent Entries
Recent Comments
Search My Blog
0 user(s) viewing
0 Guests
0 member(s)
0 anonymous member(s)
0 member(s)
0 anonymous member(s)