ALL ABOUT OFFICE

EXCEL

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT

Adding and Deleting Extra Worksheets

To add another worksheet, click anywhere on the sheet that comes after the position where you want to insert a sheet and click on the Insert drop-down menu.  Choose Worksheet from the menu and a new worksheet will be added before the one you are in at the moment.  You can now give this worksheet a name as described above.

You can insert several worksheets at once by selecting that number of sheets to the right of where you want them placed.  To do this, click on one sheet tab then hold down the SHIFT key and click the last sheet tab of the group you want to select.  Now click on the Insert drop-down menu and choose Worksheet and the new sheets will be inserted.

When you have added extra worksheets you can change their order if you wish.  To delete a worksheet you no longer require, click your right mouse button on the sheet tab at the bottom of the worksheet and choose Delete from the menu that appears.

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk