T
Titling 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.
information on this no matter how I phrase the query.
How do you make titles for columns in worksheets?
D
Don Guillett
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
(e-mail address removed)
"Titling columns in worksheets" <Titling columns in
(e-mail address removed)> wrote in message
news
[email protected]...
a label in the first row and hide the column/row indicators.
--
Don Guillett
SalesAid Software
(e-mail address removed)
"Titling columns in worksheets" <Titling columns in
(e-mail address removed)> wrote in message
news
[email protected]...
G
Gord Dibben
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
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
D
David McRitchie
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
..
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
..