Excel can show arrows in three ways. An icon set draws colored arrows that change with the numbers. A custom number format puts ▲ or ▼ in front of the number while keeping it a number. A symbol in the cell (typed, pasted or made with UNICHAR) is a fixed character. Pick the one that matches what the arrow should do.
Quick answer
| You want | Fastest method |
|---|---|
| Colored up, side and down arrows that follow the values | Home → Conditional Formatting → Icon Sets → 3 Arrows (Colored) |
| ▲ for rises and ▼ for falls, still numbers | custom format [Green]“▲ “0.0%;[Red]”▼ “0.0%;0.0% |
| ↑ in a cell | =UNICHAR(8593) or paste ↑ |
| ↓ in a cell | =UNICHAR(8595) or paste ↓ |
| ▲ ▼ in a cell | =UNICHAR(9650), =UNICHAR(9660) |
| Any arrow | copy from the top of this page and paste into the cell |
Method 1: Icon sets (arrows that follow the numbers)
- Select the cells with the values, for example a column of month-on-month changes.
- Go to Home → Conditional Formatting → Icon Sets.
- Under Directional, choose 3 Arrows (Colored). Other choices there include 3 Arrows (Gray), 3 Triangles, 4 Arrows and 5 Arrows.
By default Excel splits the range into thirds (top third up, middle sideways, bottom third down), which is rarely what you want for gains and losses. To base it on the sign of the number:
- With the cells selected, go to Conditional Formatting → Manage Rules, pick the icon set rule and click Edit Rule.
- For the green up arrow, set the operator to >, Value to
0and Type to Number. - For the sideways arrow, set >=,
0, Number. Negative values now get the red down arrow, and exactly zero gets the sideways one. - To drop the middle arrow, change its icon to No Cell Icon.
- Tick Show Icon Only if you want arrows without the numbers. Click OK.
The same steps work in Excel for Mac (the menus are on the Home tab there too). Reverse Icon Order flips the colors when a lower number is better, such as costs or response times.
Method 2: Custom number format (▲ ▼ built into the number)
This keeps the value numeric, so totals, charts and formulas still work.
- Select the cells.
- Press Ctrl + 1 (Cmd + 1 on Mac), go to Number → Custom.
- In Type, enter (paste the triangles from this page):
[Green]"▲ "0.0%;[Red]"▼ "0.0%;0.0%
- Click OK.
The three parts are positive; negative; zero. A value of 0.052 shows as a green ▲ 5.2%, -0.031 as a red ▼ 3.1% (the format drops the minus sign because the arrow already says it went down), and 0 as 0.0%. For plain numbers instead of percentages, use 0.0 in place of 0.0%. Swap in ↑ and ↓ if you prefer thin arrows.
Method 3: An arrow character in the cell
Paste or type it
Copy an arrow from the top of this page and paste it into the cell or the formula bar. On Windows you can also open the symbol panel with Win + . (the Ω tab), or try the old numpad Alt codes Alt+24 (↑), Alt+25 (↓), Alt+30 (▲) and Alt+31 (▼) with Num Lock on; if one types nothing, paste or use UNICHAR instead. On a Mac, press Control + Command + Space and search “arrow” or “triangle”. Alt+X does not work in Excel.
With a formula
| Arrow | Formula |
|---|---|
| ↑ | =UNICHAR(8593) |
| ↓ | =UNICHAR(8595) |
| → | =UNICHAR(8594) |
| ← | =UNICHAR(8592) |
| ▲ | =UNICHAR(9650) |
| ▼ | =UNICHAR(9660) |
| ⬆ | =UNICHAR(11014) |
| ⬇ | =UNICHAR(11015) |
A formula can choose the arrow for you. With last month in B2 and this month in C2:
=IF(C2>B2,UNICHAR(9650),IF(C2<B2,UNICHAR(9660),"="))
To color the result, add a conditional formatting rule: Home → Conditional Formatting → Highlight Cells Rules → Text that Contains, type ▲ and pick green; repeat for ▼ in red.
Insert Symbol
On Windows, Insert → Symbol opens the symbol dialog. Leave the font on (normal text), set Subset to Arrows (or Geometric Shapes for ▲ ▼), click the arrow and choose Insert.
Which method should I use?
- Dashboard or report where values change: icon sets or the custom number format, so the arrows update themselves.
- You need to sum or chart the cells: the custom number format, because the cells stay numbers.
- A label, a header or a note: a pasted arrow or UNICHAR.
Troubleshooting
- The arrows are wrong for small changes. The icon set still uses the default percent thresholds. Edit the rule and set the type to Number as in Method 1.
- The custom format shows #####. The column is too narrow for the arrow plus the number. Widen it.
- The arrow shows as a box. The cell font lacks it. ↑ ↓ ▲ ▼ are in Aptos, Calibri, Arial and Segoe UI; switch to one of those.
- Alt+24 types nothing. Num Lock is off or the keyboard has no numpad. Paste the arrow or use UNICHAR.
For arrows in documents, see how to insert arrows in Word. The arrow symbols guide covers every other app, and the arrow symbols list has one-click copy for hundreds more.
Frequently asked questions
How do I put an up and down arrow in Excel? +
For arrows that follow the numbers, select the cells and choose Home → Conditional Formatting → Icon Sets → 3 Arrows (Colored). For a fixed arrow, type =UNICHAR(8593) for ↑ or =UNICHAR(8595) for ↓, or paste the arrow into the cell.
How do I show a green up arrow and a red down arrow for changes? +
Use a custom number format: Ctrl + 1 → Number → Custom, and enter [Green]"▲ "0.0%;[Red]"▼ "0.0%;0.0%. Positive values show a green ▲, negative values a red ▼, and the cells stay numbers.
What is the Excel formula for an up arrow? +
=UNICHAR(8593) returns ↑ and =UNICHAR(9650) returns the triangle ▲. For down, use 8595 (↓) or 9660 (▼). UNICHAR is in Excel 2013 and later, including Microsoft 365 on Windows and Mac.
Can Excel show only the arrow without the number? +
Yes. With an icon set, open Conditional Formatting → Manage Rules → Edit Rule and tick Show Icon Only. The number is still in the cell for formulas.