why is excel spreadsheet inserting extra blank sheets when i go to print, there is no data outside the selected print area

Question

why is excel spreadsheet inserting extra blank sheets when i go to print, there is no data outside the selected print area

Answer 1

Hi @Aoibhe,

Based on your information, if Excel inserts extra blank sheets when printing, it usually comes from either of these situations:

• There is actually an extra page even it looks blank
• You're printing some extra blank worksheets if multiple sheets are selected or the print setting is "Entire workbook"

Therefore, I suggest you first double check these things:

• In File > Print, verify the setting is "Print Active Sheets" not “Entire workbook”, and that you didn’t accidentally select multiple tabs
• On the Page Layout tab, select Print Area > Clear Print Area to fresh clean your data range. Then re-select the exact range you want and choose Print Area > Set Print Area to force restricting the print data then go to Print and check whether blank page exists

In the meantime, you can also check this article to see if your situation falls into any of the situation listed: Blank pages are unexpectedly printed - Microsoft 365 Apps | Microsoft Learn

Please understand that my initial response does not always resolve the issue immediately. However, you can try these steps and let me know if it works for you. If not, don't hesitate to reach out again and we can work together to find a solution.

If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.    

Thank you for your understanding and cooperation. I'm looking forward to your reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread