Speed in Excel is one of the most tangible skills that separates strong investment banking analysts from average ones. When you are building financial models, updating pitch books at 2 AM, and turning comments from a Managing Director in real time, every second matters. The analysts who know their Excel shortcuts can do in two keystrokes what others do with five clicks — and that compounds across hundreds of tasks each week.
This guide covers the most important Excel shortcuts for investment banking, organized by category so you can start practicing the ones that will have the biggest impact on your workflow.
Why Excel Speed Matters in Investment Banking
Investment banking is a service business, and responsiveness is a core part of the value proposition. When a senior banker asks for a sensitivity analysis on a deal, they do not want to wait an hour for something that should take fifteen minutes. The faster you are in Excel, the more capacity you have to take on work, check your output, and still get some sleep.
Beyond raw speed, strong Excel skills signal competence. When you sit down with a VP or MD and they watch you navigate a model using only the keyboard, it builds confidence in your technical abilities. Conversely, if you are clicking through menus and using the mouse for everything, it raises questions about your readiness — even if your analysis is correct.
If you are still preparing for recruiting, our Technical Cheatsheet covers the core technical concepts you will need to pair with these Excel skills.
Navigation Shortcuts
Navigation shortcuts help you move around spreadsheets quickly without touching the mouse. These are the foundation of keyboard-driven Excel work.
Moving Between Cells and Sheets
- Ctrl + Arrow Keys — Jump to the edge of a data region in the direction of the arrow. This is essential for moving quickly through large models.
- Ctrl + Home — Jump to cell A1 of the current sheet.
- Ctrl + End — Jump to the last used cell in the worksheet.
- Ctrl + Page Up / Page Down — Move between worksheet tabs. This is one of the most-used shortcuts in banking because models often have many tabs.
- Ctrl + G (or F5) — Open the Go To dialog box, useful for navigating to specific cells or named ranges.
Selecting Cells Efficiently
- Ctrl + Shift + Arrow Keys — Select from the current cell to the edge of the data region. Use this to quickly highlight entire rows or columns of data.
- Ctrl + Shift + End — Select from the current cell to the last used cell.
- Ctrl + Space — Select the entire column.
- Shift + Space — Select the entire row.
- Ctrl + A — Select the entire data region (or entire sheet if pressed twice).
Formatting Shortcuts
Formatting in investment banking is taken extremely seriously. Clean, consistent formatting signals attention to detail and professionalism. These shortcuts help you format cells without leaving the keyboard.
Number Formatting
- Ctrl + Shift + 1 — Apply number format with two decimal places and thousands separators. This is the standard format for most financial data.
- Ctrl + Shift + 4 — Apply currency format.
- Ctrl + Shift + 5 — Apply percentage format.
- Ctrl + Shift + ~ — Apply general number format (removes formatting).
Cell Formatting
- Ctrl + 1 — Open the Format Cells dialog. This is the master shortcut for all formatting needs — number formats, borders, fonts, alignment, and more.
- Ctrl + B — Bold.
- Ctrl + I — Italic.
- Ctrl + U — Underline.
- Alt + H + B + A — Apply borders to all edges of selected cells (using the Ribbon).
- Alt + H + H — Open fill color picker.
In banking, you will use custom number formats frequently. For example, formatting negative numbers in parentheses with red font, or displaying values in millions with one decimal place. Memorizing Ctrl + 1 and learning the custom format codes is well worth the investment.
Editing and Formula Shortcuts
When you are building or updating financial models, you spend most of your time writing and editing formulas. These shortcuts streamline that process.
Core Editing
- F2 — Enter edit mode for the active cell. This lets you modify a formula without retyping it.
- Ctrl + Z — Undo the last action. You will use this constantly.
- Ctrl + Y — Redo the last undone action.
- Ctrl + D — Fill down. Copies the formula or value from the cell above into the selected cells below.
- Ctrl + R — Fill right. Same concept but fills to the right.
- Ctrl + Enter — Enter a value or formula into all selected cells simultaneously.
- Tab — Move to the next cell to the right after entering data.
Formula-Specific Shortcuts
- F4 — Toggle absolute and relative cell references ($A$1 vs A1 vs $A1 vs A$1). This is critical when building formulas that need to anchor to specific cells.
- Ctrl + ` (backtick) — Toggle between showing formulas and showing values. Useful for auditing a model.
- Alt + = — Auto-sum the selected range. Excel guesses which cells to sum based on adjacent data.
- Ctrl + Shift + Enter — Enter an array formula (for older versions of Excel without dynamic arrays).
- F9 — While editing a formula, press F9 to evaluate a selected portion of the formula. This is invaluable for debugging complex nested formulas.
Row, Column, and Sheet Management
Managing the structure of your workbook — inserting rows, hiding columns, adding sheets — is something you do constantly in banking.
- Ctrl + Shift + + — Insert new cells, rows, or columns (depending on what is selected).
- Ctrl + – — Delete selected cells, rows, or columns.
- Alt + H + O + I — Auto-fit column width to contents.
- Ctrl + 9 — Hide selected rows.
- Ctrl + 0 — Hide selected columns.
- Ctrl + Shift + 9 — Unhide selected rows.
- Alt + H + O + U + L — Unhide columns.
- Shift + F11 — Insert a new worksheet.
Copy, Paste, and Paste Special
Paste Special is one of the most important tool categories in banking Excel work. You often need to paste just values (removing formulas), paste formatting only, or transpose data.
- Ctrl + C — Copy.
- Ctrl + V — Paste.
- Ctrl + X — Cut.
- Ctrl + Alt + V — Open Paste Special dialog.
- Alt + E + S + V + Enter — Paste Values. This is one of the most frequently used sequences in banking. It pastes the calculated values without the underlying formulas.
- Alt + E + S + T + Enter — Paste Formats only.
- Alt + E + S + E + Enter — Paste Transpose.
Paste Values is particularly important when you want to hard-code numbers — for example, when you finalize model outputs for a pitch book or lock in historical data so it does not accidentally get overwritten.
Auditing and Debugging Shortcuts
When you are reviewing models — whether your own or someone else’s — auditing shortcuts help you trace the logic and catch errors. This is essential for error checking and auditing financial models.
- Ctrl + [ — Trace precedents (jump to the cells that a formula references).
- Ctrl + ] — Trace dependents (jump to the cells that reference the current cell).
- Alt + M + P — Show trace precedent arrows.
- Alt + M + D — Show trace dependent arrows.
- Alt + M + A + A — Remove all trace arrows.
- Ctrl + ` — Toggle formula view to see all formulas in the sheet at once.
How to Practice and Build Muscle Memory
Knowing the shortcuts intellectually is not enough — you need to practice until they become automatic. Here are some practical tips:
- Remove your mouse for practice sessions. Force yourself to navigate and format using only the keyboard for at least 30 minutes per day. The discomfort fades quickly.
- Focus on 5-10 shortcuts at a time. Trying to learn them all at once leads to information overload. Pick the ones most relevant to your current work and practice those until they are second nature.
- Practice in the context of real tasks. Build a simple DCF model or comps analysis using only keyboard shortcuts. This builds muscle memory in a realistic setting.
- Print a cheat sheet. Keep a list of the shortcuts you are trying to learn taped near your monitor. Refer to it instead of reaching for the mouse.
- Use Alt key sequences for Ribbon commands. Press Alt to see the letter shortcuts for each Ribbon tab, then navigate from there. Once you learn the sequences you use most, they become just as fast as dedicated shortcuts.
Mac vs. PC Differences
Most investment banks use PCs (Windows), so the shortcuts in this guide are Windows-focused. If you are practicing on a Mac, note that Ctrl generally maps to Cmd, and Alt maps to Option — but Ribbon navigation shortcuts (Alt + H, etc.) do not work on Mac. The F4 shortcut for toggling absolute references requires Cmd + T on Mac instead. Mac Excel has historically lagged behind the Windows version in both features and shortcuts, which is one reason banks standardize on PCs.
If you are recruiting for investment banking and currently use a Mac, it is worth getting comfortable with Windows Excel before you start. Many interview prep processes include live modeling tests on Windows machines.
Shortcuts That Impress in Modeling Tests
During superday modeling tests or on-the-job exercises, a few shortcuts stand out as particularly impressive to people watching you work:
- F4 for toggling references — quickly locking or unlocking cell references shows you understand formula design.
- Alt + E + S + V for Paste Values — this is used so frequently in banking that it is practically a handshake.
- Ctrl + [ to trace precedents — jumping into referenced cells shows you can audit and follow model logic.
- Ctrl + Shift + Arrow + Arrow patterns for selecting ranges — moving fluidly through large datasets signals comfort with Excel.
- Ctrl + 1 for custom formatting — formatting numbers correctly and quickly is a core analyst skill.
Final Thoughts
Excel proficiency is one of the few areas in investment banking where deliberate practice before you start the job pays off immediately. Unlike deal experience or client management skills, which take years to develop, you can become genuinely fast in Excel in a few weeks of focused effort. Start with the navigation and formula shortcuts, then layer in formatting and auditing as they become relevant to your work. The goal is not to memorize every shortcut — it is to build a core set of habits that let you work at the speed of thought.
For more on the broader skills you need for a career in banking, check out our free investment banking course.
Want Personalized Interview Coaching?
If you are serious about breaking into investment banking, the best thing you can do is work with someone who has been through the recruiting process and knows exactly what top banks are looking for. At Wall Street Mastermind, we have helped over 2,500 students land offers at every bulge bracket and elite boutique bank on Wall Street. Book a free strategy call to learn how we can help you prepare for your interviews and maximize your chances of landing the offer.
Related Articles
- Financial Modeling Best Practices for Investment Banking
- Formatting Standards in Investment Banking: The Unwritten Rules
- Excel Functions Every Investment Banker Should Know
- Error Checking and Auditing Financial Models
- 3-Statement Financial Model: Complete Guide
- Sensitivity Analysis and Data Tables in Financial Modeling
Follow Wall Street Mastermind
Stay up to date with the latest investment banking recruiting tips, technical guides, and career advice:
- YouTube
- TikTok
- X (Twitter)
- Podcast: Apple Podcasts | Spotify | SoundCloud
