Inserting a new sheet into an  Excel workbook

This simple task often stumps new Excel users.

 

Suppose we had created a spreadsheet dealing with income and expenditure for the first quarter of the new financial year (Figure below). 

 

 

If we had put in some effort inserting formulae and labels in the spreadsheet, we would want to capitalize on this for the results of the following quarter.

 

The first inclination is to select File>New. This is wrong, because it creates a new workbook.

 

Click on the Insert drop down menu and click insert and select Worksheet. A new sheet will appear in your current workbook. It will be labelled 'Sheet 1'. Rename the sheet (in our example) September- November 2001. 

 

 

Contact: Email info@designcad.com.au

Tel +61 8 8354 2400  Fax +61 8 +61 8 303 4363 Mob 0418 414 932

Design Cad Pty Ltd (ABN 38 007 890 146)

Lasted Updated: 08-Mar-04.