Excel print no showing text or numbers in cells, formatting only. Preview is fine.

%3CLINGO-SUB%20id%3D%22lingo-sub-1100436%22%20slang%3D%22en-US%22%3EExcel%20print%20no%20showing%20text%20or%20numbers%20in%20cells%2C%20formatting%20only.%20Preview%20is%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1100436%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20worksheet%20was%20printing%20fine%20a%20couple%20of%20days%20ago.%26nbsp%3B%20Now%20I%20get%20ONLY%20the%20shaded%20cell%20colors%20and%20conditional%20formatting%20(outlined%20cells)%20-%20NO%20Content.%26nbsp%3B%20No%20text%2C%20no%20numbers.%26nbsp%3B%20It%20does%20print%20the%20right%20number%20of%20pages%20for%20the%20selection%20and%20the%20print%20preview%20is%20exactly%20what%20I%20want.%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20to%20me%20I%20hit%20this%20problem%20some%20years%20ago%20but%20can't%20find%20the%20solution%20this%20time.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1100436%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-1100486%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20print%20no%20showing%20text%20or%20numbers%20in%20cells%2C%20formatting%20only.%20Preview%20is%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1100486%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20check%20your%20Page%20Setup%20and%20Print%20Preview%20to%20ensure%20that%20everything%20is%20fine%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1100795%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20print%20no%20showing%20text%20or%20numbers%20in%20cells%2C%20formatting%20only.%20Preview%20is%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1100795%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20never%20mark%20my%20response%20as%20the%20Best%20Response!%20I%20didn't%20know%20how%20this%20happened..%20All%2C%20I%20did%20is%20to%20provide%20reply%20and%20the%20next%20thing%20I%20see%20is%20that%20I%20marked%20as%20Best%20Response.%20Would%20appreciate%20the%20moderator%20to%20kindly%20lift%20the%20Best%20Response.%3CBR%20%2F%3E%3CBR%20%2F%3EAbiola%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1100803%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20print%20no%20showing%20text%20or%20numbers%20in%20cells%2C%20formatting%20only.%20Preview%20is%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1100803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAbiola%2C%20with%20your%20MVP%20status%20you%20may%20remove%20it%20yourself%20through%20post%20menu%20at%20top%20right.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1101735%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20print%20no%20showing%20text%20or%20numbers%20in%20cells%2C%20formatting%20only.%20Preview%20is%20fine.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1101735%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20advice%3C%2FLINGO-BODY%3E
Occasional Visitor

My worksheet was printing fine a couple of days ago.  Now I get ONLY the shaded cell colors and conditional formatting (outlined cells) - NO Content.  No text, no numbers.  It does print the right number of pages for the selection and the print preview is exactly what I want. 

It seems to me I hit this problem some years ago but can't find the solution this time.  

Please help.

4 Replies
Hello,

You can check your Page Setup and Print Preview to ensure that everything is fine
Hello,

I never mark my response as the Best Response! I didn't know how this happened.. All, I did is to provide reply and the next thing I see is that I marked as Best Response. Would appreciate the moderator to kindly lift the Best Response.

Abiola

@Abiola1 

Abiola, with your MVP status you may remove it yourself through post menu at top right.