3 Tips for Printing Excel Sheets

Excel Bad Habit #13: Failing to Format Excel Sheets for Printing

Watch on YouTube & Subscribe to our Channel

Any time you send someone a worksheet, it's a good idea to send it printer-ready. Here are three quick tips for making sure your sheets don't print wonky!

1. Use a preview to see how the sheet will print.

You can use either the Page Break Preview or Page Layout. Both are found on the View tab.

Page Break Preview
Page Layout

Both of these view modes will allow you to see how the pages will print. You can also find these buttons in the bottom right corner of the application window.

2. Change Page Width to 1 Page.

If you want your report to print so that it is only one page wide, you can change this setting on the Page Layout tab.

Choose One Page on Page Layout Tab

3. Adjust the Break Lines Manually

If your page breaks land in weird places, you can manually move them in Page Break Preview mode. Just click and drag the dotted lines to where you want them to be for printing.

Click and drag break lines in Page Break Preview Mode.

Helpful? Let us know!

What printing tips do YOU have to share? Tell us in the comments.

  • Jon, I cannot thank you enough for all these tips! I appreciate the most elementary one to the more complex. You explain it all so clearly. Huge Thanks!!

  • Generic filters
    Exact matches only

    Excel Shortcuts List

    keyboard shortcuts list banner

    Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

    Excel Shortcuts List

    Join Our Weekly Newsletter

    The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

    Join Our Free Newsletter

    Test Your Excel Skills

    Free Excel Training Webinar Modern Power Tools

    >