Adding a text box to your spreadsheet
A text box in Excel is a floating container for text that sits on top of your cells rather than inside them. You use text boxes when you need labels, notes, or explanations that don't belong in the grid itself — like a title for a chart, a warning about data, or instructions for someone using your sheet.
To add one, go to the Insert tab at the top of Excel. Look for the button labeled Text Box — it's usually in the middle section of the ribbon, often grouped with shapes. Click it once.
Your cursor will change to a crosshair. Click and drag on your spreadsheet to draw the text box to the size you want. You don't have to be exact — you can resize it later. Once you release the mouse, the text box will be ready for typing, and your cursor will blink inside it.
Key Takeaways
- Text boxes sit on top of cells and hold text that doesn't belong in the spreadsheet grid itself, like titles or warnings.
- Insert a text box by clicking the Insert tab, finding the Text Box button, and dragging to create the box on your sheet.
- You can move a text box by clicking its border and dragging it, and resize it by dragging the small squares at its corners and edges.
- Format text inside a text box using the Home tab — change font, size, color, and alignment the same way you would in a cell.
- Right-click a text box border to access options like fill color, outline style, and rotation.
Moving and resizing your text box
Once your text box exists, you can move it anywhere on the sheet. Click the border of the text box (not the text inside) and your cursor will change to a four-way arrow. Drag it to the new location.
To resize it, click the text box once to select it. You'll see small squares at the corners and along the edges — these are resize handles. Drag any corner handle to change both width and height at once, or drag an edge handle to change just one dimension. The text inside will reflow to fit the new size.
Formatting text inside the box
The text inside a text box can be formatted just like text in a cell. Click inside the text box to place your cursor there, then select the text you want to change. Use the Home tab to adjust the font, size, color, and bold or italic styling.
You can also change the alignment — left, center, or right — using the alignment buttons on the Home tab. If you want to select all the text in the box at once, press Ctrl+A while your cursor is inside the box.
Changing the box appearance
The text box itself — not the text, but the container — can be styled separately. Right-click the border of the text box (not the text inside) to open a menu. Look for options like Format Shape or Format Text Box.
From there you can change the fill color (the background inside the box), the outline color (the border), the outline thickness, and whether the outline is solid or dashed. You can also add a shadow or rotation if you need the box at an angle. These options let you make the text box stand out or blend in depending on what your sheet needs.
Anchoring a text box so it moves with cells
By default, a text box stays in the same spot on the sheet even if you insert or delete rows and columns. Sometimes you want it to move along with nearby data instead.
Right-click the text box border and look for Move and Size or similar wording. In the dialog that opens, you'll find an option to anchor the text box to a cell. Once anchored, if you insert a row above that cell, the text box moves down with it. This is useful when your text box is a label for a specific data range that might grow or shift.
Deleting or copying a text box
To delete a text box, click its border once to select it (your cursor should change to a four-way arrow, not a text cursor), then press Delete. Clicking inside the text and pressing Delete will only erase the text, not the box itself.
To copy a text box, click its border to select it, then press Ctrl+C. Click where you want the copy to appear and press Ctrl+V. The copy will be placed slightly offset from the original so you can see both. This is faster than creating a new text box from scratch if you need several boxes with the same formatting.
Common places text boxes go wrong
The most common mistake is clicking inside the text box to select it, which puts you in text-editing mode. When you're in text-editing mode, pressing Delete removes letters, not the box. To select the box itself for moving or deleting, click the border or edge of the box, not the text inside.
Another frequent issue is text boxes getting hidden behind cells or other objects. If you can't find a text box you know is there, right-click any visible object and look for a Selection Pane or Navigator option — this shows you all objects on the sheet and lets you click them even if they're hidden. You can also use the arrow keys to cycle through objects on the sheet.
Frequently Asked Questions
Can I make a text box transparent so only the text shows?
Yes. Right-click the text box border and choose Format Shape. Find the fill option and set it to No Fill. The background will disappear and only your text will be visible. You can keep the outline or remove that too by setting the outline to No Line.
What's the difference between a text box and just typing in a cell?
Text in a cell is part of the spreadsheet data and moves with the grid. A text box floats on top and is separate from the data. Use cells for information you might sort, filter, or calculate. Use text boxes for labels, instructions, or notes that should stay in one visual spot.
Can I rotate a text box?
Yes. Right-click the text box border and select Format Shape. Look for a rotation option — you can enter a specific angle in degrees, or some versions let you drag a rotation handle directly on the box. This is useful for creating angled labels or decorative elements.
How do I make text box text wrap to multiple lines?
Text wraps automatically when you make the text box narrower than the text length. You can also right-click the text box border, choose Format Shape, and look for a Text Options or Word Wrap setting to force wrapping even in a wide box.
Can I link a text box to a cell so it shows the cell's value?
Yes. Click inside the text box and type an equals sign followed by the cell reference, like =A1. Press Enter. The text box will now display whatever is in cell A1, and it will update automatically if that cell changes.