How to Fix Excel Text Box Content Missing from Print Preview
Question details
Text entered inside an Excel text box does not show up when viewing the print preview or on the final printed pages.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- A user is attempting to print a spreadsheet that includes text boxes, but the text box elements are completely absent from the final output.
- Observed behavior
- The text boxes are visible on the normal spreadsheet screen but disappear entirely in Print Preview and on physical printouts.
Verify that your printer is properly connected and functioning. Print a test page with standard spreadsheet cell data to confirm the printing issue is isolated strictly to the text boxes and not a general printer error.
Enable the Print Object Property in Shape Settings
This solution resolves the issue by ensuring the text box is explicitly instructed to render during the printing process.
By default, Excel configures newly inserted text boxes and shapes to print along with the worksheet. If this setting is accidentally cleared or altered during document formatting, the shapes will remain visible on your screen but will be excluded from the print spooler.
Click directly on the border of the text box that is failing to print to select it.
Right-click on the selected text box and choose 'Format Shape' from the context menu to open the formatting pane on the right side of your screen.
In the Format Shape pane, click on 'Shape Options' at the top, and then select the 'Size & Properties' icon (which usually looks like a square with measurement arrows).
Expand the 'Properties' section and check the box next to 'Print Object'. Your text box will now be included in printouts.
Print Spreadsheets Flawlessly with WPS Office
WPS Office offers a highly compatible and intuitive spreadsheet environment. It ensures that your text boxes, charts, and formatted objects print exactly as they appear on your screen without hidden property conflicts.
- 1. Open your Document: Download and launch WPS Office, then open your existing spreadsheet containing the text boxes.
- 2. Access Object Properties: Right-click the text box you wish to print and select 'Format Object' from the dropdown menu.
- 3. Verify Print Settings: Navigate to the Properties tab within the settings pane and ensure the 'Print Object' option is selected.
- 4. Print Easily: Click the Print icon or press Ctrl+P/Cmd+P to immediately view an accurate print preview and print your document.
Frequently Asked Questions
Why are my charts and shapes also missing when I print from Excel?
Like text boxes, charts and other shapes have their own 'Print Object' property. If they are missing from printouts, right-click the chart or shape, go to Format Chart Area or Format Shape, navigate to Properties, and check the 'Print Object' box.
How can I fix multiple text boxes that won't print at the same time?
You can change the setting for multiple objects simultaneously by holding down the Ctrl key (or Cmd on Mac) and clicking each text box to select them all. Then, right-click any of the selected boxes, choose Format Object, and enable 'Print Object' in the Properties section.
What if my text box still doesn't appear in Print Preview after enabling Print Object?
Check your Print Area settings. If the text box is positioned outside of the worksheet's defined print area, it will not be printed. Go to the Page Layout tab, click Print Area, and either clear it or redefine it to include the cells behind your text box.
