Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Hi,
I have set up a spreadsheet in Numbers and added fill to parts of the sheet. The formatting looks correct on the screen, but when I export or print as a PDF there are white line borders around each cell. I have attached a screen shot or the screen and the PDF so you can see the difference. Is there a way to stop these white borders on the PDF? It doesn't occur with in Excel, just Numbers.
Mac mini, macOS 11.4
It's a bit counter-intuitive, but if I select all the dark cells, then click the top-right icon in the border layout box, then choose No Border, I get a pdf without the white lines:
PDF:
Choosing the top-left icon only applies the 'No border' style to the perimeter of the selected area, not to the individual cells.
I seem to remember reading a while back about similar formatting problems with documents originally created in Excel then opened in Numbers.
If you happen to be opening Excel documents then that might be causing the borders problem.
SG
Thanks HD. I had tried that and just tried it again but it is still showing the white lines on the PDF. It looks fine on the screen while working in Numbers but they appear on the print dialogue box and then the PDF.
Thanks SG. I did wonder that as the original file I was trying to format had started life in Excel, but then I setup a Numbers document from scratch and it still does it. The screenshots were from the Numbers test document, so Excel wasn't involved.
It is a bug in Numbers. Set the borders to at least 1pt and set to the same fill color as the cells
Thanks. That solves it as a work around. Seems like a basic bug so hopefully apple will resolve it soon.
How to stop white borders around cells in Numbers when printing?
