|
|
|
Stop Openoffice Calc from displaying sheet and page numbers
Q I use the Openoffice Calc spreadsheet to type lists. When I print these lists, the page always prints with the words 'Sheet 1' at the top and 'Page 1' at the bottom, even though these do not appear as I am typing.
I have to manually blank out these words and photocopy the sheet. Is there a
way to stop these words from printing out in the first place?
Christine Beale
A The unwanted text is contained in the header and footer of the document.
Unlike word processors, spreadsheets such as Openoffice Calc and Excel do not display this text except in the Print preview mode. It is very quick to turn it off, though.
Left-click on the Format menu and then on Page. Left-click on the Header tab and click in the box labelled Header on. Repeat for the Footer on option in the Footer tab. Click on OK to save the changes.
Baffled by jargon? See our free online jargon buster
Article tags
Related articles
Unless you've had a training course on Word, you probably know and use only a small percentage of its capabilities. Here are 10 top features for you to try out
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
Irfanview uses an automation feature called batch processing to change multiple images to a different size, format and name far faster than it would take manually
|
|
|
|
|
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 |
