Share via

print issues with Excel 2016

Anonymous
2017-11-16T21:51:28+00:00

When printing EXEL 2016 spreadsheets, the cell borders and shading do not print.  I am using WIN 10 and an HP Office JET 8710 printer.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2017-11-17T00:01:33+00:00

Hi David,

If print options are set to Black and white or Draft quality — either on purpose, or because the workbook contains large or complex worksheets and charts that caused draft mode to be turned on automatically — cell shading cannot print in color.

  1. On the Page Layout tab, in the Page Setup group, click the Page Setup dialog box launcher.
  2. On the Sheet tab, under Print, make sure that the Black and white and Draft quality check boxes are cleared.

Note: If you do not see colors in the worksheet, it may be that you are working in high contrast mode. If you do not see colors when you preview before you print, it may be that you do not have a color printer selected.

Keep us updated if anything comes up so we can further assist you.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest