View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1
 
Posts: n/a
Default why are my columns labelled with numbers?

hi,
on the tool bar go to Toolsoptionsgeneral tab
uncheck R1C1 reference style.

regards
FSt1

"ec17" wrote:

Instead of having columns labelled A, B, C etc, my columns are labelled 1,2,3
etc.

My rows are still labelled 1,2,3 but now I can't reference a cell like A1.

This hasn't happened before but seemed to occur when I exported an access
database for analysis in excel.