Excel borders not showing on print preview

This document is for Windows 8 and 7, Excel 2013 and 2010, and the following HP printers: ENVY 4500 Deskjet 1010 Deskjet Ink Advantage 1015 ENVY 5530 Deskjet 1510

Excel borders not showing on print preview

This document is for Windows 8 and 7, Excel 2013 and 2010, and the following HP printers: ENVY 4500  Deskjet 1010 Deskjet Ink Advantage 1015 ENVY 5530  Deskjet 1510  Deskjet Ink Advantage 1510  Envy 5640  Deskjet 2540 Deskjet Ink Advantage 2540  Officejet 2620  Deskjet Ink Advantage 2645  Deskjet Ink Advantage 4510  Officejet 4630  Deskjet Ink Advantage 3540  Deskjet Ink Advantage 4640  When printing an Excel (2013 or 2010) spreadsheet with gridlines or default borders (style 2), not all horizontal lines print.  This might occur in Normal or Draft printing mode in Windows 8 and 7.For borders, using any border format other than the default style enables correct printing in Normal printing mode.  Follow these steps to change the border format.

  1. Highlight the area to print.
  2. On the Home tab, in the Font group, click the Borders Button (

). The Format Cells window displays.

  1. Click a non-default line style, and then click OK.

Borders and gridlines print as expected in high quality printing mode. Follow these steps to change the printing mode in Excel.

  1. In Excel, click File.
  2. Click Print.
  3. Click Printer Properties.
  4. Click the Paper/Quality tab.
  5. Click Best in Excel 2013, or Quality in Excel 2010.

Configuring the printer to use an alternative driver enables printing of borders and gridlines in Excel in Normal and Draft mode printing.

  1. If the HP printer driver is not installed for your printer, install the software from the inbox CD or download and install it from the HP website.
  2. Navigate to Devices and Printers.
  • Windows 8Right click the Start Button (

) and then click Control Panel. Click Devices and Printers in the Control Panel window.

  • Windows 7Click the Start Button (

) and then click Devices and Printers.

  1. Right click the icon for your printer, and then click Printer Properties.Figure : Example of opening the 'Printer properties' window
Image: Open the 'Printer properties' window
  1. Write down or copy the name of your printer shown in the first text box in the General tab to use later.Figure : Save the name of your printer
Image: Save the name of your printer as it appears in the printer properties window
  1. Click the Advanced tab and then click  New Driver.Figure : The 'New Driver' button on the advanced tab of the Printer properties window
Image: The 'New Driver' button on the advanced tab of the Printer properties window
  1. In the Add Printer Driver Wizard window, click Next.Figure : The 'Add Printer Driver Wizard' window displays
Image: The 'Add Printer Driver Wizard' window displays
  1. Click Windows Update to update the list of available drivers.  It may take a few minutes for the list to update.Figure : Update the available printer drivers
Image: Select 'Windows Update' on the 'Add Printer Driver Wizard' window
  1. Under the Manufacturer list, click Hewlett-Packard.
  2. Under the Printer list, click HP Deskjet 3520 series.  Figure : Click the new driver
Image: Click the new driver
  1. Click Next  and then click Finish to complete the process.
note:Make sure that you choose the Deskjet 3520 driver, even if your printer model is in the list. This driver is compatible with your printer and should cause no loss is in printer functionality.
  1. Verify that the driver changed to HP Deskjet 3520 series, and then click OK.Figure : Check the driver on the 'Advanced' tab
Image: Verify the driver on the 'Advanced' tab

The printer should now be listed as the HP Deskjet 3520 series.

  1. Right-click this printer, and then click Printer Properties.Figure : Open the Printer Properties
Image: Open the Printer Properties
  1. On the General tab, change the name back to your printer name, and then click OK. Figure : Change the name back to the original
Image: Change the name back

After completeing one ot the above workarounds, Excel gridlines should print as expected.

Video liên quan