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
Q.How do I store musician and other information about...
Q.Why can't my browser find the website address I typed...
Q.All updates have been downloaded, so why won't Windows...
Twitter is great on smartphones, but awful on Windows Phone 7
|
|
|
|
|
Nikon Coolpix S570 BlackPrice: £66.99 |
Computeractive Ultimate Guide - Storage, Sharing & BackupPrice: £5.99 |
Back Issue CD-Rom 13 (2010)Price: £9.99 |
Hallmark Card Studio DeluxePrice: £15.31 |
Marine AquariumPrice: £15.41 |