Column Titles

[Guest]

How do I replace the letters at the top of the columns to text? I have quite a long list of items and I can't tell which columns are which as I go down the page.

 

[Ron de Bruin]

Hi Penny

You can't replace them

But you can use window-Freeze Panes in the menubar
To freeze the first column and Row select cell b2 and do windows -Freeze Panes

You can put your own headers in the first row and column now

Under Tools -options -View uncheck row & column headers so
the default row and column headers are gone


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

How do I replace the letters at the top of the columns to text? I have quite a long list of items and I can't tell which

columns are which as I go down the page.

 

[Niek Otten]

Use the first row for your description. Select A2, Windows>Freeze panes

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

How do I replace the letters at the top of the columns to text? I have

quite a long list of items and I can't tell which columns are which as I go
down the page.

 

[Jim Rech]

You cannot customize the column letters. Place your labels in row 1 (for
example). Then select cell A2 and do a Window, Freeze Panes.

 

[Guest]

I don't know how to do that but instead you could just
select your top row (or column heading) and go to Window,
Freeze Pane. That will keep your heading at the top...

-----Original Message-----
How do I replace the letters at the top of the columns to

text? I have quite a long list of items and I can't tell
which columns are which as I go down the page.