← Excel Course contents
📗 Excel · Basics 8Published · 9 min read

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.

Home
E2fx=C2*D2
ABCDEF
1DateItemQtyPriceAmountShare
22026-11-02Americano24,5009,000
32026-11-02Latte15,0005,000
42026-11-02Vanilla latte35,50016,500
52026-11-03Green tea latte24,8009,600
62026-11-03Americano44,50018,000
72026-11-03Latte25,00010,000
8
92026-11-04Americano34,50013,500
102026-11-04Vanilla latte15,5005,500
112026-11-04Green tea latte24,8009,600
122026-11-05Latte35,00015,000
132026-11-05Americano14,5004,500
14 Total
1/7A made-up café order list — row 8 is blank. Select Amount E2 and press Ctrl+Down
Follow along — same cell addresses as the practice file (steps advance on their own)
Key (starting cell)Result in Excel on our PC
Ctrl+Down (E2)E7 — stops just above blank row 8
Ctrl+Down againE9 — jumps the gap to the next block
Ctrl+Down againE13 — the last amount
Ctrl+Down againE1048576 — 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+EndF14 — 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 Downthe 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 didFormula in the total cellValue
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:

Home
F2fx=E2/E14
ABCDEF
1DateItemQtyPriceAmountShare
22026-11-02Americano24,5009,0007.7%
32026-11-02Latte15,0005,000
42026-11-02Vanilla latte35,50016,500
52026-11-03Green tea latte24,8009,600
62026-11-03Americano44,50018,000
72026-11-03Latte25,00010,000
8
92026-11-04Americano34,50013,500
102026-11-04Vanilla latte15,5005,500
112026-11-04Green tea latte24,8009,600
122026-11-05Latte35,00015,000
132026-11-05Americano14,5004,500
14 Total116,200
1/6Share F2 is =E2/E14 — fill it down and the divisor slides to E15, E16, …
Follow along — same cell addresses as the practice file (steps advance on their own)
F4 pressesF2 formula in Excel on our PCMeaning
0=E2/E14fill it down and the divisor slides to E15, E16, …
1=E2/$E$14column and row locked — what a share-of-total needs
2=E2/E$14row locked
3=E2/$E14column locked
4=E2/E14back 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

KeysResult 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+EnterH2, H3 and H4 all say OK; H2:H4 stays selected
Ctrl+Z right afterall 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 didResult 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 afterthe 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+1the 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

LessonShortcutWhat it did, as measured in that lesson
1 New line in a cellAlt+Enterline break inside a cell — each break counts as one character (code 10)
1 New line in a cellCtrl+H, then Ctrl+J in Find whatfind every in-cell line break and replace them at once
2 TablesCtrl+TFormat as Table — a new row typed right below joins the table
4 AutoFillCtrl+Dcopy the top cell down (references move down a row each time)
5 and 7Ctrl+1Format Cells — Alignment (Center Across Selection) and Protection (Locked)
6 SUM and AVERAGEAlt+=AutoSum — stops at text and blank cells (Trap 1 here)
AllCtrl+Zundo — 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.

  1. 1Press Ctrl+Down from E2 and see where it stops, then on blank row 8 press Shift+Space and Ctrl+- to delete it.
  2. 2In the total cell (E13), press Alt+= and Enter. Check that the formula is =SUM(E2:E12) and the value 116,200.
  3. 3Type =E2/E13 in F2, press F2 then F4 to make it =E2/$E$13, and press Enter.
  4. 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