same heading on each page while printing

  • Thread starter Thread starter mariekek5
  • Start date Start date
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
 
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.
 
Back
Top