office

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Office

Office

resolvedResolved · 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.


 

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips


Server loaded in 0.09 secs.