View Single Post
  #9  
Old May 29th, 2010, 11:21 AM posted to microsoft.public.excel.setup
thanks for your reply.its very useful
external usenet poster
 
Posts: 1
Default Excel 2007 change column labels from numbers to letters



"Ron de Bruin" wrote:

Office ButtonExcel Options

On the Formulas tab check or uncheck R1C1 reference................


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Victoriah" wrote in message ...
I am working in Excel 2007. Currently the column labels are showing up as
numbers naming cells as R1C1 etc. I'd much rather use letters for the
column labels so the cells will be the usual A1, B2 etc. I've searched the
help menus and have been unable to find out how to do this.