Header- making it stick to the top

[Christeh]

Hi,

I'll try to explain as best as I can (sorry for my english). Im working with one worksheet, which has many many rows (287) and columns (7). It gaves me approx. 35 pages. I need to print them all with their headers.

So far everything is ok, I put the titles and they repeat on each page BUT they move around the page. I want to stick the header to the same place on EVERY page so the report looks consistent and profesional. Sometimes it gets to the middle of the page and much white space on top of the title. Im supposing it has to deal with the Page Breaks, but when I go to that view, I cant really do anything, all I do is mess it up even more.

One thing I see, is that in Normal View (excel 2007), it shows two kind of lines at the end of the pages: one with very little bites of lines and the other one with bigger lines.

How do I do to make the header/titles stick to the very top on each page???

[BigBas]

My suggestion is to open up the file, press CTRL+A to select the entire sheet, then RESET ALL PAGE BREAKS ( that is found in the INSERT dropdown on Excel 2003; not sure where it is on Excel 2007). Now, do a print preview to see if the file looks cleaner. If necessary, add page breaks where you need them.

[jasoncw]

Another thing to check in the Page Setup is to ensure that the Center Vertically box on the Margins tab is unchecked.

HTH

Jason

[Christeh]

GREAT!!! Thanks Jason, I tried your suggestion first (no hard feelings BigBas) and it worked!! Theres no way I could have know that!

Im so happy, thanks.

-Christina
Puerto Rico

[jasoncw]

Glad I could help, Christina.

Jason