How to Hide a Text Box Border in Excel Without Deleting It

To hide a text box border in Excel for Microsoft 365 on Windows, select the text box, open Shape Format > Shape Outline, and choose No Outline. This removes the box’s visible line but keeps the text box and its contents in place. You can still select and edit it later. Before you begin, click the text box’s outer edge rather than placing the cursor inside its text.

What You’ll Need

An Excel workbook containing the text box you want to change. Consider saving the workbook first if you are making several layout changes.
Excel for Microsoft 365 on Windows, as described in the steps below. Excel for Mac has a similar Shape Format option; Excel for the web may show a more limited set of formatting controls.
A mouse or trackpad is helpful for selecting the box’s edge accurately. You do not need a formula, add-in, or macro.

Step-by-Step

Open the worksheet and locate the text box. Open the workbook and go to the sheet that contains the box. If the box is partly covered by another object, or you have several overlapping objects, use Home > Find & Select > Selection Pane. In the Selection Pane, identify the text box in the list and select it. You can rename objects in the pane to make them easier to identify in future, but renaming is not required to remove the border.
Select the text box as an object. Click once on the box’s outside edge. You should see sizing handles around it, and the ribbon should show the Shape Format tab. If you see a text insertion cursor inside the words, you are editing the text rather than formatting the whole object. Press Esc once, then click the edge. If clicking the edge is difficult, select the object by its name in the Selection Pane instead.
Open the outline controls. Click Shape Format on the ribbon, then select Shape Outline. The menu contains line colors, weights, dash styles, and other outline options. Make sure the text box itself is selected before opening this menu; otherwise, the outline command may not appear or may apply to a different shape.
Choose No Outline. In the Shape Outline menu, click No Outline. The visible border should disappear immediately. This setting removes the line around the text box; it does not delete the box, erase its text, or change the worksheet cells behind it.
Check the result with the object deselected. Click an empty part of the worksheet, away from the text box. This hides the selection handles so you can judge how the box will look during normal viewing. If you still see a line, read the troubleshooting section below before changing other formatting. It may be a selection indicator, a cell gridline, or a separate shape rather than the text box’s outline.
Save the workbook. Use Ctrl+S on Windows, or Command+S on a Mac, to save your change. If you need to confirm how the worksheet will appear on paper, open File > Print and check the preview. Do not assume that a line visible only while the object is selected will print as a border.

Alternative using the Format Shape pane: If the Shape Outline menu is unavailable or you want to inspect the line setting directly, right-click the text box’s edge and choose Format Shape. In the pane, open Fill & Line (the paint-bucket icon), expand Line, and choose No line. Depending on the Excel build and pane layout, the line controls may be grouped under a slightly different heading, but look for the Line section and its No line option. This route is useful when you need to change the fill and outline separately.

On Excel for Mac, select the text box, open the Shape Format tab, and choose Shape Outline > No Outline. The ribbon layout can vary with the window size and Excel version, so maximize the window or look for the Shape Format tab after selecting the box. If you are using Excel for the web and cannot find the same outline control, open the workbook in the desktop app to apply the change, then save it. Names or placement of controls can differ slightly between releases, but the goal is to set the shape’s line to none.

Common Mistakes

Choosing a border color instead of removing the border. Setting the outline to white or to the worksheet’s background color can make a line hard to see on one screen, but it is not the same as having no outline. The line can become visible on a colored background, in a different theme, or when the workbook is printed. Choose No Outline or No line for a genuine border-free text box.

Removing the fill instead of the outline. Shape Fill > No Fill changes the background inside the box, not the line around its edge. If you want both a transparent background and no border, apply both settings separately: set the fill to No Fill, then set the outline to No Outline. If the text box already has no fill, changing its fill is unnecessary.

Clicking inside the text rather than on the object. When the text cursor is active, Excel may show text-editing controls instead of the shape-format controls. Exit text editing with Esc, click the outer edge, and check that sizing handles appear before changing the outline.

Deleting the box by mistake. Pressing Delete while the whole text box is selected removes the object and its text. Use the No Outline setting instead. If the box was deleted accidentally, immediately try Ctrl+Z on Windows or Command+Z on Mac, provided you have not made other changes you want to keep.

Tips

