Mar 22 2020 04:31 PM
Mar 23 2020 09:31 AM - edited Mar 23 2020 09:35 AM
@idarow It's strange that you can not clear the current print area. But, I trust it is like that for you. Or you perhaps have multiple sheets selected? I have read that this can also cause issues with clearing print areas.
In stead of trying to clear a print area that is wrong, you can perhaps select the entire sheet and set that as the new print area. This should over-ride the previous print area.
Mar 23 2020 09:45 AM
Clear Print Area removes print areas. If that doesn't work try to repair your office app.
Mar 23 2020 10:21 AM
Oct 22 2021 11:47 AM
I found a solution to this and posting in case it helps anyone. In my case, my page setup was set to 100% of actual size. Once I changed this to "Fit to 1 page" it allowed me to set a custom print area. I'm guessing if it's set to 100% it won't allow it to shrink to the area you are trying to print on a page.
Would be nice for Microsoft to change this setting automatically whey you try to set a custom print area instead of just not working.
Nov 10 2021 12:52 PM
@njdesign27 this fix recently helped me, since I believe we were in the same situation: My Page Setup area in the Page Layout section of the Ribbon did not work. I found that Excel can't set or get page setup properties if a printer is not specified. To prevent this problem from occurring, install a printer driver on your computer.
Once I selected a printer, I was able to manipulate the page layout. Thanks!
Nov 28 2021 10:25 AM
@njdesign27 I had the same situation where I was unable to clear the print area. Also tried to set a new print area and then clear that one. When I did, it reverted to the one I wanted to clear.
Changing the Scaling to "fit to 1" got rid of my problem. Still not sure where the problem is but it isn't bothering me now.