Delete a print area label on a worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1335627%22%20slang%3D%22en-US%22%3EDelete%20a%20print%20area%20label%20on%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335627%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20delete%20the%20print%20area%20labels%20on%20a%20worksheet.%20I%20find%20that%20the%20labels%20I%20used%20are%20not%20descriptive%20enough.%20Excel%20names%20the%20first%20print%20area%20as%26nbsp%3BPrint_Area.%20The%20next%20area%20would%20be%20labeled%26nbsp%3BPrint_Area_1.%20I%20would%20like%20to%20delete%20all%20of%20the%20labels%20or%20perhaps%20selected%20labels%20so%20I%20can%20enter%20a%20label%20name%20such%20as%26nbsp%3BPrint_Area_1_SUN.%3C%2FP%3E%3CP%3EWould%20appreciate%20your%20help%20with%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJoe%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1335627%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1385341%22%20slang%3D%22en-US%22%3ERe%3A%20Delete%20a%20print%20area%20label%20on%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1385341%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635812%22%20target%3D%22_blank%22%3E%40tucsondonpepe%3C%2FA%3E%26nbsp%3BI%20normal%20circumstances%20we%20can%20not%20delete%20bulk%20print%20area.%20It%20has%20to%20be%20done%20manually.%20You%20can%20also%20seems%20to%20be%20get%20any%20VBA%20Code%20to%20do%20so%20if%20you%20search%20or%20research%20on%20the%20internet.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

 

I would like to delete the print area labels on a worksheet. I find that the labels I used are not descriptive enough. Excel names the first print area as Print_Area. The next area would be labeled Print_Area_1. I would like to delete all of the labels or perhaps selected labels so I can enter a label name such as Print_Area_1_SUN.

Would appreciate your help with this.

 

Joe

1 Reply
Highlighted

@tucsondonpepe I normal circumstances we can not delete bulk print area. It has to be done manually. You can also seems to be get any VBA Code to do so if you search or research on the internet.