(Hover over the various table styles to see a live preview.)

Choose a style/color option that appeals to you.

Click the 'Design' tab > Locate the 'Table Styles' group.

Click on a cell in the table to activate the 'Table Tools' tab.

Resize your columns to make the headings visible.

Verify that the range is correct > Click.

If you have column headings, check the box 'My table has headers'.

Click the 'Insert' tab > Locate the 'Tables' group.

Use your mouse to select the cells that contain the information for the table.

Now when you return to your spreadsheet, the column headings should be letters (A, B, C, D) instead of numbers (1, 2, 3, 4).This page will show you how to convert Excel data into a table. Then uncheck the option called ' R1C1 reference style' and click on the OK button. When the Excel Options window appears, click on the Formulas option on the left. To change the column headings to letters, select the File tab in the toolbar at the top of the screen and then click on Options at the bottom of the menu. When the column headings are numeric values, R1C1 reference style is being displayed in the spreadsheet.

In the example below, the column headings are numbered 1, 2, 3, 4 instead of the traditional A, B, C, D values that you normally see in Excel.

If your spreadsheet shows the columns as numbers, you can change the headings back to letters with a few easy steps. How do I change the column headings back to letters such as A, B, C, D?Īnswer: Traditionally, column headings are represented by letters such as A, B, C, D. Question: In Microsoft Excel 2016, my Excel spreadsheet has numbers for both rows and columns.

Change row to column in excel