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.

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. To select a larger range, it’s easier to click the first cell and hold …

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 …

You can select cells and ranges in a table just like you would select them in a worksheet, but selecting table rows and columns is different from selecting worksheet rows and columns.