98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Office
Office
Resolved · Urgent Priority · Version 2003
Jodie has attended:
Excel Intermediate course
Office
Hello,
I am working with Excel 2003 on a document and i cant remember what to do to stop the top of a document from displaying on every page when printed?
I am amending and updating a document that wasnt created by myself and originally the cells outside of the area being used were grey (i.e the document had been cropped)... could you please let me how i can do this?
I hope this makes sense? if not it would i be able to send you the front sheet of the document i am working on so i can show you what i mean? Look forward to hearing from you.
Look forward to hearing from you.
Kindest regards,
Jodie
RE: Office
Hello Jodie,
To turn off the printing of titles on the top of each printed page in excel, view the Page Setup dialog (from the File menu), Select the Sheet tab. You will see the Print Titles section, e.g. Rows to repeat and Columns to repeat... Clear these ranges out.
That will stop the specified areas from being repeated at the top of each page.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
RE: Office
Thank you for your help re the print settings, i will give this a try.
Can you please help me with another problem as mentioned in my last email?
* I am amending and updating a document that wasnt created by myself and originally the cells outside of the area being used were grey (i.e the document had been cropped)... could you please let me how i can do this?
I spoke to someone at your office called Paul last week Friday and he let me email the said document to him and provided me with his mobile number so we could speak however unfortunately i was tied up in meetings etc and he said he will not be in the office today... can i email you the document so you can have a look or do you have a number i can contact you on?
I have a deadline of Friday for this document to be handed in so would really appreciate your help.
Many thanks and i look forward to hearing from you,
Jodie
RE: Office
Hi Jodie
Thank you for question. I have left a message with one of your colleagues. Let me know if you still need help with your Excel document.
It sounds like the the printable area had been set on your sheet. To do this highlight the cells you would like to see in the printed version then from the File menu choose Print Area then Set Print Area.
Now only the cells included in your selection will appear when the sheet is sent to the printer.
The option to clear the print area is in the same menu.
Let me know if this helps or if you have further questions.
Kind regards,
Andrew
Fri 21 Oct 2011: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create own ribbon tab - Excel 2010a. In Excel click on the File tab |