Thursday, June 9, 2011

In Excel 2007 how do you change column headers from numbers to letters

If you want to change the header letters in Excel to numbers or from numbers to letters do this:

  • Click the office button (Large round button top left)

  • Click on the Excel options

  • Go to Formulas
  • Check or uncheck the R1C1 reference style


No comments:

Post a Comment