How many worksheets are required in an excel workbook

Download the example to work along with the video. When you open an Excel workbook, there are three sheets by default , and the default name on the tabs are Sheet1, Sheet2, and Sheet3. These are not very informative names. Excel allows you to create a meaningful name for each worksheet in a workbook so you can quickly locate information.

You can change the default number of sheets that appears by clicking the Microsoft Office button and choosing Excel Options. These three worksheets are named Sheet1 , Sheet2 , and Sheet3.

In all spreadsheet programs, including Microsoft Excel , rows are labeled using numbers e. To identify a cell, give both the column and the row.

Select that item and click Add. Click OK. The Share Workbook button is now at the top of the Excel window. Note: A workbook that contains one or more Excel tables cannot have the Allow changes by more than one user This setting is enabled when using Shared Workbooks. Feature Maximum limit Users who can open and share the file at the same time Personal views in the workbook Limited by available memory Days that change history is maintained 32, default is 30 days Workbooks that can be merged at one time Limited by available memory Cells that can be highlighted in the workbook 32, Colors used to identify changes made by different users when change highlighting is turned on 32 each user is identified by a separate color; changes made by the current user are highlighted with navy blue Excel tables in the workbook 0 zero Note: A workbook that contains one or more Excel tables cannot have the Allow changes by more than one user Feature Maximum limit Users who can open and share the workbook at the same time Personal views in the workbook Limited by available memory Days that change history is maintained 32, default is 30 days Workbooks that can be merged at one time Limited by available memory Cells that can be highlighted 32, Colors used to identify changes made by different users when change highlighting is turned on 32 each user is identified by a separate color; changes made by the current user are highlighted with navy blue Excel tables in the workbook 0 zero Note: A workbook that contains one or more Excel tables cannot have the Allow changes by more than one user Need more help?

Expand your skills. Get new features first. Was this information helpful? If you want to view a different worksheet, you can simply click the tab to switch to that worksheet.

However, with larger workbooks this can sometimes become tedious, as it may require scrolling through all of the tabs to find the one you want.

Instead, you can simply right-click the scroll arrows in the lower-left corner, as shown below. A dialog box will appear with a list of all of the sheets in your workbook.

You can then double-click the sheet you want to jump to. You can work with each worksheet individually , or you can work with multiple worksheets at the same time.