Keep the text box editable. Removing its line is a visual formatting change, not a lock or deletion. You can select the box again, edit the wording, resize it, or restore a line later through Shape Format > Shape Outline.
Make the fill decision separately. If the box sits over cells and should let them show through, use Shape Fill > No Fill as well as No Outline. If the text needs a solid background for readability, keep or choose a fill while removing only the outline.
Use the Selection Pane for crowded sheets. Choose Home > Find & Select > Selection Pane to select a text box that is behind another shape or hard to click. Selecting the correct object is especially important when a worksheet has labels, icons, and decorative shapes layered together.
Check the sheet at normal zoom. A thin outline can seem present at high zoom, and worksheet gridlines may show through a transparent text box. Click away and view the sheet at the zoom level people will normally use before deciding the border is still there.
Check print output when the worksheet is a form or report. Use File > Print to inspect the page preview. A text box with No Outline should not print its own outline, though gridlines, cell borders, or another overlapping object can still appear.
Change the line rather than layering over it. Placing a white rectangle over the border can hide it temporarily, but it adds another object that may move, cover cells, or print unexpectedly. Setting the text box outline to none is simpler and more reliable.

Troubleshooting

The Shape Format tab does not appear. The text may be selected for editing, or a worksheet cell may be active instead of the box. Press Esc, click the text box’s outer boundary, and look for sizing handles. If you cannot reach the boundary, use the Selection Pane and select the object there. If the sheet is protected and object editing is restricted, ask the workbook owner to allow the required changes or provide an editable copy.

The border seems to remain after No Outline. First click outside the object. Handles and a selection boundary are editing indicators and may appear while the object is selected even when its printed outline is off. If a solid line remains after deselection, reselect the object and check Shape Format > Shape Outline. Confirm that you changed the text box you meant to change, especially if several boxes overlap. Look for another rectangle, line, or cell border underneath or beside it; removing one object’s outline will not remove a different object’s line.

The text box has a colored background after changing the outline. The fill is independent of the outline. Select the box, choose Shape Format > Shape Fill > No Fill if you want a transparent interior. If you want the background to remain solid, leave the fill as it is. Be careful not to choose a fill color that obscures worksheet data behind the box.

The box is hard to select because it is behind another object. Open Home > Find & Select > Selection Pane and select the text box from the object list. You can use the pane’s visibility controls to temporarily hide an object that is in the way, then select the correct text box and change its outline. Restore any temporarily hidden objects afterward so the worksheet layout is not unintentionally altered.

The border appears in a printout or PDF. Check the print preview and confirm that the line is not a cell border, gridline, or neighboring shape. Then select the text box and verify its Line setting in Format Shape. If the border disappears in Excel but remains in an exported file, save the workbook, close and reopen it, and export again. Also check that the PDF or printout is from the updated workbook rather than an older saved copy.

You are using Excel for the web and cannot find the setting. Excel for the web may not expose every drawing-format control in the same place as the desktop app. If the outline option is missing, open the workbook in Excel for Microsoft 365 on Windows or Mac, set the outline to No Outline, save the workbook, and then return to the web version.

Frequently Asked Questions

Will removing the border delete the text box?
No. Choosing No Outline hides only the line around the shape. The text, position, fill, and ability to edit the text box remain unchanged.

Can I hide the border but keep a colored background?
Yes. Set Shape Outline > No Outline and leave the fill color in place. Outline and fill are separate settings, so changing one does not require changing the other.

Can I make the text box transparent as well as borderless?
Yes. Select the box and set Shape Fill > No Fill and Shape Outline > No Outline. The text remains visible, while the cells behind the box can show through its interior.

Can I restore the border later?
Yes. Select the text box and choose a line color or another outline option from Shape Format > Shape Outline. You can also use Format Shape to select a line style and color.

Why do I still see a dotted or colored edge while editing?
It may be the selection boundary and sizing handles Excel displays so you can move or resize the object. Click elsewhere on the worksheet to deselect it. If the edge remains when the box is unselected, inspect its outline setting and check for another shape or cell border.

Does this work on charts or other shapes too?
The Shape Outline controls also apply to many other drawing objects, including basic shapes. A chart has separate chart-area and plot-area formatting, so select the specific chart element whose line you want to change rather than assuming the text box instructions target it.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.