[Solved] Cannot print header on top of each page

Discuss the spreadsheet application
Post Reply
Heeter
Posts: 18
Joined: Tue Dec 04, 2007 8:50 am

[Solved] Cannot print header on top of each page

Post by Heeter »

Hi all,

I am trying to get this right.

I got about 5 rows across the top of a 12 page calc sheet that's frozen that I would to print on top of each page.

Now, when I try to highlight the rows, then select "Format->Print Ranges->Define" Then I try to print the whole spreadsheet, and only the 5 rows print. Nothing else prints. When I remove the print range, the whole spreadsheet prints, but the 5 rows only appear on the first page.

I had it working for about one print job a couple of days ago, but I started to edit the spreadsheet, and it quit working properly.

Thanks

Heeter
Last edited by Hagar Delest on Mon Jul 20, 2009 11:29 pm, edited 1 time in total.
Reason: tagged [Solved].
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Cannot print header on top of each page

Post by thomasjk »

Look at the thread from you where this was answered before. http://user.services.openoffice.org/en/ ... 332#p93332.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Heeter
Posts: 18
Joined: Tue Dec 04, 2007 8:50 am

Re: Cannot print header on top of each page

Post by Heeter »

Thanks Thomas,

I keep trying that but it keeps only printing the top 5 rows.

Maybe I am not fully understanding your description.


Heeter
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Cannot print header on top of each page

Post by thomasjk »

That's because you have to select the area you want to print without the five rows you want as headers first.
Do this:
1)Highlight only the rows you want to print excluding the five rows you want as headers.
2)Format--->Print Ranges-->Define
2)Format---->Print Ranges--->Edit and select the five rows you want to repeat on each page.
3)Read the Help on Print Ranges.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Heeter
Posts: 18
Joined: Tue Dec 04, 2007 8:50 am

Re: Cannot print header on top of each page

Post by Heeter »

Thanks Thomas,

I kept highlighting the the wrong parts,

Now it works.

The way you described is easier than the way the help file describes it.

Thanks again,


Heeter
Post Reply