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

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

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

LWP

You can't change them. You can however use Windowfreeze 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
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Lyriqqz" wrote in message
...
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

How do I change the names of individual columns for my workshe
 

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....
toolsoptionsview tabuncheck 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

"Nick Hodge" wrote:

LWP

You can't change them. You can however use Windowfreeze 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
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Lyriqqz" wrote in message
...
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

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

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

On Sun, 27 Jan 2008 07:49:01 -0800, Lyriqqz
wrote:

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