Skip to content

How to Print Excel Workbooks and Worksheets

< 1 minute read

Excel Green

Excel spreadsheets frequently remain digital, and for good reason. Spreadsheet data is often vast and requires manipulation (sorting, filtering, formatting) that is better done on a PC or other device. But occasionally, you will need to print an entire or part of a workbook.

Before you print, look at your rows and columns in the worksheet you want to print and ensure that all data is visible on the screen. You may need to resize certain rows or columns, or set Wrap Text. If you can’t see data on your screen, it won’t be visible on the printed version.

When your data is prepared for printing, follow these steps:

  1. If you want to print a partial worksheet, go to the Page Layout tab and select the rows/columns you wish to print. While your selection is active, click Print Area and then Set Print Area.If you want to print the entire worksheet, move on to #2.
  2. Preview each worksheet (or partial worksheet) to ensure that it looks the way you want it when printed:
    1. Click File and select Print. A preview will show in the right panel; you may have to click the Show Print Preview button.
    2. Click the Show Margins button in the lower right corner to view margins.
    3. Preview multiple pages by clicking the arrows in the lower left corner of the preview window.
  3. If you need to make changes, click the arrow in the upper left corner to go back to your worksheet(s).
  4. If you’re ready to print, under Settings select Print Active Sheets, Print Entire Workbook, or Print Selection, depending on what you wish to print. Worksheets are considered active when selected.
  5. Click Print.

Sign up for our newsletter