Or change column headers from letters to numbers. Old school spreadsheets used numbers for rows and column headers, excel calls this old method R1C1 reference style. Here is how to toggle between the two.
On the main menu
1. Click Tools
2. Click Options
3. Select the General Tab
4. Place or remove a check next to the “R1C1 Reference Style” option to suit your liking and hit OK.
August 4th, 2008 at 2:42 am
Great tip, couldn’t find it in excel help.