Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Column "titles"

Posted by Bubba L on June 24, 2001 9:09 PM
This may seem like a really stupid question, but how do you change the "A","B","C", etc. at the top of each column to your own text? Thanks

Re: Column "titles"

Posted by lurker on June 24, 2001 11:02 PM

don't think you can. however, a workaround is to get rid of your row and column headers(Tools/Options/View and uncheck the 'Row & Column headers' in the 'Window Options') then put your own column names in A1, B1, etc. If you want them to print on each page then go to File/Page setup/Sheet tab and in 'Rows to repeat at top' put your column refs (A1, B1, or the whole row)

This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.