In this article we will show you how to rename a column in Google Sheets in just a few simple clicks. Just follow the steps below.
While we cannot physically change the column letter, we can either add a header to a data set or rename a column in Google Sheets to make it easier to be referenced and understood in formulas.
For the purpose of this demonstration an example sheet was created. Click here to access the link and follow along at home.
We can add a header to a column in a data set allowing an easier understanding of the data contained. The example below demonstrates how to achieve this.
Click an empty cell in the column you want to name, be sure to choose a cell at the top of your data. Once clicked the cell will highlight.
In our example we need to rename Column B using a header therefore we have highlighted the empty cell at the top of the data in Column B.
In the empty cell type in your desired column name.
As our example data contains a list of students, we will type the word Student to accurately represent the data.
Highlight the text in the cell by clicking and dragging across the text. You can bold the text by clicking the Bold symbol B from the top toolbar or by using the keyboard shortcut Ctrl (Cmd ⌘ on Mac) + B.
Click anywhere outside of the cell and the header now displays above your data.
As we can see in our example, the column shows Student clearly as a separate header.
We can assign a column a custom name that is useful and more easily referenceable when using formulas.
Right click on the column letter, from the menu that displays select View more column actions to show the side menu.
From the side menu select Define the named range. The Named ranges menu will now display on the right hand side of the display.
In the Named ranges section is an input box with the default text “NamedRange1”, select and delete this text. You can then input your desired column name.
In our example as we are renaming Column C to “Fees”, we enter the text “Fees” into the input box.
Click the “Done” button, the column will be renamed and the defined name can now be used in formulas.
As can be seen in our example, the new column name is recognized in the formula.
If you enjoyed this article, you might also like our article on how to autofit column width in Google Sheets or our article on how to delete columns in Google Sheets.
If you want to learn how to send automatic reminder emails, we also suggest checking out our detailed guide.
