How to Format an Entire Excel Worksheet - dummies

How to Format an Entire Excel Worksheet

By Faithe Wempen

To save time, you can format an entire Excel worksheet (also known as spreadsheet) at once. The Page Layout tab contains various formatting controls that affect the entire worksheet. These controls affect the worksheet when it’s printed.


  • Margins: Here, you can set the page margins for printing your worksheet. Choose from among the presets or choose Custom Margins to set your own.

  • Orientation: Choose from Portrait (tall) or Landscape (wide) for printing your worksheet.

  • Size: Choose the paper size. The default is regular letter size (8.5” x 11”).

  • Print Area: Use this to set only a portion of the worksheet to print. This option is handy if you don’t want everything on the sheet to print. For example, you have two tables of data on the same sheet, but you want to print only one.

  • Background: Use this control to place a picture behind the cells of the sheet, such as a logo. (Using this option is uncommon because pictures tend to interfere with the readability of the data.)

  • Print Titles: Click this button to open the Page Setup dialog box with the Sheet tab displayed. From there, you can select certain rows and columns to repeat on every page of a multipage printout (such as a row containing column headings, for example).

  • Scale to Fit group: Options here enable you to force your printout to fit on a certain number of pages by automatically decreasing the size as needed. You can scale to a certain number of pages (with the Height and Width lists), or you can set an overall scale percentage.