Inserting a new Worksheet

a.   To insert a single worksheet

i. Click Worksheet on the Insert menu.

b. To insert multiple worksheets.

i. Determine the number or worksheets you want to insert.

ii. Hold down Shift Key, and then select the number of existing worksheet tabs that you want to insert in the open workbook.

Example: If you want to insert three new worksheets, select three existing worksheet tabs and then click Worksheet on the Insert menu.
Note: You can insert maximum 255 Worksheets in a Workbook.


Post a Comment