Home> Topics> excel> body text

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

藏色散人
Release: 2023-01-13 00:41:26
Original
103437 people have browsed it

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!

Related labels:
source:php.cn
Statement of this Website
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
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!