The fastest way to add a text box

Open the Insert tab at the top of Excel. Click Text Box — it sits in the ribbon between the Shapes button and the Word Art button. Your cursor will change to a crosshair. Click and drag on your spreadsheet to draw the box to the size you want, then type your text inside it.

The text box floats on top of your cells rather than living inside them, so it won't shift when you add or delete rows. This makes text boxes useful for labels, notes, titles, or callouts that need to stay in one visual spot regardless of what happens to your data below.

Key Takeaways

  • Text boxes are drawn objects that sit on top of your spreadsheet, not inside cells, so they stay in place when you edit rows or columns.
  • Insert a text box by clicking the Insert tab, selecting Text Box, then clicking and dragging to create the box size you need.
  • You can change the box's appearance by right-clicking it and choosing Format Shape to adjust colors, borders, shadows, and text alignment.
  • Text boxes can be moved by clicking and dragging them, resized by dragging the corner handles, or deleted by selecting and pressing Delete.

Moving and resizing a text box after you create it

Click once on the text box border (not the text inside) to select it. A box with handles appears around it. To move it, click and drag the border to a new location. To resize it, click and drag any of the corner or side handles — the corners let you resize both width and height at once, while the sides let you adjust one dimension.

If you click inside the text box to edit the text, you'll see a cursor blinking instead of the selection handles. Click the border again to switch back to selection mode so you can move or resize the box.

Changing the look of your text box

Right-click the text box border and select Format Shape. A panel opens on the right side of your screen with options to change the fill color, border color, border thickness, and shadow effects. You can also add a gradient fill or a pattern if you want the box to stand out more.

To change how the text looks inside the box, select the text by clicking inside and dragging to highlight it, then use the font options in the Home tab — size, color, bold, italic, and alignment all work the same way they do for cell text. You can also right-click the selected text and choose Font to open more detailed options.

Rotating and layering text boxes

If you need to rotate a text box, right-click it and select Format Shape. In the panel that opens, look for the rotation field — you can type a specific angle or use the rotation handle (a small circle above the box) to drag and rotate it by hand. Rotating is useful when you want text to run at an angle across your spreadsheet.

When you have multiple text boxes or shapes overlapping, right-click one and look for Arrange options. You can send a box backward or bring it forward to control which object appears on top. This matters when boxes overlap and you need one to be visible in front of the others.

Linking a text box to a cell

You can make a text box display the contents of a specific cell automatically. Click inside the text box to place your cursor, then type an equals sign followed by the cell reference — for example, =A1 — and press Enter. The text box will now show whatever is in cell A1, and it will update if you change that cell's content.

This is different from typing static text. If you type "Hello" in a text box, it stays "Hello" no matter what. But if you link it to a cell with =A1, the text box becomes a live display of that cell's value. This is useful for creating dashboards or summary sections that pull data from your spreadsheet automatically.

Copying and deleting text boxes

Click the text box border to select it, then press Ctrl+C to copy. Click where you want to paste and press Ctrl+V. The new box will appear slightly offset from the original so you can see both. You can then move it to the exact spot you need.

To delete a text box, click its border to select it and press Delete. The box and all its text disappear immediately. If you delete it by accident, press Ctrl+Z to undo. Clicking inside the text box and pressing Delete only removes the text inside, not the box itself — you have to select the border first to delete the entire object.

Frequently Asked Questions

Can I make a text box transparent so I can see the cells behind it?

Yes. Right-click the text box and select Format Shape. In the panel on the right, find the Fill section and choose No Fill. You can also keep a fill color but reduce its transparency by adjusting the Transparency slider. The text will still be visible even if the box background is transparent.

What's the difference between a text box and just typing in a cell?

Text in a cell moves with that cell if you insert or delete rows. A text box floats on top and stays in the same visual location. Text boxes are better for labels, titles, and notes that should stay put. Cells are better for data that belongs in your spreadsheet structure.

Can I protect a text box so it doesn't get moved or deleted by accident?

Right-click the text box and select Format Shape, then look for a Properties or Protection section. You can lock the object, but this only works if you also protect the sheet itself. Go to the Review tab, click Protect Sheet, and set a password. Locked objects can't be moved or deleted while sheet protection is on.

How do I add a text box to a chart in Excel?

Double-click the chart to enter edit mode. The Insert tab will change to show chart-specific options. Click Text Box and draw it inside the chart area. When you click outside the chart, you'll exit edit mode and the text box will be part of the chart object. To edit it later, double-click the chart again.