1
Ctrl + Shift + ↓ etc.Identify the ranges you use most
Candidates include input areas, summary areas, and master ranges. Select the range before proceeding.
named rangesF5large tables
Navigate Large Tables Comfortably with Named Ranges and F5 Jump
In large workbooks, the places you frequently visit are predictable. Naming those ranges and jumping to them with F5 transforms navigation efficiency.
Shortcuts you will master in this article
F5 / Ctrl + F3 / Ctrl + Home
Scrolling to the same spot every time makes large tables exhausting
Many workbooks have fixed, frequently visited areas — an input block in a budget table, an output range in a summary, a reference master. Scrolling there every time is inefficient.
Define a name for those ranges once, and F5 takes you there directly. The larger the table, the bigger the payoff.
How to use named ranges and F5
Define the name once and navigation becomes significantly easier from that point on.
2
Ctrl + F3Create the named range
Give it a memorable name to avoid confusion later.
3
F5Jump by specifying the name
Navigate using a meaningful name rather than a cell address.
4
Ctrl + HomeKeep awareness of overall position
Balance jumping around specific areas with occasionally returning to the top to maintain orientation.
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.
Tables where named ranges are most effective
Best suited for management tables used daily and summary tables operated by multiple team members.
The more clearly defined 'frequently visited areas' a workbook has, the greater the benefit.
Keep names short but meaningful — names that communicate purpose are more likely to stick.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
Frequently Asked Questions
Q. How many named ranges should I create?
A. Stick to the ranges you actually use frequently. Too many makes them hard to find.
Q. Is the advantage of F5 that I can jump to a name rather than a cell address?
A. Exactly. You navigate by meaning rather than location, which also makes handoffs easier to follow.
Q. Can I use named ranges someone else created?
A. Yes. If the naming convention is clear, it actually speeds up your understanding of the file.
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スキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →