Column Titles

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)




Penny said:
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
Click to expand...
columns are which as I go down the page.
 
Use the first row for your description. Select A2, Windows>Freeze panes

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Penny said:
How do I replace the letters at the top of the columns to text? I have
Click to expand...
quite a long list of items and I can't tell which columns are which as I go
down the page.
 
You cannot customize the column letters. Place your labels in row 1 (for
example). Then select cell A2 and do a Window, Freeze Panes.
 
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
Click to expand...
text? I have quite a long list of items and I can't tell
which columns are which as I go down the page.
 
Back
Top