excel problem-can not print vertical grid lines on worksheet (horizontal print OK)

%3CLINGO-SUB%20id%3D%22lingo-sub-3032662%22%20slang%3D%22en-US%22%3Eexcel%20problem-can%20not%20print%20vertical%20grid%20lines%20on%20worksheet%20(horizontal%20print%20OK)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3032662%22%20slang%3D%22en-US%22%3E%3CP%3Ecan%20not%20print%20grid%20lines%20on%20worksheet%20--but%20horizontal%20grid%20lines%20appear%20OK%3C%2FP%3E%3CP%3EWindows%2010%3C%2FP%3E%3CP%3Eversion%2021H1%3C%2FP%3E%3CP%3Einstalled%2031%2F10%2F20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3032662%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3039282%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20problem-can%20not%20print%20vertical%20grid%20lines%20on%20worksheet%20(horizontal%20print%20OK)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3039282%22%20slang%3D%22en-US%22%3Eapologies%20Jan%20for%20delays%20and%20showing%20my%20ignorance--my%20problem%20re%20not%20printing%20grid%20lines%20is%20back%3CBR%20%2F%3Ehowever%20have%20recently%20installed%20new%20printer%20but%20it%20seems%20I%20have%20run%20out%20of%20ink-have%20just%20signed%20up%20to%20HP%20instant%20ink%20supplies%20but%20informed%20will%20be%20around%2010%20days%20delivery%3CBR%20%2F%3EProbably%20better%20if%20I%20stop%20bothering%20you%20for%20the%20present%3CBR%20%2F%3Eregards%20Ron%20Smith%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3037278%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20problem-can%20not%20print%20vertical%20grid%20lines%20on%20worksheet%20(horizontal%20print%20OK)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3037278%22%20slang%3D%22en-US%22%3EIf%20you%20click%20%22Reply%22%20and%20immediately%20after%20that%20%22Open%20full%20text%20editor%22%2C%20you%20get%20a%20different%20editing%20experience%2C%20which%20allows%20file%20uploads.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3037186%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20problem-can%20not%20print%20vertical%20grid%20lines%20on%20worksheet%20(horizontal%20print%20OK)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3037186%22%20slang%3D%22en-US%22%3Eseems%20to%20be%20working%20now--I%20was%20creating%20a%20format%20for%20making%209X9%20square%20of%20cells.(to%20solve%20soduko%20puzzles)--to%20more%20easily%20identfy%20the%20numbers%20entered%20I%20split%20the%2081%20cells%20into%209X9%20squares%20by%20entering%202%20horizontal%20and%202%20vertical%20lines%20--since%20then%20all%20the%20grid%20lines%20are%20showing%3CBR%20%2F%3ESorry%20for%20the%20delay%20in%20replying_%20%2B%20I%20am%20not%20sure%20how%20to%20send%20my%20file%20to%20you%3CBR%20%2F%3ERon%20Smith%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3034652%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20problem-can%20not%20print%20vertical%20grid%20lines%20on%20worksheet%20(horizontal%20print%20OK)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3034652%22%20slang%3D%22en-US%22%3ECan%20you%20attach%20your%20file%20here%3F%20Make%20sure%20you%20delete%20all%20other%20worksheets%20and%20replace%20all%20contents%20with%20nonsense.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3033994%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20problem-can%20not%20print%20vertical%20grid%20lines%20on%20worksheet%20(horizontal%20print%20OK)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3033994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ejust%20tried%20what%20you%20suggested%20ie%20print%20to%20MS%20PDF%3C%2FP%3E%3CP%3Eresult%20still%20the%20same%20--prints%20every%20thing%20OK%20except%20only%20shows%20horizontal%20but%20not%20vertical%20grid%20lines%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3032667%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20problem-can%20not%20print%20vertical%20grid%20lines%20on%20worksheet%20(horizontal%20print%20OK)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3032667%22%20slang%3D%22en-US%22%3EI%20assume%20the%20vertical%20gridlines%20are%20visible%20on%20the%20sheet%3F%20What%20happens%20if%20you%20try%20a%20different%20printer%2C%20like%20Microsoft%20Print%20to%20PDF%3F%20Do%20the%20lines%20appear%20in%20the%20pdf%3F%3C%2FLINGO-BODY%3E
New Contributor

can not print grid lines on worksheet --but horizontal grid lines appear OK

Windows 10

version 21H1

installed 31/10/20

6 Replies
I assume the vertical gridlines are visible on the sheet? What happens if you try a different printer, like Microsoft Print to PDF? Do the lines appear in the pdf?

@Jan Karel Pieterse 

just tried what you suggested ie print to MS PDF

result still the same --prints every thing OK except only shows horizontal but not vertical grid lines

Can you attach your file here? Make sure you delete all other worksheets and replace all contents with nonsense.
seems to be working now--I was creating a format for making 9X9 square of cells.(to solve soduko puzzles)--to more easily identfy the numbers entered I split the 81 cells into 9X9 squares by entering 2 horizontal and 2 vertical lines --since then all the grid lines are showing
Sorry for the delay in replying_ + I am not sure how to send my file to you
Ron Smith
If you click "Reply" and immediately after that "Open full text editor", you get a different editing experience, which allows file uploads.
apologies Jan for delays and showing my ignorance--my problem re not printing grid lines is back
however have recently installed new printer but it seems I have run out of ink-have just signed up to HP instant ink supplies but informed will be around 10 days delivery
Probably better if I stop bothering you for the present
regards Ron Smith