How can I convert the column headings in the worksheet from letters (A, B, C...) to numbers (1, 2, 3...) in Surfer?

There is not a way to convert the alphabetic column headings in the worksheet to numeric headings in Surfer. To add your vote to this request on our suggestion file, please email


As a workaround, you can insert a row of numbers at the top of the worksheet. To do this:

  1. Open the worksheet in Surfer.
  2. Highlight row 1 and click Data | Edit | Insert to insert a blank row at the top of the worksheet.
  3. Click Data | Data | Transform.
  4. Select Row variables from the Transform with dropdown list.
  5. Enter the Transform equation: _1=row()
  6. Enter your first column into the First col box and your last column into the Last col box:
  7. Click OK and row 1 is populated with the consecutive numbers:


Updated November 12, 2018

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.