same heading on each page while printing
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.
"mariekek5" wrote:
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
|