In Excel basics are essential to better understand this spreadsheet program. Use this worksheet basics lesson for Excel help.
Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize your workbook and make it easier to find content. You can also group worksheets to quickly add information to multiple worksheets at the same time.
Optional: Download our practice workbook.
Whenever you create a new Excel workbook, it will contain one worksheet named Sheet1. You can rename a worksheet to better reflect its content. In our example, we will create a training log organized by month.
To change the default number of worksheets, navigate to Backstage view, click Options, then choose the desired number of worksheets to include in each new workbook.
If you want to prevent specific worksheets from being edited or deleted, you can protect them by right-clicking the desired worksheet and then selecting Protect sheet from the worksheet menu.