Thanks, Malcolm, but ticking the box did not work. I had to go further into the Page Setup dialog to ensure printing was not set to draft. Now it works. Lesson learnt.
I can format cells on an Excel 2013 worksheet with borders. The borders appear in print preview but do not print out.What do I need to do?
I will try this option now Malcolm, but does it allow me only to print coloured cells or coloured text in black cells which I had been trying to do. I will also try Excel help again. Your instructions have been more helpful so farTry printing after this this:
Microsoft Office Button | Excel Options | Advanced | Display options for this worksheet | tick Show gridlines. In the Gridline color box, click the color you want.
You may well find useful guidance in the Excel Help files.
I am using Excel 2013 which was loaded on the laptop at purchase and wonder if my difficulty may be originating here as the excel icon is not coloured but is black and not detailed like your example. I will have to go back to Dell and see what they can do.I do not have in-depth knowledge of the available options to meet your expecations and do not know if they are attainable? You need someone with a far greater knowledge than me to answer the question you ask in your latest message. Also, as I no longer use a colour printer, I am unable to test for the condition you describe. All I can tell you is that text set to white doesn't print in my b/w printer.
BTW - I have Excel 2007 and it is, along with the other applications in MS Office Enterprise 2007, adequate for my modest needs. Which version of Excel are you using? Some settings are different in different versions of the MS Office Suites
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.