Thread: Excel is showing numbers as headers for both rows and columns??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Excel is showing numbers as headers for both rows and columns??
Tools|Options|General Tab
Uncheck the R1C1 reference style button.

Excel will pick this setting from the first workbook that it opens in that
session.

rrgyoung wrote:

How do I change the column headers back to letters? Formulas will still work
if I use r1c1 format, but why did it change from letter headers on columns?

--

Dave Peterson
Reply With QuoteReply With Quote