In Excel, how does one open two worksheets at a time?

1. Create a blank Excel workbook. You can see multiple tables below. If you only need two tables, however, this tutorial makes little sense.

2. Select "tool"> "option ". See the following figure.

3. The "options" dialog box appears, and click the "general and save" tab. See the following figure.

4. Enter "2" in "number of worksheets in the new workbook", and click "OK ". See the following figure.

5. Now, we can create a new workbook and try it. Click "file"> "new" or press the shortcut key "Ctrl + N ". See the following figure.

6. When creating a workbook, there are only two worksheets. See the following figure.

Well, the above is the setting method for opening two excel tables at the same time compiled by Xiaobian for you. It is actually very simple. I believe that it is okay to open 10 sheets.