O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ACTIVITY 5-2: Defining the Page Layout

Before You Begin

The my_sales_data_final.xlsx workbook file is open.

Scenario

Having previewed the sales data worksheet, you now have a better idea of the precise page layout you would like to define before printing the pages. You feel the printed sheets will work better in the landscape orientation, and you want to widen the page margins slightly. Additionally, you don't like the layout with all of the rows displayed on a single page, so you decide to change the scaling to fit all columns on a single page and make the column labels print on each page. You also decide to add headers and footers to the workbook to include the date of the sales meeting, a title for the workbook, and page numbers.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required