|
|
|
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
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
Microsoft Office and Open Office word processing and spreadsheet programs have simple ways of sorting lists of data in tables and spreadsheets
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...
What the web knows about you
20 of the best memes
How to make your computer run more quietly
Choose Gold, Silver or Bronze membership
Save up to 40% on the cover price of each issue
Get access to the subscriber club exclusive website
Our price won't be beaten by any shop or website
A smartphone that's eye-catchingly different.
Basic Input Output System. Essential software built into every PC that connects the vital components....
|
|
|
|
|
Nikon Coolpix S570 BlackPrice: £66.99 |
Computeractive Ultimate Guide - Storage, Sharing & BackupPrice: £5.99 |
Back Issue CD-Rom 13 (2010)Price: £14.99 |
Hallmark Card Studio DeluxePrice: £15.31 |
Marine AquariumPrice: £15.41 |
