Unable to remove print area from Excel worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1245506%22%20slang%3D%22en-US%22%3EUnable%20to%20remove%20print%20area%20from%20Excel%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245506%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20tried%20PAGE%20LAYOUT%26gt%3BPRINT%20AREA%26gt%3BCLEAR%20PRINT%20AREA%20to%20no%20avail%3C%2FP%3E%3CP%3EPrevious%20versions%20of%20Excel%20offered%20a%20REMOVE%20PRINT%20AREA%20tool%20but%20I%20couldn't%20find%20one%20in%20365%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1245506%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1245976%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20remove%20print%20area%20from%20Excel%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F590390%22%20target%3D%22_blank%22%3E%40idarow%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20254px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F178816i1F26798E43A5019E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1246928%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20remove%20print%20area%20from%20Excel%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1246928%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20noted%20in%20original%20post%2C%20this%20didn't%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1247135%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20remove%20print%20area%20from%20Excel%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F590390%22%20target%3D%22_blank%22%3E%40idarow%3C%2FA%3E%26nbsp%3BIt's%20strange%20that%20you%20can%20not%20clear%20the%20current%20print%20area.%20But%2C%20I%20trust%20it%20is%20like%20that%20for%20you.%20Or%20you%20perhaps%20have%20multiple%20sheets%20selected%3F%20I%20have%20read%20that%20this%20can%20also%20cause%20issues%20with%20clearing%20print%20areas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20stead%20of%20trying%20to%20clear%20a%20print%20area%20that%20is%20wrong%2C%20you%20can%20perhaps%20select%20the%20entire%20sheet%20and%20set%20that%20as%20the%20new%20print%20area.%20This%20should%20over-ride%20the%20previous%20print%20area.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-03-23%20at%2017.30.32.png%22%20style%3D%22width%3A%20171px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F178907i8E9769BE23B6D0EC%2Fimage-dimensions%2F171x111%3Fv%3D1.0%22%20width%3D%22171%22%20height%3D%22111%22%20title%3D%22Screenshot%202020-03-23%20at%2017.30.32.png%22%20alt%3D%22Screenshot%202020-03-23%20at%2017.30.32.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1247174%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20remove%20print%20area%20from%20Excel%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F590390%22%20target%3D%22_blank%22%3E%40idarow%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClear%20Print%20Area%20removes%20print%20areas.%20If%20that%20doesn't%20work%20try%20to%20repair%20your%20office%20app.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1247301%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20remove%20print%20area%20from%20Excel%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247301%22%20slang%3D%22en-US%22%3EI%20do%20not%20have%20multiple%20sheets%20selected.%3CBR%20%2F%3EI%20tried%20your%20advice%20and%20selected%20the%20entire%20sheet%20as%20the%20print%20area%2C%20but%20I%20still%20had%20the%20dotted%20lines%20where%20Excel%20broke%20the%20sheet%20into%20printable%20pages.%3CBR%20%2F%3EAgain%2C%20I%20was%20unable%20to%20clear%20this%20via%20the%20standard%20method.%3CBR%20%2F%3EWhat%20I%20finally%20did%20was%20COPY%20the%20entire%20sheet%26gt%3B%3CBR%20%2F%3EOpened%20a%20new%20sheet%26gt%3B%3CBR%20%2F%3ESelected%20the%20same%20range%20of%20cells%20as%20the%20original%26gt%3B%3CBR%20%2F%3EPASTE%20without%20formatting%20(WINDOWS%20KEY%20%2B%20V)%3CBR%20%2F%3EThis%20did%20the%20trick.%20I%20suspect%20something%20was%20just%20messed%20up%20(or%20as%20computer%20people%20say%2C%20%22corrupt%22)%20in%20that%20original%20sheet.%20In%20any%20case%2C%20I'm%20up%20and%20running.%3CBR%20%2F%3EThank%20you%20all%20for%20your%20responses.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

5 Replies
Highlighted
Highlighted

@Sergei Baklan 

 

As noted in original post, this didn't work.

Highlighted

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

Screenshot 2020-03-23 at 17.30.32.png

Highlighted

@idarow 

Clear Print Area removes print areas. If that doesn't work try to repair your office app.

Highlighted
I do not have multiple sheets selected.
I tried your advice and selected the entire sheet as the print area, but I still had the dotted lines where Excel broke the sheet into printable pages.
Again, I was unable to clear this via the standard method.
What I finally did was COPY the entire sheet>
Opened a new sheet>
Selected the same range of cells as the original>
PASTE without formatting (WINDOWS KEY + V)
This did the trick. I suspect something was just messed up (or as computer people say, "corrupt") in that original sheet. In any case, I'm up and running.
Thank you all for your responses.