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

Similar Threads

view of page 2
why have my column headings changed to numbers 1
Change the font size of excel row number and column heading 4
Font size for row and column headings 2
Subtotals 2
Column Heading 1
How do I format a column to be half the size of the one above it? 1
changing column letters to numbers , etc. 3

Top