Home>Article>Topics> How to draw a slash in a cell and type?

How to draw a slash in a cell and type?

尚
Original
2020-03-06 15:05:02 12443browse

How to draw a slash in a cell and type?

Setting ideas: Use line breaks in cells to separate text up and down, use table borders to set slashes, use spaces and adjust the distance between rows and columns of cells to achieve the best display effect.

EXCEL2007 version (other versions are similar), the steps are as follows:

1. Open the excel workbook, select the corresponding cell of the worksheet with a slash

2. Enter For the text above the slash, alt enter, change line, and continue to enter the text below the slash.

How to draw a slash in a cell and type?

3. Right-click the cell and select Format Cells

How to draw a slash in a cell and type?

4. The Format Cells dialog box will pop up. , select the right slash in "Select Border" to confirm

How to draw a slash in a cell and type?

5. Return to the spreadsheet and add a space in front of the upper text according to the view effect to achieve the display effect. If If you want to increase the distance between the upper and lower lines, you can add a blank line by ALT ENTER after the upper row of text or before the lower row of text.

How to draw a slash in a cell and type?

Recommended learning:Excel Basic Tutorial

The above is the detailed content of How to draw a slash in a cell and type?. 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