15 Excel Formatting Shortcuts for Financial Analysts (Investment Banking Cheat Sheet)
Excel formatting shortcuts are essential for financial analysts and investment bankers who build financial models every day. Whether you are building a three-statement model, a discounted cash flow model, or an LBO model, properly formatted spreadsheets make your work easier to read, audit, and maintain.
See also: Excel for investment banking
Excel Formatting Shortcut Cheat Sheet
If you only remember a few shortcuts, start with these. The table below covers the 15 most important formatting shortcuts used by financial analysts and investment bankers.
| Action | Excel Shortcut |
|---|---|
| Open Format Cells | Ctrl + 1 |
| Currency Format | Ctrl + Shift + $ |
| Percentage Format | Ctrl + Shift + % |
| Date Format | Ctrl + Shift + 3 |
| Thousands Separator | Ctrl + Shift + ! |
| Bold | Ctrl + B |
| Italic | Ctrl + I |
| Underline | Ctrl + U |
| Increase Decimal Places | Alt + H + 0 |
| Decrease Decimal Places | Alt + H + 9 |
| Borders | Alt + H + B |
| Fill Color | Alt + H + H |
| Font Color Menu | Alt + H + F + C |
| Autofit Column Width | Alt + H + O + I |
| Wrap Text | Alt + H + W |
These shortcuts allow analysts to format Excel spreadsheets faster while keeping their hands on the keyboard.
Why Formatting Matters in Financial Modeling
Formatting plays a critical role in financial modeling because it improves readability and auditability. Investment banking models often contain thousands of formulas, assumptions, and references.
Consistent formatting allows reviewers to quickly understand:
- which cells contain hardcoded assumptions
- which cells contain formulas
- which cells link to other worksheets
- which cells reference external files
Well-formatted spreadsheets make financial models easier to review and maintain. If you are learning financial modeling, you may also want to review our guide on Excel for financial modeling.
Standard Financial Modeling Color Conventions
Most investment banking and private equity models follow a consistent color system that signals where numbers originate.
| Meaning | Color | Hex Code |
|---|---|---|
| Hardcoded inputs | Blue | #0000FF |
| Formulas | Black | #000000 |
| Links to other worksheets | Green | #008000 |
| Links to external workbooks | Purple | #800080 |
- Blue cells (#0000FF) represent manually entered assumptions such as revenue growth rates or margin assumptions.
- Black cells (#000000) represent formulas.
- Green cells (#008000) indicate references to another worksheet.
- Purple cells (#800080) indicate references to another workbook.
These conventions help analysts audit spreadsheets quickly. If you are preparing for finance roles, you can also test your skills with our Excel skill assessment.
Key Excel Formatting Shortcuts Explained
Below are the formatting shortcuts most frequently used by financial analysts when building financial models.
Open Format Cells
Ctrl + 1 — Opens the Format Cells window where you can modify number formats, borders, alignment, and font formatting.
Currency Format
Ctrl + Shift + $ — Formats numbers as currency. Example: 1000000 → $1,000,000
Percentage Format
Ctrl + Shift + % — Used for formatting margins, growth rates, and discount rates. Example: 0.25 → 25%
Date Format
Ctrl + Shift + 3 — Formats values as dates.
Thousands Separator
Ctrl + Shift + ! — Adds thousands separators and two decimal places. Example: 1000000 → 1,000,000.00
Bold
Ctrl + B — Used for section headers and key financial metrics.
Italic
Ctrl + I — Often used for notes or comments in financial models.
Underline
Ctrl + U — Commonly used for subtotal lines in financial statements.
Increase Decimal Places
Alt + H + 0 — Adds decimal precision.
Decrease Decimal Places
Alt + H + 9 — Removes unnecessary decimal places.
Borders
Alt + H + B — Borders help structure financial statements and spreadsheets.
Fill Color
Alt + H + H — Used to highlight sections or assumptions.
Font Color Menu
Alt + H + F + C — Opens the font color menu so you can apply modeling colors like blue inputs or green references.
Autofit Column Width
Alt + H + O + I — Automatically resizes columns so text fits properly.
Wrap Text
Alt + H + W — Allows long labels to display across multiple lines.
Excel Formatting Shortcuts Used in Financial Modeling
In investment banking and private equity, analysts spend a significant portion of their time formatting models to meet presentation standards. Properly formatted models are expected in pitch books, client deliverables, and internal reviews.
The shortcuts covered above are not just time-savers — they are expected knowledge for anyone working in finance. Analysts who can format quickly while building models are more productive and produce cleaner work.
For a deeper look at how Excel is used in banking workflows, see our guide on Excel for investment banking.
How Investment Bankers Format Excel Models Faster
Many experienced Excel users customize the Quick Access Toolbar to create single-keystroke shortcuts for frequently used formatting commands.
Example setup:
- Alt + 1 → Paste Values
- Alt + 2 → Format Cells
- Alt + 3 → Borders
- Alt + 4 → Fill Color
- Alt + 5 → Font Color
This setup allows analysts to format spreadsheets almost entirely from the keyboard. You can also practice these shortcuts through structured Excel shortcut training drills.
Tips for Faster Excel Formatting
- Learn the top 5 shortcuts first. Ctrl + 1, Ctrl + Shift + $, Ctrl + Shift + %, Alt + H + B, and Alt + H + H cover most formatting tasks.
- Customize your Quick Access Toolbar. Map your most-used formatting commands to Alt + 1 through Alt + 9.
- Use Format Painter sparingly. It is useful, but learning the direct shortcuts is faster in the long run.
- Follow color conventions consistently. Blue for inputs, black for formulas, green for sheet links.
- Practice daily. Formatting speed comes from muscle memory, not memorization.
Frequently Asked Questions
Related Training
Ready to Get Faster?
Start practicing with hands-on Excel drills designed for financial professionals.