Excel Spreadsheet Axis

aosulliv

New Member
Joined
Aug 21, 2006
Messages
6
My excel spreadsheet is showing numbers down the side axis and also along the top.

This is making the formulaes in the cells look weird!!!

Any ides how to change the column labels to alpha??

Thanks
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Menu command Tools/Options/General/R1C1 reference style checkbox : untick it.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,920
Messages
5,545,029
Members
410,647
Latest member
bernardazar
Top