Home // Blog & Excel Tips // Change Excel columns back to letters

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

Change Excel columns back to letters

Comments Closed
Uncategorised

Occasionally you find that your spreadsheet has changed such that instead of having the columns as letters (A, B, C etc.) they now appear as numbers (1,2,3 etc.). You will also see that formula now use a R1C1 reference style. So how do you change the Excel columns back to letters (or in the same way, how to change the Excel columns to be numbers and use R1C1 formatting).

If this has happened to you accidentally i.e. you didn’t purposefully switch on R1C1 referencing , don’t worry as your spreadsheet is exactly the same, it is just a different way that Excel shows the rows and columns. You can easily switch it back and it will work fine.

The solution is in the options part of Excel. If you go to Excel Options (see below)

Change Excel columns back to letters

Then go to Formulas and switch off (or on) the R1Ci reference style.

Change Excel columns back to letters