[Solved] Cannot print header on top of each page

Discuss the spreadsheet application

[Solved] Cannot print header on top of each page

Postby Heeter » Tue Jul 14, 2009 4:36 pm

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].
Heeter
 
Posts: 18
Joined: Tue Dec 04, 2007 8:50 am

Re: Cannot print header on top of each page

Postby thomasjk » Tue Jul 14, 2009 4:55 pm

Look at the thread from you where this was answered before. viewtopic.php?f=9&t=20570&p=93332#p93332.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4406
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Cannot print header on top of each page

Postby Heeter » Tue Jul 14, 2009 4:58 pm

Thanks Thomas,

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

Maybe I am not fully understanding your description.


Heeter
Heeter
 
Posts: 18
Joined: Tue Dec 04, 2007 8:50 am

Re: Cannot print header on top of each page

Postby thomasjk » Tue Jul 14, 2009 5:23 pm

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
thomasjk
Volunteer
 
Posts: 4406
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Cannot print header on top of each page

Postby Heeter » Tue Jul 14, 2009 6:30 pm

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
Heeter
 
Posts: 18
Joined: Tue Dec 04, 2007 8:50 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests