Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Before you print a worksheet, it's a good idea to preview it to make sure that it looks the way you want. When you preview a worksheet in Microsoft Excel, it opens in the Microsoft Office Backstage view. In this view, you can change the page setup and layout before you print.

Preview the worksheet

  1. Click the worksheet or select the worksheets that you want to preview.

  2. Click File > Print > Print Preview.

    Keyboard shortcut    Press Ctrl+P.

Set printing options

Do one or more of the following:

  1. Click the worksheet or select the worksheets that you want to preview.

  2. Click File > Print.

  3. To change the printer, click the drop-down box under Printer, and select the printer that you want.

  4. To make page setup changes, including changing page orientation, paper size, and page margins, click Properties.

Print all or part of the worksheet

  1. To print the active sheet or sheets, or the whole workbook, in the Print dialog box, select from Selection, Active Sheet(s), Entire workbook, or Table.

  2. Click Print.

    Note:  If a worksheet has a defined print area, Excel prints only that area. If you don't want to print only the defined print area, click Ignore print area.

Next steps

For detailed instructions on how to print a worksheet, see Print a worksheet or workbook and Define or clear a print area on a worksheet.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!