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 …

Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as …

You’ll often select a range of cells in a worksheet to do things like copy, cut, or print data in specific cells. In Excel for the web, you can select a range in several different ways. When …

How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.

You can choose which so you can choose the specific columns, rows, or cells to include. After you select your data, on the Insert tab, select Recommended Charts. Tip: Sometimes your data …

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

How to lock cells in Excel worksheets and workbooks to protect your data.

If you frequently print a specific section of your worksheet, you can set a print area for it. That way, when you print your worksheet, only that section will print. You can enlarge the print area …

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.