[Solved] Create a header that doesn't move

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

[Solved] Create a header that doesn't move

Post by Heeter »

Hi all,

New to OO. I am using OO3.1.0 on Ubuntu 9.04 64bit.

Anyways, I am creating a spreadsheet that I would like to have the header that stays across the top as I scroll down through the pages. As well, I would like it to be across the top of each page that I print.

How can I do this?

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: create a header that doesn't move

Post by thomasjk »

Use Window-->Freeze to lock the header row in position for scrolling. Use Format--->Print Range---->Define to set up your print range. Then use Format--->Print Range--->Edit to select the row to repeat.
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: create a header that doesn't move

Post by Heeter »

Awesome, thanks for your help.

It works now,

But it won't print the data below the frozen rows, It now just prints only the frozen rows.

Thanks

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

Re: create a header that doesn't move

Post by thomasjk »

You have to select the range you want to print first then use Format-->Print Range--->Define.
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: create a header that doesn't move

Post by Heeter »

Now works, Thanks a whole bunch..........


Heeter
Post Reply