Home  >  Article  >  Topics  >  How to draw a line in an EXCEL cell

How to draw a line in an EXCEL cell

coldplay.xixi
coldplay.xixiOriginal
2021-03-01 10:24:5641127browse

How to draw a line in an EXCEL cell: first select the cell and choose to format the cell; then click "Font" and put a check in front of the special effect strikethrough; finally click OK in the lower right corner button.

How to draw a line in an EXCEL cell

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

Method to draw a line within an EXCEL cell:

1. Taking the excel2010 version as an example, if you are drawing a line within text, select the cell, and then Right-click the mouse and select Format Cells in the pop-up box;

How to draw a line in an EXCEL cell

#2. Click "Font" in the pop-up box, put a check mark in front of the strikethrough for special effects, and then click on the lower right corner OK button;

How to draw a line in an EXCEL cell

3. You will see that the text of the cell is underlined;

How to draw a line in an EXCEL cell

4. If you want to draw a line in an empty cell, click the "Insert" option at the top of the page;

How to draw a line in an EXCEL cell

5. Select "Shape" on the insertion page, and click "Shape" in the pop-up box. You can select the desired line type here;

How to draw a line in an EXCEL cell

6. After selecting the line, you can directly draw the line in the cell. You can set the line length and color according to your needs.

How to draw a line in an EXCEL cell

Related learning recommendations: excel tutorial

The above is the detailed content of How to draw a line in an EXCEL cell. 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