Reaching for the mouse every time you filter, then accidentally copying hidden rows when you paste — these two frustrations disappear once you learn to drive Excel filters from the keyboard.
Shortcuts you will master in this article
Ctrl + Shift + L / Alt + ↓ / Alt + ; / Ctrl + Home
Excel filter operations involve a chain of small actions: navigate to the header, open the dropdown, pick a value, review results, then copy. Doing every one of those with the mouse adds up quickly. Switching to keyboard shortcuts breaks that chain.
The trickier problem is that a plain Ctrl+C after filtering includes hidden rows in the clipboard. If you don't know Alt+;, the paste looks correct on screen but the row count is wrong at the destination.
This flow is designed for the most common real-world task: filter a table, then copy only the visible results.
Ctrl + Shift + LSelect any cell inside the table and press the shortcut to add filter arrows to the header row. Press it again to remove them instantly.
Tip: This is where you break the dependency on the mouse for filters.
Alt + ↓Move to the header cell of the column you want to filter, then press Alt+↓ to open the dropdown.
Tip: No more hunting for the tiny filter arrow with the mouse pointer.
↓ / Space / EnterUse the arrow keys to move through options, Space to check an item, and Enter to apply. You can complete the entire selection without touching the mouse.
Tip: If the list has a search box, typing directly filters the options even faster.
Ctrl + HomeAfter filtering, your scroll position is often in the middle of nowhere. Ctrl+Home returns you to A1 so you can review results from the start.
Tip: Also useful for confirming the header row after filtering.
Ctrl + Shift + ↓ / →Extend the selection from the header down to the last row and across to the last column in one keystroke, regardless of table size.
Tip: The larger the table, the bigger the time saving.
Alt + ;This is the key step before copying filtered results. Alt+; re-selects the current range but excludes hidden rows.
Tip: This is one of the most impactful shortcuts most Excel users have never heard of.
Ctrl + CWith only visible cells selected, pasting to another sheet or workbook will match what you see — no hidden-row surprises.
Tip: If you also need values-only paste, combine this with Ctrl+Alt+V to keep your options open.
Excel Shortcut Practice
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + Shift + L | Toggle AutoFilter |
Alt + Down | Open Filter Menu |
Ctrl + Home | Go to A1 |
Ctrl + Shift + Up | Select to Edge of Data |
Alt + ; | Select Visible Cells Only |
Ctrl + C | Copy |
A. Yes. Learn Ctrl+Shift+L to toggle filters on and off, and Alt+↓ to open a column's filter menu. Those two cover the majority of filter work without the mouse.
A. A normal copy targets the entire selected range, including hidden rows. Press Alt+; to select only visible cells first, then Ctrl+C to copy.
A. Ctrl+Shift+L and Alt+↓ behave similarly, but visible-cell selection can vary by environment. Verify the behavior on your machine and fall back to the menu if needed.
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →