Forum Discussion
Column titles
Greetings: 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? I would like revised column titles to be visible no matter what portion of worksheet I am using. Thanks. Mike
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.
- Thanks. One out of two works for me. Mike
