Open Page Setup

The Page Setup dialog is a goldmine of options for setting up worksheets and charts for printing. Its options are organized into five categories:

  • Page options control page orientation and scaling.

  • Margins options control margin measurements and the centering of the sheet on the page.

  • Header/Footer options enable you to choose from predefined headers or footers or create your own.

  • Sheet options (which appear for worksheets only) enable you to specify what prints and how it prints.

  • Chart options (which appear for chart sheets only) enable you to specify how a chart will print.

This chapter explores some of these options. But first, let's open that dialog.

Choose Page Setup from the File menu.

Windows

Mac OS

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial