|
|
|
Set Openoffice Calc so that it leaves cells as blank if they contain a zero
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
Article tags
Related articles
We explain how to download and use this useful Open Office application
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
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
Q.Why are some of the keys on my keyboard doing strange...
Q.Is my phone’s Bluetooth any use?
Q.Can I switch boot drives so that I can work on older...
Make a profit from your unused gadgets
Run Windows and Ubuntu on the same computer
Hide private folders
Save up to 40% on the price
Exclusive subscriber website
Our price won't be beaten
St Helena, a 'small British village' in the mid-Atlantic, is seeking support and funding for a broadband connection
|
|
|
|
|
Computeractive Excel (2010) Online tutorialPrice: £19.99 |
Computeractive Word (2010) Online TutorialPrice: £19.99 |
Computeractive Powerpoint (2010) Online TutorialPrice: £19.99 |
Angry BirdsPrice: £9.99 |
Back Issue CD-Rom 14 (2011)Price: £15.99 |
