Tuesday, February 23, 2010

Insert additional worksheets in Excel 2010

By default, three worksheets named Sheet1, Sheet2, and Sheet3 are created when you create a workbook. To add worksheets to your workbook, perform the following:
1. Under Home tab, in the Cells section, click Insert.
2. Click Insert Sheet.
That’s it; a worksheet is now added to the workbook. If a large number of worksheets are added then a few of them might be hidden. To navigate to the worksheets, click the First, Previous, Next, or Last navigation buttons that appear to the left of the worksheet tabs.You can also insert a worksheet by pressing Shift + F11 keys from the keyboard or by clicking on the tab that appears to the right of the labelled worksheet tabs (For example, clicking on the tab that appears to the right of Sheet3).
/* */