Excel FormattingLesson 28Free preview

Excel Format Settings

This lesson is part of Excel · All levels

Summary

The format setting includes printed views: Portrait or Landscape orientation, paper size, margins, and printed area. Print Area makes only certain sections of the sheet printed, whereas Repeat Titles repeat the title of the row or column on each page. All these settings can be tried first by using the Print dialog with Ctrl+P.

Key points

Page layout sets the orientation, size of the paper, and margin
Print Area limits the printed part of the sheet
Repeat Titles repeat the title line/column on each page
Ctrl+P opens the preview of the Print dialog

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.