Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How do you make titles for columns in worksheets?

I just want to make titles for columns in worksheets. I can't get
information on this no matter how I phrase the query.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,124
Default How do you make titles for columns in worksheets?

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.

--
Don Guillett
SalesAid Software

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



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How do you make titles for columns in worksheets?

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 ToolsOptionsView

Select A2 and WindowFreeze Panes to keep your titles in place as you scroll
down.


Gord Dibben MS Excel MVP

On Tue, 25 Jul 2006 11:12:02 -0700, Titling columns in worksheets <Titling
columns in 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.


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 903
Default How do you make titles for columns in worksheets?

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to permanently group worksheets bennyob Excel Discussion (Misc queries) 1 October 31st 05 02:43 PM
Deselecting Worksheets Sloth Excel Discussion (Misc queries) 1 October 26th 05 09:31 PM
Merge Worksheets Mark Jackson Excel Discussion (Misc queries) 1 June 9th 05 10:39 AM
Merge Worksheets Mark Jackson Excel Worksheet Functions 0 June 8th 05 10:42 PM
Spawning worksheets and a summary per worksheet username Excel Discussion (Misc queries) 0 May 23rd 05 09:57 PM


All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"