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?
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.
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.
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.
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."
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.
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.
You must confirm your selection—press "Remove" in the pop-up box to do so.
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.
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.
Looking for affiliates, try betandyou affiliates.
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
