Forum Discussion
Unable to remove print area from Excel worksheet
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.
Clear Print Area removes print areas. If that doesn't work try to repair your office app.
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.
Riny_van_Eekelen I selected the entire worksheet then set the print area. Unfortunately, this did not clear the print area that I was trying unsuccessfully to reset.
