Home >Topics >excel >How to draw diagonal lines and write words in a grid in excel

How to draw diagonal lines and write words in a grid in excel

藏色散人
藏色散人Original
2021-01-20 14:13:41103596browse

How to draw a slash and write in a cell in excel: First open the excel table; then select the cell where you need to draw a slash, right-click the mouse, and select "Format Cells"; then select "Border" - "Slash"; finally, fill in the text in the cell with the slash and adjust the position of the text.

How to draw diagonal lines and write words in a grid in excel

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

Recommended: "Excel Tutorial"

Open the excel table.

How to draw diagonal lines and write words in a grid in excel

Select the cells that need to be drawn with slashes, right-click the mouse, and select "Format Cells" in the pop-up drop-down window.

How to draw diagonal lines and write words in a grid in excel

Select "Border" in the pop-up cell format window, and then select "Slash".

How to draw diagonal lines and write words in a grid in excel

As shown in the picture, a slash has been inserted into the cell.

How to draw diagonal lines and write words in a grid in excel

In the slashed cells, fill in the text "name" and "discipline".

How to draw diagonal lines and write words in a grid in excel

Select "Person's Name", right-click, select "Format Cells", select "Subscript" in the pop-up window, and click OK.

How to draw diagonal lines and write words in a grid in excel

The operation of "Discipline" is similar, just select "Superscript" and click OK.

How to draw diagonal lines and write words in a grid in excel

After finishing, adjust the text size. As shown in the figure, the operation of drawing lines in cells and inserting contextual words is completed.

How to draw diagonal lines and write words in a grid in excel

The above is the detailed content of How to draw diagonal lines and write words in a grid in excel. 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