Printing Top Two Rows In Excel

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

=0)

prev

Picture in Signature

next

Urgent laptop help needed""

Answers

1 to 2 of 2

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 2

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.