Ask Your Question

How do I make Calc not to print the background color of cells

asked 2017-10-03 04:22:20 +0200

juliehuang gravatar image

Some of the cells have background color.If I want the background color shown on screen, but not to be printed (Print Worksheet Without Fill Color in EXCEL), how should I do it?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-10-03 08:50:44 +0200

pierre-yves samyn gravatar image


AFAIK there is no option for that (except for the option that the printer driver can provide for color management)

A workaround might be to create a "print" sheet with the data but no background.

A quick way to achieve this:

  • select all data
  • click in the Name Box (left of formula bar) and type (eg) dataEnter (this creates a "name" for the range)
  • insert a new sheet, in A1 type =data and validate by Ctrl+Shift+Enter


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-03 04:22:20 +0200

Seen: 270 times

Last updated: Oct 03 '17