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 www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
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.