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 / New Users / July 2006

Tip: Looking for answers? Try searching our database.

How do you make titles for columns in worksheets?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Titling columns in worksheets - 25 Jul 2006 19:12 GMT
I just want to make titles for columns in worksheets.  I can't get
information on this no matter how I phrase the query.
Don Guillett - 25 Jul 2006 19:22 GMT
You can NOT change the column indicator to text of your choice. You can put
a label in the first row and hide the column/row indicators.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I just want to make titles for columns in worksheets.  I can't get
> information on this no matter how I phrase the query.
Gord Dibben - 25 Jul 2006 20:17 GMT
The column letters A,B,C etc. cannot be changed.

You can enter titles in row 1 for each column then turn off the Row and Column
headings at Tools>Options>View

Select A2 and Window>Freeze Panes to keep your titles in place as you scroll
down.

Gord Dibben  MS Excel MVP

>I just want to make titles for columns in worksheets.  I can't get
>information on this no matter how I phrase the query.
David McRitchie - 25 Jul 2006 20:36 GMT
There really are two parts to this question,   You have how to
display the top rows and/or left most columns,  but there is also printing
which is controlled from   File, Page Setup,  Sheet,
    Rows to repeat at top:   $1:$1
   Columns to repeat at left: $A:$A

more information in
   http://www.mvps.org/dmcritchie/excel/freeze.htm

There is a bit more leeway in what you can do in printing.

I don't know what you really tried in your query of Google.
There are two types of Google Searches that are relevant.
Google  web search
and Google newsgroups search of Excel newsgroups
    http://www.mvps.org/dmcritchie/excel/xlnews.htm

Search arguments similar to the following would probably have
yield useable results -- pretty much trying to use words you used.

   Excel column title* worksheet

I think Google will normally equate the single form and the plural forms
of words, but   title*   would pick up   anything beginning with "title" or
the complete word "title".

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

"Titling columns in worksheets" wrote..
> I just want to make titles for columns in worksheets.  I can't get
> information on this no matter how I phrase the query.

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.