How to create a new worksheet in excel

How to create a new worksheet in excel: First open the Excel software, there are three Sheet tables in the lower left corner of the table; then move the mouse to the area with the "little sun" or " " sign on the right side of Sheet3 , click this area to create a new worksheet.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

Method 1: Create new Sheets (worksheets) one by one

1. Open the Excel software, we will see three in the lower left corner of the table Sheet table. Move the mouse to the area with the "little sun" on the right side of Sheet3, and the words "Insert Worksheet" will appear. As shown in the picture:

2. Click on the area with the "little sun" to create a new Sheet. Table. Each click can add a Sheet table. As shown in the figure:

Method 2: Create multiple new Sheet tables (worksheets) at the same time

1. Open the Excel software, hold down the "Ctrl" key on the keyboard, and click the three Sheets in the lower left corner of the table one by one to select all three Sheets. As shown in the picture:

2. After all three Sheet tables are selected, right-click the mouse and click the "Insert" option in the expansion box, and a pop-up will appear. dialog box. As shown in the picture:

3. Select "Worksheet" in the pop-up dialog box, and then click "Confirm" "Button. In this way, three new Sheets are created in Excel at the same time. As shown in the picture:

Related learning recommendations: excel tutorial

The above is the detailed content of How to create a new worksheet in excel. For more information, please follow other related articles on the PHP Chinese website!