COLUMN HEADING CHANGED FROM ALPHABET TO NUMERIC

R

Ray

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
 
Top