printing first row document

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Printing first row of document as heading | Excel forum

Printing first row of document as heading | Excel forum

resolvedResolved · Low Priority · Version 2003

Michelle has attended:
Excel Intermediate course

Printing first row of document as heading

How do I print the first row (ie with headings) as a 'heading' outside of the printed spreadsheet? That is, outside of the gridlines and as a separate heading?

RE: printing first row of document as heading

Hi Michelle

Thank you for your question and welcome to the forum.

Could you please elaborate on your question further for me; and then I can see if I can come up with a solution for you? I'm unclear what it is that you would like to be able to achieve.

Thank you
Amanda

RE: printing first row of document as heading

Hi Michelle,

As this question has been left unanswered for a couple of months, the system will automatically mark this query as resolved in the next 5 days if we don't hear from you.

If you still require assistance with this query, please post a reply and we will assist you further.

Thank you.

Rich

Mon 24 Nov 2008: Automatically marked as resolved.


 

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips


Server loaded in 0.08 secs.