Printing grid does not work

[eddyq]

I setup to print the grid. It prints it but lots of lines and columns don't have the grid ... many do. They all show up in excel.

The print preview shows all grid lines.

Can someone make a suggestion?

EddyQ

[shawnamillion]

Strange problem.

Where it's not printing the grid, does the content of the adjacent cell stretch beyond the cell itself or close to the edge? Unless you change the formatting, if cell B1 is empty, and contents of cell A1 are larger than cell A1 it will stretch into cell B1 and not show the gridline between the 2. If this is the case, reduce text size or increase cell size.

If this is not the case, I don't know what's causing it but you could just add a border to the cells instead of printing grid view. You can even change thickness of border and possibly colour to look faint like normal gridlines.

[eddyq]

There is no content, just headings. The headings are perfect and not stretched. I don't know the version because that has been removed from Excel but I think it is 2010. I added xxxx in every field and the grid got worse. Now the first 25 lines don't have horizontal grid lines and lines 26-44 do. Columns A-D don't have grid lines in all rows. But columns E-I do. It is not consistent as many times it is variable as to what doesn't get the grid lines. In fact if I re-print every thing changes. I have used two printers with no success.

[shawnamillion]

Do the gridlines show up in the print preview window? Have you tried just using a border instead of print gridlines?

[eddyq]

Yes the print preview shows up just fine. I can try the border if it is not too painful.

[eddyq]

I turned on boarders by using the below. That again shows up just fine in Print Preview but the printout has the same issue. So I tried printing to PremoPdf to see if it is the printer but the PDF looks the same as the printout.

Follow these steps to add cell borders:
1. Select the cells you want to format.
2. Click the down arrow beside the Borders button in the Font group on the Home tab. A drop-down menu appears, with all the border options you can apply to the cell selection. ...
3. Click the type of line you want to apply to the selected cells.

Interesting ... I turned off print grid and used the boarders and that works just fine.

Thanks for the suggestion.