Chapter 5: Setting Up a Workbook

Chapter at a Glance

Create a workbook, page 134. Modify a workbook, page 138. Modify a worksheet, page 141. Customize the Excel 2007 program window, page 146.

In This Chapter, You Will Learn How 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 at the beginning of this book.

Important 

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” at the beginning of this book for more information.