Excel keyboard shortcuts, tested — why Ctrl+Arrow stops early and the two jobs of F4
If you want to do more with the keyboard and less with the mouse, this lesson is for you. On a made-up 'café orders' sheet (with row 8 left blank), we pressed common shortcuts one by one and wrote down exactly which cell, formula and value Excel ended up with. There is also a table of the shortcuts used in Excel Basics 1–7.
How we tested
We opened the practice file in Excel (Microsoft 365) on our PC, sent each shortcut straight to the Excel window, and then read the active cell, formula and value back from Excel. We ran the same steps on the Korean and English files and got the same results. Nothing was saved.
The keys went straight to Excel, not through the keyboard input method, so we didn't test whether a non-English input mode changes any of them (not verified). On laptops where F4 is mapped to something else (screen brightness and so on) you may need Fn+F4 — our test PC uses a desktop keyboard, so we didn't check that.
Move and select — Ctrl+Arrow stops at a blank cell
Instead of scrolling through a long list, press Ctrl+Arrow to jump to the edge of the data. The 'edge' is not the last row of the table, though — it is the cell before the next blank one. Row 8 in the practice file is empty, so Ctrl+Down from Amount E2 stopped at E7, not E13.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Date | Item | Qty | Price | Amount | Share |
| 2 | 2026-11-02 | Americano | 2 | 4,500 | 9,000 | |
| 3 | 2026-11-02 | Latte | 1 | 5,000 | 5,000 | |
| 4 | 2026-11-02 | Vanilla latte | 3 | 5,500 | 16,500 | |
| 5 | 2026-11-03 | Green tea latte | 2 | 4,800 | 9,600 | |
| 6 | 2026-11-03 | Americano | 4 | 4,500 | 18,000 | |
| 7 | 2026-11-03 | Latte | 2 | 5,000 | 10,000 | |
| 8 | ||||||
| 9 | 2026-11-04 | Americano | 3 | 4,500 | 13,500 | |
| 10 | 2026-11-04 | Vanilla latte | 1 | 5,500 | 5,500 | |
| 11 | 2026-11-04 | Green tea latte | 2 | 4,800 | 9,600 | |
| 12 | 2026-11-05 | Latte | 3 | 5,000 | 15,000 | |
| 13 | 2026-11-05 | Americano | 1 | 4,500 | 4,500 | |
| 14 | Total |
| Key (starting cell) | Result in Excel on our PC |
|---|---|
| Ctrl+Down (E2) | E7 — stops just above blank row 8 |
| Ctrl+Down again | E9 — jumps the gap to the next block |
| Ctrl+Down again | E13 — the last amount |
| Ctrl+Down again | E1048576 — with nothing below, the bottom of the sheet |
| Ctrl+Up (E9) | E7 — stops at the blank cell going up as well |
| Ctrl+Shift+Down (E2) | selects E2:E7 — status bar Count 6 · Sum 68,100 |
| Ctrl+Home (E5) | A1 |
| Ctrl+End | F14 — where the last used row and column meet |
| Ctrl+Space (E5) | the whole column E (E:E) |
| Shift+Space (E5) | the whole row 5 (5:5) |
| Ctrl+Page Down | the next sheet; Ctrl+Page Up goes back |
Ctrl+End has a catch of its own. After we typed into far-away H30 and then cleared it, Ctrl+End went to H30 instead of F14 — Excel remembers the last cell that was ever used. A saved copy, reopened, went back to F14. If Ctrl+End lands somewhere empty, save and reopen the file.
Trap 1 — AutoSum (Alt+=) also stops at a blank row
Press Alt+= in a total cell and Excel picks the numbers above and inserts =SUM( ) for you (the same AutoSum as in lesson 6). It picks them the way Ctrl+Up moves, though: in the practice file's total cell E14 it entered =SUM(E9:E13) — only the five rows below the blank row 8, 48,100. The real total is 116,200.
| What we did | Formula in the total cell | Value |
|---|---|---|
| Selected only E14, pressed Alt+= | =SUM(E9:E13) | 48,100 |
| Selected E2:E13 first, pressed Alt+= | =SUM(E2:E13) (placed in E14) | 116,200 |
| Deleted blank row 8 (Shift+Space > Ctrl+-), then Alt+= in total cell E13 | =SUM(E2:E12) | 116,200 |
After AutoSum, always glance at the range in the formula bar. A blank row in the middle makes Excel's guess shorter. The cleanest fix is to delete the blank row — you'll do that in the exercise.
F4 — toggles $ while editing, repeats otherwise
F4 does different things depending on what you're doing. While you edit a formula (after pressing F2 or clicking in the formula bar) it adds and removes $ on the reference at the cursor. With =E2/E14 in Share F2, each F2 → F4 changed it like this:
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Date | Item | Qty | Price | Amount | Share |
| 2 | 2026-11-02 | Americano | 2 | 4,500 | 9,000 | 7.7% |
| 3 | 2026-11-02 | Latte | 1 | 5,000 | 5,000 | |
| 4 | 2026-11-02 | Vanilla latte | 3 | 5,500 | 16,500 | |
| 5 | 2026-11-03 | Green tea latte | 2 | 4,800 | 9,600 | |
| 6 | 2026-11-03 | Americano | 4 | 4,500 | 18,000 | |
| 7 | 2026-11-03 | Latte | 2 | 5,000 | 10,000 | |
| 8 | ||||||
| 9 | 2026-11-04 | Americano | 3 | 4,500 | 13,500 | |
| 10 | 2026-11-04 | Vanilla latte | 1 | 5,500 | 5,500 | |
| 11 | 2026-11-04 | Green tea latte | 2 | 4,800 | 9,600 | |
| 12 | 2026-11-05 | Latte | 3 | 5,000 | 15,000 | |
| 13 | 2026-11-05 | Americano | 1 | 4,500 | 4,500 | |
| 14 | Total | 116,200 |
| F4 presses | F2 formula in Excel on our PC | Meaning |
|---|---|---|
| 0 | =E2/E14 | fill it down and the divisor slides to E15, E16, … |
| 1 | =E2/$E$14 | column and row locked — what a share-of-total needs |
| 2 | =E2/E$14 | row locked |
| 3 | =E2/$E14 | column locked |
| 4 | =E2/E14 | back to the start |
When you are not editing a formula, F4 means 'repeat last action'. After Ctrl+B on B2, selecting B9 and pressing F4 made B9 bold too, while B10 stayed as it was. Handy for inserting rows or applying a fill color in several places. If you pressed F4 for a $ and some other cell changed instead, you weren't in edit mode.
Entering values — today's date, the current time, one entry in many cells
| Keys | Result in Excel on our PC (Nov 12, afternoon) |
|---|---|
| Ctrl+; (A16) | 2026-11-12 — date format, and the cell holds the number 46338 (not a formula) |
| Ctrl+Shift+; (B16) | 4:03 PM — time format, and the cell holds a fraction of a day (not a formula) |
| Select H2:H4, type OK, press Ctrl+Enter | H2, H3 and H4 all say OK; H2:H4 stays selected |
| Ctrl+Z right after | all three cells cleared in one step |
A date entered with Ctrl+; is a value. =TODAY() changes every time the file opens; the Ctrl+; date still says November 12 tomorrow. Use it for dates that must not change, like 'date written'. Ctrl+` (the key left of 1) switches to Show Formulas, where you can see which cells hold numbers (the date and time show as 46338 and a fraction) and which hold formulas. Press it again to switch back.
Insert and delete rows, Format Cells
| What we did | Result in Excel on our PC |
|---|---|
| Selected row 8 (Shift+Space), pressed Ctrl+- | deleted right away — the rows below moved up (A8 became 2026-11-04) |
| Ctrl+Z right after | the blank row 8 came back |
| Selected one cell (C5), pressed Ctrl+Shift+= | the Insert dialog opened first (shift cells or insert an entire row?) |
| Selected one cell (C5), pressed Ctrl+- | the Delete dialog opened first |
| Ctrl+1 | the Format Cells dialog (used in lessons 5 and 7) |
To insert or delete whole rows, select the row with Shift+Space first, then press Ctrl+Shift+= or Ctrl+- — no dialog. With a single cell selected Excel asks what to shift. For columns, select with Ctrl+Space and use the same keys.
Shortcuts from Excel Basics 1–7 at a glance
| Lesson | Shortcut | What it did, as measured in that lesson |
|---|---|---|
| 1 New line in a cell | Alt+Enter | line break inside a cell — each break counts as one character (code 10) |
| 1 New line in a cell | Ctrl+H, then Ctrl+J in Find what | find every in-cell line break and replace them at once |
| 2 Tables | Ctrl+T | Format as Table — a new row typed right below joins the table |
| 4 AutoFill | Ctrl+D | copy the top cell down (references move down a row each time) |
| 5 and 7 | Ctrl+1 | Format Cells — Alignment (Center Across Selection) and Protection (Locked) |
| 6 SUM and AVERAGE | Alt+= | AutoSum — stops at text and blank cells (Trap 1 here) |
| All | Ctrl+Z | undo — even three cells filled by Ctrl+Enter at once |
Common snags
- Ctrl+Down doesn't reach the end: there's a blank cell in the way — it stops right above it; press again for the next block
- AutoSum added only part of the list: it picked the block on one side of a blank row — check the range in the formula bar, select the range first, or delete the blank row
- F4 changed another cell instead of adding $: you weren't editing, so it repeated your last action — press F2, put the cursor on the reference, then F4
- The Ctrl+; date never updates: it's a value — use =TODAY() if you always want today
- Ctrl+End goes to an empty cell: Excel remembers previously used cells — save and reopen
- A dialog pops up when inserting a row: only one cell was selected — select the row with Shift+Space first
Exercise
Open the practice file (made-up café orders) and try it without the mouse.
- 1Press Ctrl+Down from E2 and see where it stops, then on blank row 8 press Shift+Space and Ctrl+- to delete it.
- 2In the total cell (E13), press Alt+= and Enter. Check that the formula is =SUM(E2:E12) and the value 116,200.
- 3Type =E2/E13 in F2, press F2 then F4 to make it =E2/$E$13, and press Enter.
- 4Select F2:F12, press Ctrl+D to fill down, then Ctrl+1 > Number > Percentage with 1 decimal place.
The answer file has the blank row removed (rows 2–12), Total E13 =SUM(E2:E12) 116,200 and Share F2:F12 =E2/$E$13 (0.0%). F2 shows 7.7%, and the shares add up to 100%.
FAQ
Q. Why doesn't Ctrl+Down take me to the end of my table?
Ctrl+Arrow stops right before the next blank cell. In the practice file, Ctrl+Down from E2 stopped at E7 above blank row 8, then went to E9 and E13. Remove blank rows inside the table and it goes to the end in one press.
Q. Why didn't AutoSum (Alt+=) add up the whole column?
AutoSum picks the numbers above until it hits a blank or text cell. In total cell E14 it entered =SUM(E9:E13), 48,100. Select E2:E13 first, or delete the blank row, and you get 116,200.
Q. F4 isn't adding $ signs in Excel. Why?
F4 only cycles $ while you are editing a formula (E14 → $E$14 → E$14 → $E14 → E14). Otherwise it repeats your last action. Press F2 to edit, put the cursor on the reference and then press F4. On some laptops you may need Fn+F4.
Q. What's the shortcut for today's date in Excel?
Ctrl+; — on our PC it entered 2026-11-12 in a date format. It's a fixed value, not a formula, so it won't change tomorrow. Ctrl+Shift+; enters the current time.
Comments 0
No comments yet. Be the first.
Only members can comment.
Comments with ads, abuse, personal information or illegal content are hidden or removed. Members who post ads, spam, or hateful content are removed from the site, and everything they wrote is deleted. Comments are shown with your nickname. Privacy Policy