Simple clear advice in plain English

Customise Openoffice Calc cells

Set Openoffice Calc so that it leaves cells as blank if they contain a zero

q-a-logo

If you have a long Openoffice Calc spreadsheet with lots of zero values, you might not necessarily want to see them. It is possible to set Calc so that it leaves cells as blank if they contain a zero. This can either be set for on screen only, printing only or both.

To remove the zeros from the screen, click on the Tools menu and then on Options. Left-click on the small plus sign next the entry for Openoffice.org Calc and then on the View option. Left-click in the box labelled Zero values so that the tick disappears. Click on OK to save the change.

To stop the zeros from printing, click on the Format menu and then Page. Click on the Sheet tab and then in the box labelled Zero values. Click on OK to save the change. The printing setting only applies to the current document.
Ufi ­ OpenOffice Help TNT blog

Reader Comments

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

Explore Open Office Writer illustration

Using Open Office Writer a free alternative to Microsoft Word

We explain how to download and use this useful Open Office application

Extensions for Open Office Writer

Use Open Office Writer as a free alternative to Microsoft Word

Open Office Writer is a great piece of software that has hundreds of features. Here we show you 10 lesser-known features that you might not have discovered yet

Word's undo feature

How to fix common PC errors

It’s easy to hit the wrong key when using a PC and throw yourself into a panic. There's no need to worry - we have easy fixes for 30 common everyday errors

Question & Answer

Q.Why are some of the keys on my keyboard doing strange...

> Read the answer

Q.Is my phone’s Bluetooth any use?

> Read the answer

Q.Can I switch boot drives so that I can work on older...

> Read the answer

Best deals on the web

img

Apple iMac 21.5" (MC309)

£926.40- Buy it now

img

Dell Inspiron 620 ST Intel Core i3-2100 3.10GHz / 3GB / 500GB / DVDRW / Win 7 Home Premium

£329.00- Buy it now

img

ZooStorm 7877-1023

£386.38- Buy it now

Latest issue & subscription deals

Poll

Are you concerned about viruses that target mobile phones?

Jargon Buster

Computing terms explained in plain English

CAD

Computer Aided Design. Software used to create 3D models.

Great shopping deals from Computeractive