Is it Possible To Keep Column Names In View?

gaming_mouse

Board Regular
Joined
Apr 6, 2005
Messages
139
This must be a common problem. I have columns with personal information -- things like name, address, home phone, cell phone, email, etc, maybe 20 columns total. I also have many records, so that when I have scrolled down to enter or view a record the names of the columns are no longer visible. Thus I may see two phone numbers side by side, but be unable to tell which is the cell and which is the home phone. I need to scroll back up to refresh my memory.

Is there a way to either:

1. Fix the first row (which contains the column names) so that it is always visible even if you scroll down?

2. Rename the column letter A, B, C using the column names?

A similar problem arises with right scrolling and keeping the first column visible? In this case only solution (1) would work. Or is there another solution altogether?

Thanks for any advice,
gm
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
To keep the 1st column and first row always visible, click on cell B2 then click

Window | Freeze panes
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
1) Select the entire row directly below your header rows, Window, Freeze Panes.

2) Not possible, sorry.

For your third question (just not numbered) would change question #1 answer. If you want to freeze row 1 and column 1 then select B2 | Window | Freeze Panes.

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,084
Members
412,566
Latest member
TexasTony
Top