You can quickly locate and select specific cells or ranges by entering their names or cell references in the Name box, which is located to the left of the formula bar:
You can also select named or unnamed cells or ranges by using the Go To (F5 or Ctrl+G) command.
Important: To select named cells and ranges, you need to define them first. See Define and use names in formulas for more information.
Select named or unnamed cells or ranges by using the Name box
-
To select a named cell or range, click the arrow next to the Name box to display the list of named cells or ranges, and then click the name that you want.
-
To select two or more named cell references or ranges, click the arrow next to the Name box, and then click the name of the first cell reference or range that you want to select. Then, hold down CTRL while you click the names of other cells or ranges in the Name box.
-
To select an unnamed cell reference or range, type the cell reference of the cell or range of cells that you want to select, and then press ENTER. For example, type B3 to select that cell, or type B1:B3 to select a range of cells.
Note: You can't delete or change names that have been defined for cells or ranges in the Name box. You can only delete or change names in the Name Manager (Formulas tab, Defined Names group). For more information, see Define and use names in formulas.
Select named or unnamed cells or ranges by using the Go To command
-
Press F5 or CTRL+G to launch the Go To dialog.
-
In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box, then press OK.
For example, in the Reference box, type B3 to select that cell, or type B1:B3 to select a range of cells. You can select multiple cells or ranges by entering them in the Reference box separated by commas. If you're referring to a spilled range created by a dynamic array formula, then you can add the spilled range operator. For example, if you have an array in cells A1:A4, you can select it by entering A1# in the Reference box, then press OK.
Tip: To quickly find and select all cells that contain specific types of data (such as formulas) or only cells that meet specific criteria (such as visible cells only or the last cell on the worksheet that contains data or formatting), click Special in the Go To popup window, and then click the option that you want.
Edit or delete a named range
-
Go to Formulas > Defined Names > Name Manager.
-
Select the name you want to edit or delete.
-
Choose Edit or Delete.
Select non-contiguous cells or ranges
Hold down the Ctrl key, and left-click each cell or range you want to include. If you over select, you can click on the unintended cell to de-select it.
Selecting data for the Bing Maps add-in
When you select data for Bing Maps, make sure it is location data - city names, country names, etc. Otherwise, Bing has nothing to map.
To select the cells, you can type a reference in the Select Data dialog box, or click the collapse arrow in the dialog box and select the cells by clicking them. See the preceding sections for more options for selecting the cells you want.
Selecting data for the Euro Conversion add-in
When you select data for Euro Conversion, make sure it is currency data.
To select the cells, you can type a reference in the Source Data box, or click the collapse arrow beside the box and then select the cells by clicking them. See the preceding sections for more options for selecting the cells you want.
You can select adjacent cells in Excel for the web by clicking a cell and dragging to extend the range. However, you can't select specific cells or a range if they're not next to each other. If you have the Excel desktop application, you can open your workbook in Excel and select non-adjacent cells by clicking them while holding down the Ctrl key. For more information, see Select specific cells or ranges in Excel.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in the Answers community.
No comments:
Post a Comment