how to change column name in google sheets

Giving a proper name to your columns can be quite useful if you want to utilise these in the formulas.

Instead of using the column alphabet in the formula, you lot tin instead utilise a amend name that'southward more than descriptive.

For example, instead of using =SUM(C:C), you can use =SUM(sales)

And you don't even demand to retrieve what column has the sales data. Once you have renamed the column to annihilation descriptive, you tin can then apply this new given name in formulas.

In this tutorial, I volition show you how to rename columns in Google Sheets.

Rename Columns To Employ in Formulas

Suppose you have a dataset every bit shown beneath and you want to rename column C to Sales.

Beneath are the steps to do this:

Click the Data pick
Click on Named Range. This will open the 'Named ranges' pane on the correct
Click on the 'Add a range' option
Enter the proper name you desire to requite the cavalcade ("Sales" in this example)
Make certain the column range is correct. In case it isn't, you lot tin can change it here
Click on Washed

The above steps would assign the name Sales to Column C.

Now I can use the below formula and it will give me the sum of all the sales values in column C.

Annotation: When you rename a cavalcade, it won't change the column header that appears when yous scroll downward the worksheet. This is something that happens with Excel tables, simply this feature is not yet bachelor in Google Sheets yet.

Go on Column Headers Visible When Scrolling Downwardly

Some other reason you may want to rename a column in Google Sheets is to make sure that the column header remains visible when you gyre downwards the sheet.

Unfortunately, this can not exist done in Google Sheets, just there is a workaround.

You tin freeze the top row that has the header. This manner, the header volition always be visible when you coil downwardly.

Hither are the steps to do this:

Enter the column header in the acme-near cell of the column. In our instance, nosotros already have the headers
Click the View tab
Hover the cursor over the Freeze option
Click on the '1 Row' pick

The in a higher place steps would make certain that the cavalcade header always remains visible when you scroll downward.

As I said, this is not exactly renaming the cavalcade (as we accept to enter the column header manually in the top row), it still achieves the desired result.

So these are two methods you can use to rename columns in Google Sheets.

I promise you plant this tutorial useful!

Other Google Sheets tutorials y'all may also like: