excel 2013 print preview bottom border missing

When colors get covered, gridlines go hidden under them. Most of the time we use different colors to highlight a particular set of data. Make a right-tap over the “Format Cells” option.Ģ: Tap to the “Border” tab and then get ensure that none of the borders are in the active status. So you have to remove the cell borders to fix this issue.ġ: Hit the “Ctrl + A” to choose entire cells. Besides this whether it is marked for visibility or not.Ĭhances are also that you are getting these missing gridlines in Excel issue because of the white-colored cell borders. See here from this box, you can choose different types of colors if you wish.Ĭheck whether your gridlines is having the right property set assigned or not. After that from the opened box of colors choose the automatic option or else you can select any other colors also. Here are the steps that you need to follow for changing the grid color back to the default one:Ģ: Now hit the “Advanced” tab and then scroll down in the section “Display options for this worksheet”.ģ: Now hit the drop-down arrow sign present next to the gridlines color option. The reason behind this is, white gridlines won’t appear on white background. So you need to get ensure that the color won’t get changed to white. This is the best tool that helps you to repair and recover corrupted, damaged, and inaccessible data in XLS and XLSX files.īy default, Excel gives the greyish color of gridlines. To fix corrupt XLS and XLSX file you can go with this professional recommended Excel File Repair software. It is the best tool for the recovery of corrupt Excel workbook data and to avoid permanent data loss situations. For this, the best-recommended solution is using Excel Repair software. So, the first solution which I want to recommend is repairing your corrupt Excel file. Mostly this type of missing data or damaged worksheet issue raises when the corruption issue hits your Excel sheet. Trick 1: Best Software To Fix Excel Missing Gridlines Issue Turn Gridlines On/Off For Entire Worksheet Best Software To Fix Missing Gridlines In Excel Worksheetħ.

Here are the following fixes that you must try to fix gridlines missing in Excel worksheet.ġ. How To Fix Missing Gridlines In Excel Issue?

Excel 2013 print preview bottom border missing