1
Ctrl + FOpen the Find dialog
Searches the current sheet for text or values. Press Enter or 'Find Next' to move through each match.
Tip: Press Esc to close the dialog.
SearchCtrl+FLarge Tables
Find Any Cell Instantly with Ctrl+F —
Practical Excel Search Techniques
Even in a 5,000-row table, Ctrl+F takes you to the right value instantly. But without knowing the search options, you'll hit pitfalls like too many similar results or missing entries on other sheets.
Shortcuts you will master in this article
Ctrl + F / Ctrl + H
Scrolling by eye causes missed entries and wasted time
Scrolling through thousands of rows visually leads to missed values when similar data appears in sequence. Losing track of where you left off is another classic problem when not using search.
Ctrl+F supports more than simple string matching: you can distinguish case, match entire cell contents, and use wildcards (* and ?). Without knowing these options, you might wrongly conclude that a value doesn't exist.
Practical Ctrl+F Search Techniques
From basic operation to advanced option settings, covering common real-world scenarios.
2
Alt + O (expand Options)Open advanced search options
The 'Options' button (or Alt+T) in the Find dialog enables case sensitivity, whole-cell matching, and choosing what to search (values, formulas, or comments).
Tip: 'Match entire cell contents' is useful when you want to avoid partial matches.
3
* or ? wildcardsSearch with fuzzy patterns
Use 'Tanaka*' to find strings starting with 'Tanaka', or '?da' to find cells where 'da' is the second and third characters.
Tip: To search for a literal asterisk, enter '~*'. The tilde (~) is the escape character.
4
Select 'Workbook' scopeSearch across multiple sheets at once
Change the 'Within' option in the search dialog from 'Sheet' to 'Workbook' to search all sheets simultaneously.
Tip: Useful when you've inherited a file and need to find which sheet a particular code appears on.
5
Ctrl + HSwitch directly to the Replace dialog
From the Ctrl+F dialog, pressing Ctrl+H switches to the Replace tab. Use this when you want to find something and immediately correct it.
Tip: Search and replace share the same panel, so you can transition directly without reopening.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
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.
Situations Where Mastering Search Pays Off
Customer codes or rep names scattered across thousands of rows — Ctrl+F gets you there instantly.
'Match entire cell contents' prevents false positives from partial matches.
Workbook-wide search dramatically speeds up understanding the structure of inherited files.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
Frequently Asked Questions
Q. Ctrl+F says 'Not found' but the value is definitely there.
A. The displayed value and the underlying stored value may differ (for example, a date stored as a number). Switch the 'Look in' option between 'Values' and 'Formulas' and try again.
Q. Can I search with case sensitivity?
A. Yes. Check 'Match case' in the Options section of the Find dialog.
Q. How do I search for a literal asterisk (*)?
A. Enter '~*'. The tilde (~) acts as an escape character in Excel search.
Q. How do I memorize Excel shortcuts faster?
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スキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →