Temporarily disable print areas in Excel

With Excel it is often necessary to set print areas so that you only print a certain section. Occasionally you may want to print everything again but you don’t want to clear the print areas and then reset them once you have a full print. There is a nice easy way to temporarily disable print areas in Excel, just for one print. But first let’s look at removing the print areas in case that is what you are looking for.

Remove the print areas permanently

In case you want to remove print areas permanently you can just click on the Page Layout ribbon and choose ‘Print Area’ and ‘Clear Print Area’ as shown below.

Temporarily disable print areas in Excel

As mentioned this is a permanent change and if you want to now print only the print area again you will need to set it up.

Temporarily disable print areas in Excel

It is surprisingly easy to disable the print area on a once off basis. So below with the print area on this is what the print will look like and it is one page.

Temporarily disable print areas in Excel

Under the setting where you choose what you want to print, there is a less obvious ‘Ignore Print Area’ option which due to the lack of icon, is not as obvious (to us anyway).

Temporarily disable print areas in Excel

If you choose this option, only for this print, it will print the entire sheet and not just the print area. As shown below now there are 17 pages with all the  years data and not just 2 years worth.

Temporarily disable print areas in Excel

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.