Print preview display is missing lines in Excel
Thin lines or lines at certain positions in an Excel spreadsheet are not rendered in the print preview area when the print scaling is set too small. This problem occurs when you use any printer that uses a PCL driver or when you use the Microsoft XPS Document Writer or any other XPS printer. This problem does not occur when you use a printer that uses a PostScript (PS) driver.
Print preview is implemented by creating and displaying a metafile. If the file has a very small print scaling setting, such as less than 50 percent, thin lines or lines at certain positions are not rendered in the print preview area. This is because the preview graphic is too small to display many lines or lines that are too thin.