Donate SIGN UP

Basic Microsoft Excel question

Avatar Image
NJOK | 16:12 Tue 11th Jul 2006 | Technology
1 Answers
Hi. I have a spreadsheet of annual accounts and I want to show just one month per page when I print it out. I know how to put in page breaks but how do I make sure the top two rows appear on every page?

Thanks.
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by NJOK. 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.
From the FILE menu select PAGE SETUP.

Select SHEET, then click the wee coloured bit to the right of
ROWS TO REPEAT AT TOP, Highlight the top 2 rows.

Now click on the wee button under the X and click OK.

Only 1 answerrss feed

Do you know the answer?

Basic Microsoft Excel question

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.