Name field and reuse in Excel

Content
  1. What is the “Name” field and what do I use it for in Excel?
  2. Name and define cell ranges
  3. Title images and images
  4. Select named ranges
  5. Select ranges with left
  6. Select multiple ranges
  7. Select intersecting ranges
  8. Select entire columns or rows
  9. Go to worksheet

What is the “Name” field and what do I use it for in Excel?

The Name field is located next to the formula bar above the worksheet area. Its normal purpose is to display a cell link to the active cell, but it is also used to name and identify ranges of cells or other objects that are selected, select one or more ranges of cells on a worksheet, and navigate to different cells on a worksheet. or workbook.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010; Excel for Office 365, Excel for Mac, and Excel Online.

Name and define cell ranges

When you use the same group of cells in formulas and charts, name the range of cells to identify the range.

To resize the name field, drag the ellipses (three vertical dots) between the name field and the formula bar.

To define a name for a range using the name field:

  1. For example, select a cell in the sheet B2

    To apply a range name to multiple cells, select a contiguous group of cells.

  2. For example, enter a name Tax rate

  3. Click Enter to apply the range name.

  4. Select a cell in the worksheet to display the range name in Name field

    If the range contains multiple cells, select the entire range to display the range name in the Name field.

  5. Drag a range of multiple cells to display the number of columns and rows name field † For example, select three rows by two columns to display 3R x 2C in the “Name” field.

  6. When you release the mouse button or the Shift key, the Name field displays a reference to the active cell, the first cell selected in the range.

Title images and images

When charts and other objects such as buttons or pictures are added to a worksheet, Excel automatically assigns a name. The first added graph is called Graph 1 and the first image is called Figure 1 If your worksheet contains multiple charts and pictures, give these pictures descriptive titles to make them easier to find.

To rename charts and images:

  1. Select a chart or image.

  2. Place the cursor in the field Name and enter a new name.

  3. Click Enter to end the process.

Select named ranges

The name field selects or highlights ranges of cells, by using specific names or entering cell references. Enter the name of a specific range in the Name field and Excel will select that range on the worksheet.

The name field has an associated drop-down list that contains all names defined for the current worksheet. Select a name from this list and Excel will select the appropriate range.

The Name field also selects the appropriate range before performing sorts or before using certain functions, such as VLOOKUP, which should use the selected range of data.

Select ranges with left

Select an individual cell by typing the cell reference in the Name field and pressing Enter, or select a contiguous range of cells using the Name field.

  1. Select the first cell in the range to make it active, for example B3

  2. in field Name enter a link to the last cell of the range, for example E6

  3. Click Shift+Enter to mark all cells in a range, for example B3:E6

Select multiple ranges

Select multiple ranges on the sheet by entering them in the Name field. For instance:

  • Enter D1: D15, F1: F15 in the Name box to highlight the first fifteen cells in columns D and F.

  • Enter A4: F4, A8: F8 to select the first six cells in rows 4 and 8.

  • Enter D1: D15, A4: F4 to select the first 15 cells in column D and the first six cells in the fourth row.

Select intersecting ranges

To select the part of two ranges that intersect, separate the identified ranges with a space instead of a comma. For example, enter D1: D15 A4: F12 in the Name box to highlight the cell range D4:D12 that is common to both ranges.

If names are defined for ranges, use named ranges instead of cell references.

For example, if the range D1:D15 is called test and the range F1:F15 becomes test2, type test, test in the Name field to highlight ranges D1:D15 and F1:F15.

Select entire columns or rows

Select adjacent columns or rows using the name field, for example:

  • Enter B:D to highlight each cell in columns B, C, and D.

  • Enter 2:4 to select each cell in rows 2, 3, and 4.

Go to worksheet

The Name field also provides a quick way to navigate to a cell or range on a worksheet. This approach saves time when working with large worksheets and eliminates the need to scroll through hundreds of rows or columns.

  1. Place the cursor in boxing names and enter cell reference like Z345

  2. Click Enter

  3. Active cell marker goes to cell reference, e.g. cell Z345

There is no standard key combination to place the cursor (flashing insertion point) in the name field. Here’s a faster way to get to a cell reference:

  1. Click F5 or ctrl+g to open the dialog To go

  2. In a text field Clutch enter a cell reference or a specific name.

  3. Select Okay or press the key Input to go to the correct location.

Leave a Reply

Your email address will not be published.