Spreadsheets- Advanced Calculations

Multi Sheet worksheets

In Excel all files are workbooks. Each workbook contains worksheets. The program defaults to having 3 sheets initially. You can remove all but one or add as many as you need.

It is beneficial to keep much of your data in one workbook for the following reasons:

• Organization
• Data sharing
• 3D formulas

Adding worksheets

Add a single worksheet

• Click Worksheet on the Insert menu.

Add multiple worksheets

Determine the number or worksheets you want to add.

1. Hold down SHIFT, and then select the same number of existing worksheet tabs that you want to add in the open workbook.
   
   Example: If you want to add three new worksheets, select three existing worksheet tabs.
   
   
2. Click Worksheet on the Insert menu.

Naming worksheets

1. On the Format menu point to Sheet
2. Click Rename.

   

3. Type the new name over the current name.

OR

1. Double click on the Sheet 1 tab
2. Type of the appropriate sheet name

   |    Next