Microsoft Office Tutorials and References
In Depth Information
Modifying workbooks
new Excel workbooks contain one worksheet; because Consolidated Messenger uses nine
regional distribution centers, you would need to create eight new worksheets. To create a
new worksheet, click the New Sheet button (which looks like a plus sign in a circle) at the
right edge of the tab bar.
1
When you create a worksheet, Excel assigns it a generic name such as Sheet2 , Sheet3 , or
Sheet4 . After you decide what type of data you want to store on a worksheet, you should
change the default worksheet name to something more descriptive. For example, you
could change the name of Sheet1 in the regional distribution center tracking workbook to
Northeast . When you want to change a worksheet’s name, double-click the worksheet’s tab
on the tab bar to highlight the worksheet name, enter the new name, and press Enter.
Another way to work with more than one worksheet is to copy a worksheet from another
workbook to the current workbook. One circumstance in which you might consider copying
worksheets to the current workbook is if you have a list of your current employees in
another workbook. You can copy worksheets from another workbook by right-clicking the tab
of the sheet you want to copy and, on the shortcut menu, clicking Move Or Copy to open
the Move Or Copy dialog box.
 
Search JabSto ::




Custom Search