View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default wrong cell addresses

On Mon, 24 Mar 2008 14:50:01 -0700, Kim wrote:

Can you tell me why when I open an Excel spreadsheet in Excel 2007, the cell
addresses are incorrect? Instead of seeing cell A1 it shows R1C1 and all the
columns are incorrect. Is there some option that accidentally got switched?


Select Tools/Options and under one of the tabs, there will be an option for
R1C1 style -- DEselect that.
--ron