Getting Started with Microsoft® Excel® 2003 Lesson 3: Setting Excel Preferences, Previewing, and Printing a Worksheet

In this lesson, you will learn how to set various preferences that control how you work in a workbook. You will display and hide worksheet elements, perform a What-if analysis by changing the values in variables used in formulas, and learn to undo and redo an action. Next, you will preview a worksheet and set print options, such as margins, headers and footers, and page breaks. Then you will print the entire active area of the worksheet. Finally, you will learn how to print just a portion of a worksheet by setting a print area.

Objectives

1. Set Excel preferences
2. Undo and redo an action
3. Preview a worksheet
4. Set layout and print options
5. Print a worksheet
6. Print a worksheet area

Key Terms