Printing Top Two Rows In Excel

Avatar Image
joggerjayne | 11:49 Tue 28th Feb 2012 | Technology
2 Answers
I have a spread sheet (is that one word, or two??) and I have "frozen the panes" for the top two rows, so the top two rows stay on the screen when I scroll down the page.

Okay, that last explanation was probably not necessary. Anyone who can help with my question will obviously know what "freeze panes" involves, LOL.

So, anyway ...

Is it possible to have the first two rows of my spread sheet appear at the top of every page when I print the spread sheet?

Thanks, and "mwah" xxx



1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by joggerjayne. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Yes it is (in XL 2003)

Go to Page Setup, select the Sheet tab. You should see a box titled 'Rows to repeat at top'. Enter what you want there.
Question Author
Oh, thanks HK.

Much appreciated ... x x x

1 to 2 of 2rss feed

Do you know the answer?

Printing Top Two Rows In Excel

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.