An Excel text box that disappears is often still in the workbook: it may be hidden in the Selection Pane, suppressed by the workbook’s object-display setting, or moved or resized by worksheet layout changes. In Excel for Microsoft 365 on Windows, first open Home > Find & Select > Selection Pane and turn on the visibility icon beside the text box; if it is not listed or still cannot be seen, check File > Options > Advanced > Display options for this workbook > For objects, show and choose All.
Start with the quickest checks
Before recreating the text box, check whether Excel is hiding objects or whether the box is simply outside the visible part of the sheet. Recreating it immediately can leave you with two boxes if the original later becomes visible again.
- Press Esc to leave cell-editing mode, then click a different cell. A text box may be hard to select while you are editing a cell or another object.
- Open Home > Find & Select > Selection Pane. Look for an item named TextBox, Text Box, or a custom name, and use its visibility control to show it.
- Check the object-display setting in Excel Options, described below. If it is set to hide objects, choose All.
- Try a different zoom level or scroll around the worksheet. The box may have been moved beyond the visible area or reduced to a very small size.
- If it appears on the worksheet but not on paper or in a PDF, check its print setting rather than its screen visibility.
These checks separate a hidden object from a deleted one. If the box does not appear in the Selection Pane and the workbook’s object display is set to All, look for an earlier saved copy or version before concluding it has been removed.
Find and show it in the Selection Pane
The Selection Pane lists drawing objects on the active worksheet, including text boxes, shapes, pictures, and charts. It is useful when an object is behind another shape, has no visible fill or border, or is too small to click. Open it from Home > Find & Select > Selection Pane. In the pane, select the visibility control beside an item to show or hide it. The exact icon appearance can vary with the Office interface, but the pane’s visibility control is used to switch an object’s display.
If there are many objects, select entries one at a time and watch the sheet. You can also select an entry in the pane to select the corresponding object, which makes it easier to inspect or reposition. If the text box belongs to a group, expand or select the group as needed; the text box may be nested inside it rather than listed as an obvious top-level item. The pane is specific to the active sheet, so check other worksheet tabs if you may be looking at the wrong sheet.
A hidden item in the pane is not the same as a deleted item. Turning its visibility back on restores the existing object and its text and formatting. If selecting the item does not show a usable box, the object might be off-screen, very small, or obscured by another object; keep it selected and use the arrow keys to move it, or inspect its size and position under the shape-formatting options.
Check Excel’s object-display setting
Excel has a workbook-level setting that controls whether objects are displayed. In the Windows desktop app, go to File > Options > Advanced. Under Display options for this workbook, find For objects, show and select All. If the setting is set to Nothing, shapes and text boxes can disappear from the sheet even though their contents have not necessarily been deleted. Placeholders can show object outlines or placeholders instead of normal objects.
The setting applies to the workbook selected in the options section, so confirm that it refers to the workbook you are trying to fix. It can affect more than text boxes: charts, pictures, and other drawing objects may also be missing. If several unrelated objects vanished at once, this display setting is a particularly useful check.
On Windows, Ctrl+6 can cycle through object-display states in Excel. If you use it, check the sheet after each press and stop when objects display normally. Because this shortcut changes how objects are shown, it does not by itself prove that an object was deleted or recover content that was removed. If the shortcut does nothing, use the Options dialog instead; keyboard layouts and shortcut conflicts can affect whether it is convenient to use.
Look for layout changes that moved or shrank the box
A text box is a floating drawing object, not text stored in a worksheet cell. Its position and size can nevertheless be linked to the cells underneath it. If rows or columns were hidden, resized, or filtered, a box with the Move and size with cells behavior may move or shrink along with that part of the sheet. A box placed entirely over hidden rows or columns can seem to have vanished.
Use the Selection Pane to select the object even if it is not visible, then inspect its placement and dimensions through the shape-formatting controls. In Excel desktop, select the object and open the Format Shape pane; under Size & Properties, review the Properties options. The available placement choices include Move and size with cells, Move but don’t size with cells, and Don’t move or size with cells. Choosing a different option can help prevent future surprises, but consider what should happen when the worksheet layout changes. For example, a label that must stay beside a particular table row may appropriately move with cells, while a logo intended to stay fixed on the sheet may be better kept independent of cell changes.
Also check for accidental dragging. If the box is selected in the pane, use the arrow keys to nudge it back into view. You can unhide relevant rows or columns from the row or column headers, and temporarily increase the zoom if the object has become very small. Avoid dragging blindly across the sheet: that can move another shape or alter the box’s position further.
Consider filters, groups, and worksheet protection
Filtering a table hides rows, and objects positioned over those rows may be affected according to their placement properties. Clear or change the filter temporarily and see whether the text box returns. If it does, adjust the object’s placement setting or reposition it outside the rows that are routinely hidden. This is different from a filter deleting the text box; the filter changes which rows are displayed.
Several objects can also be grouped. A text box inside a group may move, hide, or resize as part of that group, so check the Selection Pane for a group entry and expand it if available. Similarly, another opaque shape may cover the text box. Selecting the box through the pane can reveal that it exists even when clicking its visible area selects the covering object. Reordering objects or adjusting the covering shape may restore access.
Worksheet protection is another possible obstacle, but it usually prevents selecting or editing locked objects rather than making them disappear on its own. If the text box is visible but cannot be selected, the sheet may be protected, or the object may be locked. Ask the workbook owner for permission or the password if one is required; do not assume protection is a display fault. Protection settings and object visibility are separate issues.
If it is missing only when printing
A text box can appear on the worksheet but be omitted from a printout or PDF. Select the object and inspect Format Shape > Size & Properties > Properties for the Print object option. If printing is allowed for the object, confirm the correct worksheet and print area are selected and that the object lies within the area being printed. Use File > Print to preview the output before printing or saving a PDF.
Page layout, scaling, and page breaks can make an object fall outside the printed pages even though it remains visible in the normal worksheet view. A print area that excludes the cells beneath the box is another common explanation. Clear or revise the print area if appropriate, and check the page-break preview or print preview. Changing the screen zoom will not fix a print-area problem because zoom controls the worksheet view, not which content is included in the printed range.
Excel for the web and Mac differences
Excel for the web has a different interface from the Windows desktop app, and some object-formatting controls may be limited or arranged differently. If the Selection Pane is available in the ribbon, use it to locate and show the object. If you cannot find the pane or a needed setting in the web app, open the workbook in desktop Excel and check the Windows object-display setting and shape properties there. The web version can also render complex objects differently, so compare the workbook in the desktop app before assuming the object is gone.
On a Mac, ribbon labels and settings locations can differ from Windows. Look for the Selection Pane in the Home tab’s selection or editing controls, and check Excel’s View preferences for object-display options if objects are missing across the sheet. The Windows path File > Options > Advanced and the Windows Ctrl+6 shortcut should not be treated as Mac instructions. If the workbook is available on both platforms, desktop Windows Excel provides the exact Windows steps in this guide.
When to restore from a previous version
If the object is absent from the Selection Pane, the display setting is All, and you have checked the relevant sheets, it may have been deleted or removed in an earlier edit. Excel’s undo history can help if the removal happened during the current editing session, but it may not be available after closing the workbook or after other actions. Do not rely on undo as a way to recover an old saved state.
For a file stored in OneDrive or SharePoint, check whether version history is available and whether a prior version contains the text box. You can compare or restore a version according to your organization’s policies. Before restoring an older copy, consider saving the current workbook under another name; an older version may not include newer data or edits. For a local workbook, check backups or other copies. If the text itself is important and cannot be recovered, recreate the box only after confirming that it is genuinely missing.
Prevent text boxes from disappearing again
For important workbook labels, notes, or instructions, place objects deliberately and choose placement behavior that matches their purpose. A label that belongs to a row can move with that row; a title or logo that should remain in one sheet position may need a fixed placement. Avoid putting essential instructions solely in a floating text box if users may hide objects, filter underlying rows, or print selected ranges.
- Give important objects clear names in the Selection Pane, such as Instructions or Chart note, instead of leaving several identical default names.
- Keep a copy of the workbook before making broad layout, protection, or object changes.
- Check object visibility and print preview when preparing a workbook for someone else.
- Use cell comments or notes when the information belongs to a cell and does not need a freely positioned box; use a text box when its independent placement or formatting is useful.
These steps do not prevent every accidental change, but they make objects easier to identify and recover. A named object is much easier to distinguish from a chart or logo when the Selection Pane contains many entries.
Frequently Asked Questions
Why did all my text boxes and pictures disappear in Excel?
If many kinds of objects vanished together, check File > Options > Advanced > Display options for this workbook > For objects, show. Setting it to All restores normal object display when the workbook setting was suppressing them.
Can I recover a text box that is not visible in the Selection Pane?
First confirm that you are on the correct worksheet and that object display is set to All. If it is still absent from the pane, check version history, undo if the deletion was recent, or look for a backup. The pane cannot restore an object that was actually deleted.
Why can I see the text box but not select or edit it?
The sheet may be protected, the object may be locked, or another object may cover it. Try selecting it in the Selection Pane. If protection is active, ask the workbook owner to allow the required change or provide authorized access.
Why does my text box disappear when I filter rows?
Its position or size may be linked to the cells in filtered rows. Clear the filter to check, then select the box and review its placement behavior under Format Shape > Size & Properties > Properties.
Why is the text box visible in Excel but missing from a PDF?
Check the object’s Print object option, the worksheet’s print area, and print preview. The box may be excluded from printing or positioned outside the selected pages even though it appears on screen.