How do I get my row 1 (which contains the title of each column) to show up on my spread sheet as I enter data? By the time I get to row number 25, I can't see my column #1 titles. I've resorted to writing down the column titles on paper and referring to it when I can't see row 1 anymore. There must be a better way! Haaalp! Blessings!
how to get the header row on all scrolling screens
Started by
khara
, Mar 05 2005 04:10 PM
#1
Posted 05 March 2005 - 04:10 PM
khara
-
- Member
-
- 1 posts
New Member
How do I get my row 1 (which contains the title of each column) to show up on my spread sheet as I enter data? By the time I get to row number 25, I can't see my column #1 titles. I've resorted to writing down the column titles on paper and referring to it when I can't see row 1 anymore. There must be a better way! Haaalp! Blessings!
#2
Posted 05 March 2005 - 04:56 PM
headhunter600
-
- Member
-
- 15 posts
Member
Position your cursor on the line below what you want to keep. If you want the entire row, put the cursor in column A. If you want some columns to also be frozen, position the cursor one column to the right. Click Windows (Alt+W). Then click Freeze Panes (F). To undo the freeze, do Alt+W, F again. The position of the cursor doesn't matter when unfreezing.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:
Sign In
Create Account
