| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Labels
Columns in Excel are A,B,C, etc. Is there any way to change these letters to
words to describe the columns? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Labels
Not the way you might expect, but In a fashion, yes....
Put the labels you want to display in Row_1 Click on cell A2 WindowFreeze Panes ToolsOptionsView ---uncheck: Row & Column Headers Caveat: That will also hide the row numbers that appear on the left of the worksheet window. Does that help? *********** Regards, Ron "Sug" wrote: Columns in Excel are A,B,C, etc. Is there any way to change these letters to words to describe the columns? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Labels
So there is no way to change the column labels. That's what I needed to know.
I figured out a bunch of ways to cheat, but I wasn't sure if it was possible to change the actual letters (A,B,C, etc.) "Ron Coderre" wrote: Not the way you might expect, but In a fashion, yes.... Put the labels you want to display in Row_1 Click on cell A2 WindowFreeze Panes ToolsOptionsView ---uncheck: Row & Column Headers Caveat: That will also hide the row numbers that appear on the left of the worksheet window. Does that help? *********** Regards, Ron "Sug" wrote: Columns in Excel are A,B,C, etc. Is there any way to change these letters to words to describe the columns? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column labels | Excel Worksheet Functions | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Is it possible to use Autofilter, when column labels not in Row 1? | Excel Discussion (Misc queries) | |||
| Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel | |||
Linear Mode
