Follow

How can I convert the column headings in a Grapher worksheet from letters to numbers?

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

 

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

 

  1. Click the File | Open command.
  2. Select the worksheet and click Open.
  3. Highlight row 1 and click the Data Tools | Edit | Insert command. A blank row is added to the top of the worksheet.
  4. Click the Data Tools  | Data | Transform command.
  5. Click on the existing option next to Transform with and select Row variables (e.g., _3=_1 + _2).
  6. In the Transform equation, type: _1=row()
  7. Enter the letters for the First col and Last col:


The dialog should look similar to this before clicking OK.

  1. Click OK and row 1 is populated with the consecutive numbers:

This worksheet shows the column number in row 1.

 

Updated December 08, 2017

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

0 Comments

Please sign in to leave a comment.