Home >Topics >excel >What should I do if the lines between cells are missing?

What should I do if the lines between cells are missing?

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-08 16:03:4740878browse

Solution: 1. Select the cells where all the data is located, click "View" - "Gridlines" at the top of the page, and click twice; 2. Select the cells where all the data is located, and select Go to "Home" - "Color" at the top of the page and select "No fill" in the drop-down menu.

What should I do if the lines between cells are missing?

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open the file we need to modify, and then we will find that some cells have table lines, and some cells do not have table lines

What should I do if the lines between cells are missing?

Method 1 :

We select the cells where all the data is located, and then click View-Gridlines. We click twice, because different versions may appear after clicking twice.

What should I do if the lines between cells are missing?

What should I do if the lines between cells are missing?

If the grid lines do not appear in the above method, we continue to the next step

What should I do if the lines between cells are missing?

method 2:

We click on the color and select no color fill in the drop-down box

What should I do if the lines between cells are missing?

Generally try two methods and you will get results

Related learning recommendations: excel tutorial

The above is the detailed content of What should I do if the lines between cells are missing?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn