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

  • Thread starter Thread starter Lyriqqz
  • Start date Start date
L

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(:)
 
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
 
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
 
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
 
Back
Top