

My Xerox Phaser 7500 printer, showed the lines but exceptionally faintly. For PostScript printing, Acrobat actually passes through the 0 w width descriptions in PDF to 0 setlinewidth in PostScript (I validated it manually!) and passes that through to the printer. What happens when printing is printer driver and printer-dependent. Acrobat and Reader do their best to render the output. That is interpreted by both PostScript and PDF as a single pixel in width for the renderer. They are defined by AutoCAD as zero width lines. There is a reason for the disappearing lines. Make contributors happy, click on the “* Add Reputation” as a way to say thank you.I received the problematic file privately from mike podlabeniouk and examined it. Another option would be to highlight the sheet (click in the upper corner) and use the borders feature. There is a grid line check box under view I think. <-If you like someone’s answer, click the star to the left of one of their posts to give them a reputation point for that answer. Try using the format painter to restore the borders that are missing.

What to do if your grid lines are missing? Step 1: Press Ctrl + A to select all the cells. If you do not see any color there are chances that the overlay color selected is white. When colors are overlaid, gridlines hide under them. Sometimes you may highlight blocks of data by different colors to make them distinct from the rest. Why do gridlines hide under colors in Excel? Select the cells that are missing the gridlines, or hit Control + A to select the entire worksheet. If the background color for a cell is white instead of no fill, then it will appear that the gridlines are missing. Why are the gridlines missing in my Excel spreadsheet? Tip: Create a style that has the fill AND the cell borders applied, then you only need on click in the Styles panel to apply the look.Ĭlick on the View tab, then check the box for Gridlines in the Show group. If you want to see grid lines on cells with a fill colour, you need to format the cell borders. The Excel grid lines are only visible when a cell has no fill. How do you fill cells but keep gridlines?

Click anywhere on the chart to which you want to add chart gridlines.Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.On the Page Layout tab, in the Page Setup group, click Page Setup.
