Forum Discussion

idarow's avatar
idarow
Copper Contributor
Mar 22, 2020
Solved

Unable to remove print area from Excel worksheet

Have tried PAGE LAYOUT>PRINT AREA>CLEAR PRINT AREA to no avail Previous versions of Excel offered a REMOVE PRINT AREA tool but I couldn't find one in 365 Thank you
excel
office 365
  • njdesign27's avatar
    njdesign27
    Oct 22, 2021

    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's avatar
njdesign27
Copper Contributor
Oct 22, 2021

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.

 

Kmendes's avatar
Kmendes
Copper Contributor
Mar 04, 2024

njdesign27 This helped! Clearing my print area wasn't working. Thank you! 

Resources