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.
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.
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).
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.
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.