Adding a new worksheet to your workbook

Today you will be learning how to add worksheet in your workbook. You can organize a lot of information via worksheets. Instead of placing everything on a single worksheet; you can use additional worksheets in a workbook to separate various workbook elements logically.

Example: Let say you have 10 sales person, and you want to track their activities daily.  You can create individual worksheet for each sales person. At the same have a consolidated worksheet with all information together.

The following are three ways to add a new worksheet to a workbook:
 
A. Press Shift+F11. This method inserts the new sheet before the active sheet.

B. Click the Insert Worksheet control, which is located to the right of the last sheet tab. This method inserts the new sheet after the last sheet in the workbook.

C. Right-click a sheet tab, choose Insert from the shortcut menu, and click the General tab of the Insert dialog box that appears. Then select the Worksheet icon and click OK. This method inserts the new sheet before the active sheet.
Step 1:
Step 2:

I know this is very easy for you guys who have gratuated in Microsoft Excel, but for amateurs this post will be helpful. HAPPY LEARNING :)

No comments:

Post a Comment