Select specific cells or ranges - Microsoft Support
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.
Select a range of cells - Microsoft Support
In Excel for the web, you can select a range in several different ways. When selecting a small range that consists of just a few cells, click the first cell and drag to the last cell you want included in the range.
Create a named range from selected cells in a worksheet
You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column labels.
Create or change a cell reference - Microsoft Support
A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to:
Define and use names in formulas - Microsoft Support
By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.
Select cell contents in Excel - Microsoft Support
Learn how to select cells, ranges, entire columns or rows, or the contents of cells, and discover how you can quickly select all data in a worksheet or Excel table.
Convert an Excel table to a range of data - Microsoft Support
To convert a table into a range, right-click anywhere in a table, point to Table, and then click Convert to Range.
Video: Understand and use cell references - Microsoft Support
Instead of typing each individual cell in a formula, you can reference multiple adjacent cells, called a range of cells. This range of cells is referred to as F2:G5. The first cell is F2 and the last cell is G5.
Use Excel built-in functions to find data in a table or a range of cells
This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result. Create the Sample Worksheet
Ways to count cells in a range of data - Microsoft Support
Excel contains several functions to help you count the number of cells in a range that are blank or contain certain types of data. Select the cell where you want the result to appear.