By default, Excel uses the A1 reference style, which refers to columns as letters, and refers to rows as numbers. These letters and numbers are called row and column headings. However, Excel can be configured to display column labels as numbers instead of letters.
Why Do My Excel Columns Have Numbers Video
Watch To See Why Do My Excel Columns Have Numbers
[Video tutorial: Why Do My Excel Columns Have Numbers
created by Activia Training; purchased by ZandaX]
Some people may prefer this method but it can also be confusing, especially if it is enabled inadvertently.
Change method back to normal
To change from this method back to normal go to File > Options and then Formulas and
un-tick the R1C1 reference style box.
If you'd like to learn more about Microsoft Excel, why not take a look at how we can help?
We have a whole range of online courses for all skill levels.
RRP from $39 – limited time offer just
$8.99
