Question

How will you add one more worksheet to an Excel workbook​

Answer 1

Answer:

To select multiple contiguous sheets, hold down the Shift key, click on the tab of the first sheet you want to include, and then click on the tab of the last sheet. In this case, we want to select all five sheets in the workbook. So hold down the Shift key, select the tab of the first sheet, and then select the tab of the last sheet

Explanation:

By default, the current workbook is selected in the “To book” drop-down list, so don’t change that. In the “Before sheet” list, select the sheet before which you want to insert the copied worksheet. We’ll choose to insert the copy of the worksheet at the end of the current worksheets. Select the “Create a copy” check box and click “OK”.