Enroll Course

100% Online Study
Web & Video Lectures
Earn Diploma Certificate
Access to Job Openings
Access to CV Builder



Online Certification Courses

How To Rename Columns Or Rows In Google Sheets

How to Rename Columns or Rows in Google Sheets. 

How to Rename Columns or Rows in Google Sheets

If you're sharing a Google Sheets spreadsheet, you can make it easier to refer to specific sections of data by renaming columns or rows using named ranges. This is how. 

 

What Are Named Ranges?

How to Rename Columns on Google Sheets on PC or Mac: 13 Steps

Named ranges enable you to give a group of cells a custom name, ranging from entire columns or rows to smaller groups of cells. While creating a named range does not replace the original cell references (A1, A2, etc. ), it does make it easier to refer to these cells (and the data they contain) when adding new formulas.

 

Using the Name Box

The name box is the quickest way to add a named range to Google Sheets. This is the box to the left of the formula bar that displays the cell reference for the cell or cells in your spreadsheet that are currently selected.

To begin, open a new column or row in your Google Sheets spreadsheet. Replace the existing cell reference in the name box with a new name while the row or column is selected, and then press the Enter key to save your selection.

To quickly rename a column or row, select the row or column, then replace the cell reference in the name box with your own name before pressing the Enter key to save.

Google Sheets will immediately rename your column or row. By pressing the downward-facing arrow button to the right of the name box, you can view a list of existing named ranges.

The list below will display a list of named ranges, along with their original cell references.

To view a list of named ranges, press the downwards arrow button next to the name box.

You can select cells by clicking on any of the named ranges, or by pressing "Manage Named Ranges" to make changes to existing named ranges.

 

Using the Named Ranges Menu

Another option is to use the named ranges menu to rename columns or rows. This menu enables you to manage both existing and new named ranges.

 

Adding a New Named Range in Google Sheets

To begin, open Google Sheets and click on the row or column to rename. Right-click the selected column or row and select "Define The Named Range" from the context menu.

To <a style='color: #0000ff; text-decoration: underline;' href='https://siit.co/main/applyreg.php'>apply</a> a new named range to a selected row or column, right-click the selected cells, then press the "Define The Named Range" option.

On the right, the "Named Ranges" menu will appear as a panel. In the box provided, type your chosen name. Additionally, you can change the column, row, or smaller cell range that is selected by changing the cell reference below it.

To save your selection, click "Done."

In the "Named Range" menu, add a new name for your range in the box provided and change the cell range it refers to (if required), then press "Done" to save your choice.

 

Editing or Removing Named Ranges

To edit or delete a named range, right-click any cell in the spreadsheet and then click the menu item "Define Named Range." A sidebar on the right side of the window will display a list of existing named ranges. Select the name in the "Named Ranges" panel by hovering over it and pressing the "Edit" button.

To edit a saved named range, hover over the name (or select it) in the "Named Ranges" menu, then press the "Edit" button.

The named range can then be modified (including the name and the cell range to which it refers) using the boxes provided. To delete a named range, click the "Delete" button.

To delete a named range, press the "Edit" button, then press the "Delete" button.

You must confirm your selection—press "Remove" in the pop-up box to do so.

To confirm the removal of a saved name range, press the "Remove" button in the pop-up menu.

 

Using a Named Range in Google Sheets

With the newly created named range, you can now refer to it in another formula. For instance, if you named your range "CellData," you could use the following formula to determine the median value of the values contained in those cells:

=MEDIAN(CellData)

The named range (CellData) takes the place of the column, row, or cell range reference in your formula. For instance, if CellData is a named range containing all of the cells in column A, you could refer to those cells using either A:A or CellData.

An example MEDIAN formula using a named range.

By creating a named range, you can quickly refer to the data you want to use without having to remember the original cell reference. This is yet another way to leverage the power of Google Sheets to simplify your workday.

 

Courses and Certification

Google Sheets Course and Certificate 

Google Drive Course and Certificate 

Google Docs Course and Certificate 

Google Slides Course and Certificate  

Google Forms Course and Certificate 

Google Adwords Course and Certificate 

Google Maps Course and Certificate 

Google Calendar Course and Certificate  

Google Analytics Course and Certificate 

Corporate Training for Business Growth and Schools