Have you ever gone to print a spreadsheet in Excel, only to have your pages broken up in weird spots, or certain rows or columns entirely excluded? In many cases this is due to an incorrectly-defined print area, or if you followed our how to print empty gridlines in Excel guide.
If your spreadsheet has a print area that is missing some of your data or splitting it up incorrectly, then you may need to either reset the print area, or remove it entirely. Either way you will need to remove the existing print area from the spreadsheet.
How to Remove a Print Area in Excel
The steps in this article were performed in Microsoft Excel for Office 365. By completing this tutorial you will be clearing an existing print area from the current worksheet. This means that the next time you go to print it, then entire spreadsheet will be printing.
If your document has gridlines on it and you don’t want them, then find out how to get rid of grid on Word so that you can view it as a traditional document instead.
Step 1: Open your file in Excel.
Step 2: Select the Page Layout tab at the top of the window.
Step 3: Click the Print Area button.
Step 4: Choose the Clear Print Area option.
Now that you know how to clear a print area in Excel for Office 365, you can make it much easier to print your entire spreadsheet if only part of it has been printing before.
Defining or removing the print area is just one of the many ways that you can customize your spreadsheet when you print. Find out how to horizontally center a printed spreadsheet so that it looks better on paper.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.