Stop Clicking Random Cells — Multi-Select in Excel *Does* Work (Here’s How)
By Michael Lee
The first thing most people do when they need to select non-adjacent cells — say, D2, F5, and H9 — is hold Ctrl and click each one. Then they get confused when formatting doesn’t apply consistently, or Paste Special fails silently. That’s usually the wrong move — because Ctrl+click *does* create a multi-selection, but Excel treats it as fragile. One accidental arrow key? Gone. One right-click? Gone. One scroll? Gone. (Trust me, I learned this the hard way during a live client demo.)
The Myth
Most people believe Excel doesn’t support true multi-select — that it’s either "broken," "limited," or "only works sometimes." They’ll say things like "Excel just drops selections" or "it only works if you don’t breathe near the keyboard." Some even swear it worked in Excel 2010 but broke after an update. None of that’s true. What’s broken is the expectation — not the feature.
The Reality
Excel handles multi-select perfectly — if you use the right input method. The issue isn’t capability; it’s consistency. Below is a decision matrix comparing four common selection methods across five real-world criteria:
Criteria
Ctrl+Click
Alt+; (Go To Special)
Shift+F8 (Add to Selection)
F5 → Special → Blanks/Constants
Survives arrow-key navigation
❌ No
✅ Yes
✅ Yes
✅ Yes
Works inside formulas (e.g., SUM)
❌ No (formula bar shows only active cell)
❌ No
✅ Yes (SUM works across ranges)
✅ Yes
Allows paste into all selected cells
❌ Only pastes to top-left cell
✅ Yes (entire selection accepts paste)
✅ Yes
✅ Yes
Works on filtered data
✅ Yes
✅ Yes
❌ No (ignores visibility)
✅ Yes
Requires no prior range selection
✅ Yes
❌ No (needs at least one cell pre-selected)
✅ Yes
✅ Yes
Why the Myth Persists
Back in Excel 2003, Ctrl+click was the de facto method — and it mostly worked. But Microsoft quietly changed how selection state is handled starting with Excel 2013. The old behavior relied on UI-level focus, which collapsed under minor interactions. Meanwhile, thousands of YouTube videos and blog posts kept repeating “Ctrl+click = multi-select” without mentioning Shift+F8. Even Microsoft’s own Help docs buried Shift+F8 under “Advanced Selection Techniques” — a section most users never reach. And let’s be honest: nobody reads the tooltip that appears when you press Shift+F8 (“Extend selection”).
The Right Way
Use Shift+F8. That’s it. Press it once, then click or drag any cell or range. Press Shift+F8 again to add another. Keep going. You’ll see Excel show “Multiple Selections” in the status bar — that’s your confirmation.
Try this now with real data:
Now type "Revised" and press Ctrl+Enter. All three areas fill instantly — no copy-paste, no dragging, no macros. This works in Excel for Microsoft 365, Excel 2021, Excel 2019, and even Excel 2016.
Here’s sample data from a sales tracker (A1:E7):
Name
Company
Target ($)
Actual ($)
Date
Sarah Chen
Nexus Labs
$82,500
$79,100
2024-03-15
James Wu
Veridian Systems
$94,200
$101,800
2024-04-22
Lena Patel
Acme Corp
$76,900
$73,400
2024-05-10
Diego Morales
Stellar Dynamics
$88,300
$92,600
2024-06-01
Aisha Kim
Orion Group
$71,400
$68,900
2024-06-18
Rajiv Singh
TerraSoft Inc
$90,100
$95,300
2024-07-05
Proof It Works
Before using Shift+F8, users typically try Ctrl+click on these same six cells: A1, B3, C5, D2, E4, and A6. Here’s what actually happens in practice:
Action
Ctrl+Click Result
Shift+F8 Result
Apply bold font
Only A1 bolded
All 6 cells bolded
Paste value "Approved"
Only A1 receives text
All 6 cells receive "Approved"
Type =SUM(
Formula bar shows =SUM(A1) only
Formula bar shows =SUM(A1,B3,C5,D2,E4,A6)
Delete contents
Only A1 cleared
All 6 cells cleared
Exceptions
There are times when multi-select genuinely won’t work — not because Excel fails, but because the context blocks it. You cannot multi-select across:
Multiple worksheets: Shift+F8 stops working the moment you click into Sheet2. (Workaround: group sheets first with Ctrl+click on tabs.)
Merged cells: If any selected range includes a merged cell, Excel disables multi-select operations like paste or format fill.
Protected sheets: Even with Edit Objects permission, multi-select formatting is disabled unless Unprotect Sheet is used.
Cells inside Excel Tables with structured references: Try selecting B2 and D5 in a Table named SalesData — Excel forces you into table-row mode. Use Ctrl+A on the table first, then Shift+F8 within it.
One surprising tip: If Shift+F8 seems unresponsive, check whether Extend Selection mode is accidentally on (you’ll see “EXT” in the status bar). Press F8 to toggle it off — then try Shift+F8 again.
Ready to test it? Open any workbook. Click A1. Press Shift+F8. Click C4. Press Shift+F8. Click E7. Type "✓". Press Ctrl+Enter. Done. Now go fix that report you’ve been manually editing for 22 minutes.
Michael Lee
Michael covers the latest in office software updates
