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 named or unnamed …

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.

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 or row, …

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 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 columns, rows, or …

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

Suppose you want to protect an entire workbook, but also wants to be able to change a few cells after you enable that protection. Before you enabled password protection, you can unlock some cells in …

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 you don't …

To find cells that contain formulas, click Home, Find & Select, and Go To. Click Special, and then click Formulas. You can search part or all of a worksheet.