ADVERTISEMENT
Playing The Long Game: Outdoor Photography With Telezooms

Office 365 - Excel Problems Printing Workbooks


MalcolmS Avatar
MalcolmS Plus
18 1.2k 13 England
17 Jan 2021 3:22PM
I have a problem withy printing workbook pages on my Canon Pixma TS8050. When I preview a workbook page it shows correct with all information visible. When I try and print it, the lines and the contents of ther cells do not print. The only cells that print are the headers and those that are blocked out in a colour as a horizontal divider.
If I save the page as a pdf and then open it, the page displays correctly, but when I try to print from the pdf, the same thing happens as above.
To save either the printer or laptop going out of the window, has anyone any ideas as it's driving me nuts.
Jestertheclown Avatar
Jestertheclown 14 8.8k 255 England
17 Jan 2021 4:00PM
Possibly not much help but I once had that happen with a pdf.
I converted it to jpeg.
That worked.
Might be worth a try?
rambler Avatar
rambler Plus
15 1.1k 17 England
17 Jan 2021 6:27PM
Alternatively go to Page Layout, Sheet options. Gridlines and tick Print.

Ken
MalcolmS Avatar
MalcolmS Plus
18 1.2k 13 England
17 Jan 2021 11:40PM
Thanks Ken but I have already done that.
silverscot Avatar
silverscot 10 572 Scotland
18 Jan 2021 9:00AM
When you select print go to settings and make sure "print active sheets " is selected. Also what appears in print preview?
George
MalcolmS Avatar
MalcolmS Plus
18 1.2k 13 England
19 Jan 2021 12:09PM
Selected, what appears is correct. It prints as original post above.
AlexE Avatar
AlexE 6 190 United Kingdom
19 Jan 2021 12:38PM
Have you tried turning off your computer and printer, making a cup of tea, and then turning it on again?

A wee pic could help if that doesn't solve it
answersonapostcard Avatar
19 Jan 2021 12:49PM
Have you set your print area? If you have try clearing it and starting again??
MalcolmS Avatar
MalcolmS Plus
18 1.2k 13 England
19 Jan 2021 4:35PM
Yes to all the above.
smacau1 Avatar
smacau1 11 550 United Kingdom
19 Jan 2021 5:50PM
Have you set the font colour / background colour to something not printable?
MalcolmS Avatar
MalcolmS Plus
18 1.2k 13 England
19 Jan 2021 6:19PM
Fonts and lines set at black, background is no colour.
answersonapostcard Avatar
19 Jan 2021 6:31PM
Malcolm have you got it set to print header rows?
MalcolmS Avatar
MalcolmS Plus
18 1.2k 13 England
20 Jan 2021 11:51AM
Just removing the egg from my face so that I can reply. It helps to replace the black cartridge when it runs out. In my defence I run it to the limit as the priter tells me quite in advance that the ink is running low, just underestimated how long I had run it with the light flashing. Sorry for wasting everyone's time and thanks very much for the help.
answersonapostcard Avatar
20 Jan 2021 12:01PM
Glad you got it sortedSmile
saltireblue Avatar
saltireblue Plus
13 14.5k 89 Norway
20 Jan 2021 12:04PM

Quote:Just removing the egg from my face so that I can reply. It helps to replace the black cartridge when it runs out. In my defence I run it to the limit as the priter tells me quite in advance that the ink is running low, just underestimated how long I had run it with the light flashing. Sorry for wasting everyone's time and thanks very much for the help.


Been there, done that...Blush

Login

You must be a member to leave a comment.

ePHOTOzine, the web's friendliest photography community.

Join for free

Upload photos, chat with photographers, win prizes and much more.