same heading on each page while printing

M

mariekek5

When I have a large document in Excel which I want to print....I only get the
heading on the first page... However, I would like the heading to show up on
each page...is that possible?

So it concerns the first row...

Thansk in advance
 
T

trip_to_tokyo

Page Layout / click on the arrow in the lower right hand corner of the Page
Setup list of options / Page Setup window will launch / Sheet tab / single
left hand click in the Rows to repeat at top: box / then click in the rows
that you wish to repeat at the top (for example rows 1 and 2) / this will put
$1:$2 in the Rows ro repeat at top: box / single left hand click on OK.

This should give you what you want. Steve.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top