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.

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 …

To search the entire worksheet for specific cells, select any cell. To search for specific cells within a defined area, select the range, rows, or columns that you want.

You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.

To select a larger range, it’s easier to click the first cell and hold down the Shift key while you click the last cell in the range. You can scroll to make the last cell visible. To select an entire column …

Learn best ways to select a range of data to create a chart, and how that data needs to be arranged for specific charts.

If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when …

To create a chart, the first step is to select the data—across a set of cells. Sometimes, you may not want to display all of your data. You can choose which so you can choose the specific …

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

To include structured references in your formula, select the table cells you want to reference instead of typing their cell reference in the formula. Let's use the following example data to …