Column Heading Error

G

Gunther

Typically the row heading on worksheets are numbers and the column heading
are letters. For what ever reason, my worksheet is displaying both the row
and column headings as numbers. It is very difficult to create formulas when
their are two sets of numbers.

How do I change the column heading to be letters?

Thanks!
 
J

Jacob Skaria

From menu Tools>Options>General> uncheck 'R1C1 reference style'

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top