How to Insert Arrow in Google Sheets (6 Easy Methods)

Arrows are one of the most underrated tools in Google Sheets. They can make your spreadsheets easier to read, highlight important data, and even guide users through dashboards or workflows.

In this guide, we’ll cover everything about how to insert arrow in Google Sheets — from simple copy-paste symbols to custom shapes and dynamic arrows that automatically update based on your data.

Why Use Arrows in Google Sheets?

Before diving in, here’s why knowing how to add arrows in Google Sheets is worth your time:

• Show trends instantly — ▲ and ▼ communicate growth or decline faster than numbers alone
• Highlight KPIs — draw attention to the metrics that matter most
• Annotate charts — point to important data points inside dashboards
• Build flowcharts — map processes or workflows directly in your spreadsheet
• Replace text labels — a green ▲ communicates “increased” instantly

5 Ways to Insert Arrow in Google Sheets

Method 1: Copy and Paste an Arrow Symbol (Quickest Way)

The fastest way to insert arrow in Google Sheets is to copy a Unicode arrow symbol and paste it directly into a cell. No formulas, no menus needed — just copy from the table below and paste.

1. Copy an arrow from the table above (Ctrl+C on Windows / Cmd+C on Mac)
2. Click on the cell in your Google Sheet where you want the arrow
3. Paste with Ctrl+V (Windows) or Cmd+V (Mac)

Tip: You can paste an arrow next to text or numbers in the same cell — for example Sales ↑ 12% works perfectly. Increase the cell font size to make the arrow more visible.

Method 2: Insert Arrow in Google Sheets Using the Emoji

Google Sheets has a built-in emoji picker that includes arrow symbols — a quick way to insert arrow in Google Sheets without leaving your spreadsheet.

1. Click on the cell where you want the arrow
2. Go to the top menu and click Insert → Emoji
3. In the search box, type arrow
4. Click the arrow style you want — it inserts directly into the cell

This gives you access to colored arrows, directional arrows, and double arrows — all without needing to remember any codes.

Method 3: Insert Arrow Using Special Characters (via Google Docs)

Another simple method to insert an arrow symbol in Google Sheets is using the Special Characters tool in Google Docs. Google Sheets doesn’t have its own built-in character picker, but you can grab arrow symbols from Docs and paste them directly into your spreadsheet.

1. Open a Google Docs document
2. Click Insert → Special Characters from the top menu
3. In the search box, type arrow
4. Browse the results — you’ll find up arrows (↑), down arrows (↓), left/right arrows (← →), curved arrows, and double arrows (⇐ ⇒)
5. Click the arrow you want — it gets inserted into your Doc
6. Copy the arrow from Google Docs and paste it into your Google Sheets cell

Method 4: Use the CHAR or UNICHAR Function

For a formula-based approach to insert arrow in Google Sheets, use the CHAR() or UNICHAR() function. Both convert a Unicode number into its matching character — including arrows.

UNICHAR is the better choice for arrows — it supports the full Unicode range, while CHAR is limited to basic ASCII. Use this syntax:

=CHAR(number)
=UNICHAR(number)

Here are the most useful arrow codes for Google Sheets:

You can also combine an arrow with text in a single cell using the & operator:

="Revenue "&UNICHAR(9650)&" 15%"

This displays: Revenue ▲ 15% — all inside one cell.

Method 5: Dynamic Arrows That Auto-Update (IF + UNICHAR)

This is the most powerful way to use arrows in Google Sheets — making them appear automatically based on your data using an IF formula combined with UNICHAR. This is the method used in professional dashboards and KPI reports.

Basic Trend Arrow Formula

Suppose column A contains last month’s values and column B contains this month’s. Add this formula in column C to show an automatic arrow:

=IF(B2>A2, UNICHAR(9650), IF(B2<A2, UNICHAR(9660), "–"))

• If B2 is greater than A2 → shows ▲
• If B2 is less than A2 → shows ▼
• If they are equal → shows — (no change)

Drag the formula down the column and every row updates automatically. Change your data and the arrows change with it.

Your existing post also uses this approach with pasted arrow characters:

=IF(B2>A2,"↑",IF(B2<A2,"↓","→"))

Both work — the UNICHAR version is slightly more reliable across different devices and fonts.

Add Color with Conditional Formatting

To take it further, add green/red color to your arrows using conditional formatting:

1. Select the column containing your arrows (e.g. column C)
2. Go to Format → Conditional formatting
3. Under “Format cells if…” choose Text is exactly
4. In the value box, enter ▲
5. Set text color to green and click Done
6. Click Add another rule
7. Repeat: choose Text is exactly, enter ▼, set text color to red
8. Click Done

Now your sheet shows green ▲ for increases and red ▼ for decreases — a color-coded trend indicator that updates automatically with your data.

Method 6: Draw an Arrow Shape in Google Sheets

All the methods above insert arrow symbols inside cells. But if you need a larger arrow that floats over your sheet — for annotations, callouts, or flowcharts — use the Drawing tool.

1. Open your Google Sheets document
2. Click Insert → Drawing from the top menu
3. In the drawing canvas toolbar, click the Line icon and select Arrow — or click the Shape icon and choose from the Arrows category for block arrows
4. Click and drag on the canvas to draw the arrow
5. Customize the color, line thickness, and arrowhead style from the toolbar
6. Click Save and Close

Once the arrow is drawn, you can customize it further by changing the line color, thickness, arrowhead style, or switching to curved and double arrows.

When you’re happy with the result, click Save and Close. The arrow will appear floating over your Google Sheet.

After saving, you can click and drag the arrow to reposition it, drag the corner handles to resize, or double-click it to reopen the editor. This method is perfect for curved arrows, block arrows, double arrows, and directional callouts.

Arrow Annotations Inside Charts

You can also use the Drawing tool to place arrows directly inside a chart to highlight important trends or data points:

1. Create your chart in Google Sheets
2. Go to Insert → Drawing
3. Draw an arrow shape and style it to stand out
4. Click Save and Close, then drag the arrow over the chart area
5. Position it to point at the data point or trend you want to highlight

Which Arrow Method Should You Use?

Tips for Using Arrows Effectively in Google Sheets

• Be consistent with colors — green for positive, red for negative, gray for neutral throughout the same spreadsheet
• Use solid arrows (▲▼) for dashboards — they render more clearly at small sizes than outline arrows (↑↓)
• Don’t overuse arrows — they lose impact when every cell has one; use them to highlight what matters most
• Increase font size for arrow cells — 14–16pt makes arrow symbols much more readable in reports
• Center-align arrow cells — centered arrows look cleaner than left-aligned ones in data tables

Whether you use a quick copy-paste, the CHAR function, or a dynamic IF formula, knowing how to insert arrow in Google Sheets makes your spreadsheets more visual and easier to understand at a glance. For dashboards and reports, the IF + UNICHAR + conditional formatting combination is the most powerful — and once set up, it works automatically every time your data updates.