Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / January 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lyriqqz - 27 Jan 2008 15:49 GMT
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(:)

Signature

LWP

Nick Hodge - 27 Jan 2008 16:47 GMT
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.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

> 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(:)
FSt1 - 27 Jan 2008 17:06 GMT
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

> LWP
>
[quoted text clipped - 11 lines]
> > letters.
> > Thanks in advance for your help(:)
Gord Dibben - 27 Jan 2008 18:06 GMT
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

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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.