Column titles

mdsuble 

I have an Excel worksheet with 1,000 lines. Now the column titles are in line 1, so last line of actual data is 1,001. How to I push the column titles above line 1 so that data are on lines 1 through 1,000?

You can't do this: there is no row zero.

I would like revised column titles to be visible no matter what portion of worksheet I am using.

You can do this: In the "View" toolbar shown below just use the "Freeze Top Row" button off to the right in the image.