Teach Yourself VISUALLY Microsoft 365

CHAPTER 10

Worksheet Basics

Add a Worksheet

By default, when you create a new blank workbook in Excel, it contains one worksheet, which is often all you need. In some cases, however, your workbook might require additional worksheets. For example, if your workbook contains data about products your company sells, you might want to add worksheets related to the product data, such as calculations, data analysis, charts, or PivotTables.

When you add a new worksheet, Excel gives it a default name. To help you better keep track of your data, you can rename your new worksheet. For more information, see the next section, “Rename a Worksheet.”

Add a Worksheet

Click the New Sheet button ().

You can also right-click a worksheet tab, click Insert to open the Insert dialog box, click Worksheet, and then click OK.

Excel adds a new blank worksheet and gives it a default worksheet name.

Rename a ...