MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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

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)