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.
- Highlight the area to print.
- On the Home tab, in the Font group, click the Borders Button (
). The Format Cells window displays.
- 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.
- In Excel, click File.
- Click Print.
- Click Printer Properties.
- Click the Paper/Quality tab.
- 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.
- 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.
- 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.
- Right click the icon for your printer, and then click Printer Properties.Figure : Example of opening the 'Printer properties' window
- 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
- Click the Advanced tab and then click New Driver.Figure : The 'New Driver' button on the advanced tab of the Printer properties window
- In the Add Printer Driver Wizard window, click Next.Figure : The 'Add Printer Driver Wizard' window displays
- 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
- Under the Manufacturer list, click Hewlett-Packard.
- Under the Printer list, click HP Deskjet 3520 series. Figure : Click the new driver
- 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.
- Verify that the driver changed to HP Deskjet 3520 series, and then click OK.Figure : Check the driver on the 'Advanced' tab
The printer should now be listed as the HP Deskjet 3520 series.
- Right-click this printer, and then click Printer Properties.Figure : Open the Printer Properties
- On the General tab, change the name back to your printer name, and then click OK. Figure : Change the name back to the original
After completeing one ot the above workarounds, Excel gridlines should print as expected.