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