Free Tutorial Central Home | Getting Started with Excel 2010 |

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

In this lesson, 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 youprepare 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 Backstage view to set page setup options, and then preview and 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 and and print a worksheet in Backstage view

Key Terms

Header & Footer Tools Design tab

manual page break

Normal view

Page Break Preview

Page Layout view

Quick Print

automatic page break

contextual tabs

footer

Footer Area

Full Screen View

header

Header Area