How do I make one row stay constant even when I scroll down it will show on the page

Hi Paula

If I understand what you are trying to do, it is quite easy I assure you, and if it makes you feel any better, took me a long time to figure out.

Here is what I was trying to do. I was making a budget in Open Office Calc and I needed to make line one the line I put all the months of the year on, a new month to a new cell, all the way across row one. Like you, I wanted it to be a sort of "header" for the sheet, so that when my expenses, listed in down column 1, ran past the bottom of the displayed page, row one with the months would always be displayed as I scrolled down the page. It's frustrating, because as you have discovered, the whole thing, row one and all, wants to scroll up and out of sight.

Simple solution. It's called "Freezing". You can freeze columns or rows or both. For row one, simply highlight row __TWO__ by clicking on the row number itself. I refer here to the actual number to the left of the row that Identifies which row it is. Now go to the menu item called 'window' and in that menu check the box that says 'freeze'. There you have it. Any information you enter into the spreadsheet below 1 will scroll without row one ever moving. Instant header!

There is a whole section on freezing headers in the help part of calc, which is very good, but a bit user-unfriendly. Tip: FYI, anything above the selected row freezes. for instance, if you wanted to make rows one through five so they stayed in place when scrolling, you would simply click on the row number labeled "6" and go to 'window' then check 'freeze'. Done deal. Now 1-5 are nailed in place. Note that freezing rows and columns dosen't protect them from being changed. you can (whether you mean to or not) format or change the cells that have been frozen.

Hope it helps,

TeamTuxedo