Right-click the tab of the worksheet that you want a new worksheet placed in front of, and select Insert from the shortcut menu.
The Insert dialog box opens. Double-click the type of worksheet you want to insert (select Worksheet). A new worksheet (the next sheet number in the sequence) appears.
To delete a worksheet, right-click the worksheet tab and select Delete from the shortcut menu. The worksheet is removed from the workbook.
INTRODUCTION
When the default three worksheets per workbook just aren't enough, you will need to insert additional worksheets. Other times, you'll discover you no longer need a worksheet included in a workbook and need to delete it. (Just be sure when you delete worksheets that you definitely no longer need the information.)
TIP
Inserting Worksheets
You can also open the Insert menu and select Worksheet to automatically insert a worksheet into your workbook in front of the currently selected worksheet. If you need to rearrange the worksheets, see the next task.
TIP
Workbook Buttons
If the worksheet tabs aren't visible with a large number of worksheets, you can use the workbook buttons to the left of the worksheet tabs. Click the following buttons: > (next right) or < (next left); |< (first worksheet) or >| (last worksheet).