How To Rename Column In Google Sheets?

It’s obligatory to say the vary of the cell if you wish to apply conditional formatting or formulation on a column in Google Sheets. You’ll be able to, nevertheless, cowl the entire column by renaming it. 

Renaming Columns doesn’t change the heading from A, B, or C to different phrases. However, they do change the worth that headings in columns have. Nonetheless, you possibly can combine rows and use them as headings as a substitute of alphabets as nicely. Right here, on this article, we have now compiled a number of strategies to rename columns in Google Sheets.

How to Rename Column in Google Sheets?

You’ll be able to undergo three separate paths to rename columns on Google Sheets. On the core, all three change the identify of your column by defining the identify of the column vary. So, comply with any of those strategies to rename the columns you need.

By way of Information Choice on Toolbar

You must entry the Named ranges add-on of Google Sheets to rename columns. One of many best methods to do it’s via the Information perform out there on the toolbar of Google Sheets. So, comply with the steps talked about under to rename a column on Google Sheets.

1. Open Google Sheets in your browser.
2. Click on on the Column identify of the column you wish to rename.
3. Click on on Information from the toolbar on the high.
4. Click on on Named vary.
5. Kind within the new identify for the column within the first textbox.
6. Click on on Performed.
   

By way of the Cell Actions Characteristic

For a single cell, you possibly can apply the Named Vary perform via Cell Actions to rename the cell. However, you possibly can change the person cell to a column to rename columns. So, comply with the strategies talked about under to take action.

1. Open Google Sheets in your browser.
2. Proper-click on a random cell within the column you wish to rename.
   
3. Click on on View more cell actions > Outline named vary.
4. Click on on Add a variety.
5. Kind within the identify for the column on the primary textbox.
6. Click on on the 2X2 sq. on the second textbox.
   
7. Choose the Column Identify of the column you wish to rename.
   
8. Click on on OK and Performed.
   

Use the Identify Field function on Sheets

On the high left nook of the web page, you possibly can view the column identify that has been modified with the Named Ranges function. Nonetheless, you possibly can instantly use the Identify field to rename columns as nicely. So, comply with the strategy talked about under to take action.

1. Open Google Sheets in your browser.
2. Click on on the column identify from the highest of the column you select.
   
3. Click on on the Identify field on the high left facet of the web page.
4. Take away the identify and vary current there.
5. Kind within the identify you wish to rename to.
6. Press Enter.

As soon as step two is full, you possibly can entry the Identify Field by urgent Ctrl + J. After that, proceed as instructed in step 4.

How to Rename and Freeze Column Headings?

Columns keep on the high no matter which row you’re on in your spreadsheet. Even after altering the identify for the column, the time period displayed on the high of the column stays as A, B, C, and so forth. 

Instead, it’s higher to rename cells within the first row to make use of them as headings. You’ll be able to freeze them afterward if you happen to scroll via lots of of rows and wish the headings on the high. So, comply with the strategy talked about under to rename and freeze column headings.

On Net Browser

1. Open the Google Sheets doc in your browser.
2. Double Click on on the cell with the column heading.
   
3. Clear the content material and rename it to what you like.
   
4. Click on on View from the toolbar.
5. Click on on Freeze > 1 row.
   

On Android

1. Open the popular doc on Google Sheets.
2. Select a cell with a heading and faucet on it.
   
3. Double faucet the identical cell to edit.
4. Clear the cell by tapping backspace and rename the heading.
   
5. Click on on the Tick mark on the suitable to substantiate the rename.
   
6. Once more, faucet on the tickmark on the high left nook.|
   
7. Faucet and maintain on the row quantity with the column heading.
8. Faucet on the three dots icon from the pop-up choices.
9. Faucet on Freeze.

On iOS

1. Open the Sheets app in your cellphone and open the goal doc.
2. Faucet on the cell with the heading.
   
3. Double faucet the identical cell.
4. Clear the cell by tapping backspace and rename the heading.
   
5. Click on on the Tick mark on the suitable to substantiate the rename.
   
6. Once more, faucet on the tickmark on the high left nook.
   
7. Faucet on the row variety of the row with headings.
8. Faucet on the small up and down arrow icon.
   
9. Faucet on the suitable arrow icon.
10. Choose Freeze row.