Topics

Feb 6, 2011

Add multiple worksheets at the same time in Excel 2007

In Excel 2007, you add a worksheet by right clicking on a sheet tab and clicking Insert... (or) by clicking the Insert Worksheet button (or) by pressing Shift + F11. This action adds a single worksheet.
For adding multiple worksheets at the same time, you need to have more than one worksheet in your workbook.
For example, to add 2 worksheets, click on a sheet tab and press the Ctrl key from the keyboard. Keeping the Ctrl key in pressed state, click on the other sheet tab. Now, right-click on any selected sheet tab and click Insert...
It works like this, the number of sheet tabs that you select and click on Insert..., those many number of worksheets will be added.

0 comments:

Post a Comment