Setting Up a Workbook

Setting Up a Workbook

Chapter at a Glance

In this chapter, you will learn to:

Create a workbook.

Modify a workbook.

Modify a worksheet.

Customize the Excel 2007 program window.

When you start Microsoft® Office Excel® 2007, the program presents a blank workbook that contains three worksheets. You can add or delete worksheets, hide worksheets within the workbook without deleting them, and change the order of your worksheets within the workbook. You can also copy a worksheet to another workbook or move the worksheet without leaving a copy of the worksheet in the first workbook. If you and your colleagues work with a large number of documents, you can define property values to make your workbooks easier to find when you and your colleagues attempt to locate them by using the Microsoft Windows® search facility.

Another way to make Office Excel 2007 easier to use is by customizing the Excel 2007 program window to fit your work style. If you have several workbooks open at the same time, you can move between the workbook windows by using the new user interface. However, if you switch between workbooks frequently, you might find it easier to resize the workbooks so they don't take up the entire Excel 2007 window. In that case, you just need to click the title bar of the workbook you want to display.

The 2007 Microsoft Office system design team created the new user interface to reduce the number of places you have to look for commands; if you find that you use a command frequently, you can add it to the Quick Access Toolbar so it's never more than one click away.

In this chapter, you learn how to create and modify workbooks, create and modify worksheets, make your workbooks easier to find, and customize the Excel 2007 program window.

See Also

Remember, you can get a quick refresher on the topics in this chapter. See the Quick Reference entries on pages xxviilxiii.


Before you can use the practice files in this chapter, you need to install them from the book's companion CD to their default location. See "Using the Book's CD" on page xiii for more information.

 Python   SQL   Java   php   Perl 
 game development   web development   internet   *nix   graphics   hardware 
 telecommunications   C++ 
 Flash   Active Directory   Windows