Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change column headings (A,B,C) to text words?
How do I change column headings (A,B,C) to text words across the top of the
worksheet? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change column headings (A,B,C) to text words?
The A, B, C headers are internal to Excel, and are used to specify cell
locations. They can't be changed to text. However, if you need headers for a report or something, you can type them in and make them bold, underline them, etc. If the lettering system REALLY bothers you, you can turn it off (that is to say, remove it from view on screen- they'll still be there) by clicking Tools Options, selecting the View tab, and de-selecting the "Row and column headers" box. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change column headings (A,B,C) to text words?
And select A2 and do a WindowFreeze Panes so they are always visible, and
go to FilePagesetup?Sheet and Set the rows to repeat for printing. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Dave O" wrote in message ups.com... The A, B, C headers are internal to Excel, and are used to specify cell locations. They can't be changed to text. However, if you need headers for a report or something, you can type them in and make them bold, underline them, etc. If the lettering system REALLY bothers you, you can turn it off (that is to say, remove it from view on screen- they'll still be there) by clicking Tools Options, selecting the View tab, and de-selecting the "Row and column headers" box. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How do i change column headings back to letters in excel? | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) |