SOLVED

How to remove large text across worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2721583%22%20slang%3D%22en-US%22%3EHow%20to%20remove%20large%20text%20across%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2721583%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20can%20someone%20help%20me%20remove%20that%20large%20text%20across%20my%20worksheet%20%22_FilterDatabase%22%3C%2FP%3E%3CP%3EI%20have%20spent%20hours%20trying.%20I%20have%20tried%20copying%20the%20contents%20to%20a%20new%20sheet%20but%20I%20loose%20the%20formatting%20of%20the%20pictures.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2721583%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-2723257%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20large%20text%20across%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2723257%22%20slang%3D%22en-US%22%3Eclick%20View%26gt%3B%20Normal%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2724012%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20large%20text%20across%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724012%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20replying%2C%20I%20have%20just%20checked%20under%20view.%20The%20normal%20button%20is%20selected%20but%20it%20is%20still%20there%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047584%22%20target%3D%22_blank%22%3E%40Yea_So%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2725908%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20large%20text%20across%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2725908%22%20slang%3D%22en-US%22%3Ecan%20you%20share%20the%20workbook%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2726196%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20large%20text%20across%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726196%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F701373%22%20target%3D%22_blank%22%3E%40roboreeves%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELook%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fusing-named-ranges%2Fm-p%2F2441745%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fusing-named-ranges%2Fm-p%2F2441745%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Please can someone help me remove that large text across my worksheet "_FilterDatabase"

I have spent hours trying. I have tried copying the contents to a new sheet but I loose the formatting of the pictures. Thanks

8 Replies
click View> Normal

Thank you for replying, I have just checked under view. The normal button is selected but it is still there @Yea_So 

can you share the workbook?
best response confirmed by allyreckerman (Microsoft)
There's your answer
Thank you both soooo much for helping me!!
The problem is, it is a large sheet so at times you do want to zoom right out. Seems odd it is so hard to get rid of it.
Not to worry I will just zoom in!
Thanks again, so humbled how helpful people are

@roboreeves 

 

As a variant although I have not tried it, you can copy a zoomed out version the entire worksheet with content and paste it in a different tab as a linked image that way when you zoom it out since you already have a zoomed image, you won't have that nuisance.

 

cheers

I think I tried every paste option, one of them it looked perfect except my jpg's became all distorted. I should have started with a fresh workbook rather than build on the original from third party that has unecessary database filter. I have tried to turn off but they are greyed out. I have to issue it shortly so it will just have to stay as it is. Thanks again