COLUMN HEADING CHANGED FROM ALPHABET TO NUMERIC

G

Guest

Please help me out with this one.

The setup for Excel is suppose to be Numeric headings for rows (1,2,3....)
and Alphabet headings for columns (A,B,C...). But now, after I imported a
pivottable, my column headings have become numeric as well (1,2,3...).

I closed all files and restarted my Excel but the column headings are still
numeric. Can someone tell me how to revert it back to alphabet.

Thanks!
 
N

Niek Otten

Tools>Options>General, uncheck R1C1 Reference style

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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