Static Rows

kaegogi · Newbie Joined: 01 Nov 2007 Posts: 4

Hello. I have searched the other threads for a while but could not find an answer to this. I am a home user of openoffice and I am creating a spreadsheet for a home budget. I would like to make the top row with my headers static when I scroll down so that I know what column I am entering info into. Can anyone please explain how to do this?

I hope I was clear enough. Thank you in advance for any help.

davel · Power User Joined: 18 Oct 2005 Posts: 62 Location: PA, USA

Freeze is the search term you need to use under Calc help.

Just select the row below the headings you want to freeze.

Then select Window; Freeze and your are done!

If you need to freeze both row and column headings then select the cell just below and to the right of the desired frozen headings and then do Window; freeze.

Does this hely?

kaegogi · Newbie Joined: 01 Nov 2007 Posts: 4

Yes it did! Easy as cake. Thank you very much.

Waidesworld · Posted: Fri Nov 02, 2007 8:06 am Post subject: Printing Row 1 as a header

How do I do this again?

huwg · Super User Joined: 14 Feb 2007 Posts: 890

Click once in the first cell that you wish to be able to move. i.e. the rows above it, and the columns to the left, are the ones you want to lock in place whilst scrolling. So if you just want the top row to stick then click on cell A2.

Then choose the menu option Window > Freeze

Waidesworld · Posted: Fri Nov 02, 2007 9:14 am Post subject:

Oh my subject title never posted. I want to print several pages keeping Row 1 as the header row.

keme · Posted: Fri Nov 02, 2007 10:19 am Post subject:

Waidesworld · Posted: Fri Nov 02, 2007 10:39 am Post subject:

Thanks, that worked a gem.