How do I change the names of individual columns for my worksheet?

[Lyriqqz]

Hello Everyone:

I am can't remember how to change the names of the columns in the excel
spreadsheet. I need them to have words in them instead of just the letters.
Thanks in advance for your help)

 

[Nick Hodge]

LWP

You can't change them. You can however use Window>freeze Panes, to show
columns to the right and rows above where the cursor is when you take the
command. (e.g, if in B2, then column and row 1 will always be in view). In
XL2007, if you have a table then as you scroll off the bottom of the sheet,
the headers 'jump' into these labels, but that is restricted to 2007, in
tables.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[FSt1]

hi
and just to add...
if you don't want to see the default xl headers and row number, you can to
to...
on the menu bar....
tools>options>view tab>uncheck column & row headers.
you can't show one and not the other, it a all or nothing thing. but you can
create a column of numbers in the A column(if needed) and freeze panes on B2
to show your headers and row number and not the default xl row number and
column letters.
just an after thought.

regards
FSt1

 

[Gord Dibben]

See your other posting.

Please do not multi-post...........a waste of time and effort for those who are
posting replies that duplicate what others have replied.


Gord Dibben MS Excel MVP