Solution to non-gridline excel sheet in Win7 System

Solution to non-gridline excel sheet in Win7 System

Excel tables are often used in our work. Recently, a Win7 system user found that the entire table page is blank when using an excel table, the lines and borders (gridlines) on the excel worksheet page are missing (faults are shown in the figure below). How can I deal with this problem? Next we will share with you the solution to the absence of grid lines in all the blank excel tables.

The steps for retrieving blank and non-gridline excel sheets are as follows:

1. Return to the view page of the document and click "View" in the toolbar. The "show/hide" option is displayed in the second area. There are multiple options on it ,;

2. Select "gridline". This is to look at the table on the page, and the lines around the cells are displayed normally.

3. At this time, we can easily find the cell location to be edited with the help of gridlines.

4. You may find that in the "show/hide" setting area, you can control the title and edit bar in addition to grid lines, you only need to select or remove the check box to understand the specific function ,:

The preceding figure shows the solution for the absence of blank pages and lines and borders (gridlines) in an Excel table. This method is also applicable to office (2003, 2007, 2010, and 2013) or WPS.