Free Tutorial Central Home | Getting Started with Excel 2007 |

Getting Started with Microsoft® Excel® 2007 Lesson 3: Showing and Hiding Worksheet Elements and Previewing and Printing a Worksheet

In Lesson 3, you first learn how to show and hide worksheet elements and then you learn how to undo and redo an action.

Next, you learn to switch from Normal View to Page Layout View. You review Page Layout View and change a cell value to perform a What-if analysis on the worksheet’s data. Then you prepare to print the worksheet by adding a header and a footer to it, switch to Page Break Preview, and insert and modify a manual page break. Finally, you switch to Print Preview, set page setup options, and then print the worksheet.

Click the "Download" button to download this free lesson in PDF format.

Objectives

  1. Show and hide worksheet elements
  2. Undo and redo an action
  3. Work in Normal View, Page Layout View and Page Break Preview
  4. Set page setup options in Print Preview
  5. Print a worksheet

Key Terms

live preview

manual page break

Normal View

Page Break Preview

Page Layout View

Print Preview

Quick Print

View Toolbar

automatic page break

contextual tabs

Dialog Box Launcher

footer

Footer Area

Full Screen View

header

Header Area

Header & Footer Tools Design tab