'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Header Date Slashes Not Printing But Visible in Preview
Question details
The user is trying to print a spreadsheet with an automatic date code in the header, but the slashes separating the date values are missing on the physical printout despite showing up correctly in the preview.
- Product
- Microsoft Excel 2024
- Device & OS
- not provided
- Scenario
- Printing a spreadsheet containing the &[Date] automatic header code.
- Observed behavior
- The automatic date displays correctly as 1/10/2025 in Print Preview, but prints out with spaces instead of slashes (e.g., 1 10 2025).
Ensure your printer is securely connected, turned on, and that you have sufficient paper loaded before running print spooling tests.
Isolate the Issue via Microsoft Print to PDF
Testing your print output by generating a PDF helps determine whether the missing slashes are caused by an Excel bug or a specific printer driver issue.
By bypassing the physical printer, you can check if Excel is actually sending the slash characters to the print spooler. If the slashes appear in the resulting PDF, your printer driver is likely at fault.
Click on 'File' in the top ribbon of Excel and select 'Print' from the left-hand menu.
Under the 'Printer' dropdown menu, change your active printer to 'Microsoft Print to PDF'.
Click the 'Print' button. A prompt will appear asking you to save the file; choose a location on your computer and save it.
Open the newly saved PDF document and inspect the header date. If the slashes are visible, you need to update or reinstall your physical printer's drivers.
Update Your Printer Drivers
If generating a PDF retains the slashes, updating your printer driver can resolve the communication error between Excel and the printer hardware.
Print Your Spreadsheets Flawlessly with WPS Office
If Microsoft Excel continues to drop characters during printing due to software glitches, try opening and printing your file in WPS Spreadsheet. It handles print spooling reliably and ensures what you see in the preview is exactly what you get on paper.
- 1. Install WPS Office: Download and install the free WPS Office suite on your device.
- 2. Open the Workbook: Launch WPS Spreadsheet and open your existing Excel file with the &[Date] header.
- 3. Preview and Print: Navigate to Menu > Print, verify the slashes in the Print Preview, and click Print to send the correctly formatted document to your printer.
Frequently Asked Questions
Why do date slashes disappear only when printing in Excel?
This typically occurs due to a communication error between Excel's print spooler and your specific printer driver. The driver might misinterpret certain fonts or special characters (like slashes) generated by dynamic header codes.
Can I manually type the date in the header as a workaround?
Yes. If the dynamic &[Date] code is failing to print correctly, go to Insert > Header & Footer, delete the code, and type the current date manually (e.g., 1/10/2025). This often bypasses the rendering bug.
Does changing the font fix dropped characters in headers?
It can. If the font currently applied to your header is not fully supported by your printer's memory, characters may be dropped. Try highlighting the header code and changing the font to a standard option like Arial or Calibri.
Why does the document print perfectly in Excel 2019 but not in Excel 2024?
Different versions of Excel use updated rendering engines. A change in how Excel 2024 processes print commands can sometimes cause compatibility issues with older printer drivers that worked flawlessly with Excel 2019.
