How does Excel draw a slash in a cell, you can enter the text and separate the text with a slash

The slash header can be drawn, and the drawing tool --- Custom Lines --- Straight ---.

You can also use --- to format cells --- borders --- slashes in the lower left and right corners.

and backslashes.

Type one first when typing inside"Date"Press the alt key and the enter key.

Break the line and enter it again"Name", and finally enter a space to adjust the position of the Chinese characters.

If a grid is divided diagonally into 3 squares, you need to use the --- drawing tool --- a straight --- to draw it.

Write again"Date"Press Alt+Enter, Write"data"Press alt+enter, and write last"Name"and use the spacebar to adjust the position of each phrase.

After the diagonal slash is set for the cell, enter it in the cell"day"Press Alt+Enter, and then enter"Period"Press Alt+Enter, and then enter"room"word, and finally use the spacebar to adjust the position of the text.

Select the cell you want to draw a slash, click "Format-Cell-Alignment-Check Auto-Wrap", then enter the text in the column and fine-tune it to the appropriate position, and then click the straight line in the drawing to separate the text.

If there is only one header for each row and column, you can do this: select the cell, format the cell border, and then click the slash button in the lower right corner of the border area to make sure the slash is set, enter the row header text in the cell, and then press Alt + Enter to force a line break, and then enter the column header text. If there are more than two header items, it is recommended to use Word's slash header and then copy it.

Just use the drawing tool to draw a line, unlike Word, which has "draw a slash header".

1. First of all, open the excel software on the computer, and then create a new ** document in excel.

2. Next, select the ** that needs to be added with a slash, and right-click and select "Format Cells".

3. Then select "Border" - "Slash" in the dialog box and click "OK".

4. Next, enter the text in the cell with the slash added.

5. Then select "Humanities", right-click and select "Format Cells", select "Subscript" in the dialog box, and click "OK".

6. Then select "Discipline", right-click and select "Format Cells", select "Superscript" in the dialog box, and click "OK".

7. Finally, it is done, draw a slash in the cell and write the text.

Hello, generally adding text up and down the slash is a method that needs to add text first, and then add a slash, which is described in detail below.

Step 1: Enter the content "upper right" in the cell, press the shortcut key alt+enter, the cursor has been changed to the second row, and enter the content "lower left";

Step 2: Place the mouse cursor on the left side of the content "top right", press the space bar several times until the "top right" moves to the far right (at this time, if you accidentally press too many spaces to move the "up" to the next line, you can delete a space);

Step 3; Ctrl+1 or right-click to open the Format Cells dialog box, border, select the border from top left to bottom right, click once, OK;

1. As shown in the figure below, it is required to draw two diagonal lines in the selected A8 cell and text the content at the same time.

2. Click to select the A8 cell, click the [Insert] tab, then click to select the [Shape] option in the following options, and select the [Straight Line] option pointed by the blue arrow in the following picture in the pop-up options.

3. Back to the worksheet, such as guessing the following picture, the user can click the left mouse button and drag the mouse in the selected cell to draw the straight line to the appropriate position of the cell.

4. After the first diagonal line is drawn, then draw the second diagonal line again according to the method in the previous step.

5. Click to select a slash in the cell, then press the [Ctrl] key to select the second slash, click the [Format] function tab, and click in the [Shape Style] to change the color of the slash.

6. Double-click the cell inserted into the slash, enter the text content in the cell, and press the [Alt+Enter] key to wrap the line in the messy type.

Excel**How to make a slash and enter text? Very simple! Excel** only needs a few simple steps to enter text after making a slash, when we use excel** to make, what should we do if we don't use excel** to make a slash and enter the text?

Let's learn together.

Open Excel.

We right-click on any cell and click Format Cell.

The dialog box pops up, click the border, add a slash, and OK.

After the slash is added, enter the text in the cell, if the width of the ** you make is long enough, and the text input is relatively short, then it is easy to enter the text above and below the slash. As shown in the figure below.

If yours'**The width of the production is not long enough, you can also enter all two contents in the cell, move the cursor to the project boundary, and press the alt+enter key on the keyboard. Note: The front is the column, and the back is the row.

The two items become two rows, which can be adjusted using the spacebar.

Once adjusted, the text above and below the slash is entered.

1. The slash header can be used, and the drawing tool can be drawn --- the --- of the selected line --- straight line;

2. You can also use --- to set the cell format--- the slash and backslash in the lower left and right corners of the border --- to set;

3. Type one first when typing inside"Date"Press the alt key and enter key, force a line break, and enter again"Name", and finally enter a space to adjust the position of the Chinese characters.

Fourth, if a grid is obliquely divided into 3 grids, this should be drawn with a --- drawing tool --- a straight line ---;

Fifth, write again"Date"Press Alt+Enter, Write"data"Press alt+enter, and write last"Name"and use the spacebar to adjust the position of each phrase.

6. After the diagonal slash is set in the cell, enter it in the cell"day"Press Alt+Enter, and then enter"Period"Press Alt+Enter, and then enter"room"word, and finally use the spacebar to adjust the position of the text.

1. Start by creating an excel** as a demonstration.

2. Click the cell you want to underline, right-click and select Format Cell.

3. Select the border - the text of the slash in the cell format - OK.

4. The slash is good, you can type a line of words first, and then click the keyboard alt+enter key to wrap the cell.

5. Then type a line of words, and wrap the line with the same alt+enter key in the middle of the two lines, so that one will run up, one will run down, and it will be separated.

When using ecxel to do **, it is often encountered when drawing a slash in the header of the table, so how to enter text in the excel slash cell?

Material tools.

Excel, computer. Method.

In the ecxel document, find the Line and insert it into the cell.

Please click Enter a description.

Please click Enter a description.

Enter 10 spaces in the cell (adjust according to the size of the cell).

Please click Enter a description.

Alt+Enter] key, enter [Name], and you're done.

Please click Enter a description.

Method 2: Enter [Name] [Month] in the cell, select [Name] and right-click [Format Cell].

Please click Enter a description.

Select Subscript for font and click OK.

Please click Enter a description.

Select Month, right-click Format Cells.

Please click Enter a description.

Select [Superscript] for the font, and click [OK].

Please click Enter a description.

Isn't it easy to do both?

Please click Enter a description.

1. Open Excel**, and you need to put a diagonal line in cell A1 in the figure below.

2. Click the "Insert" option in the page toolbar and select the "Shape" icon.

3. Select "Line" in the "Shape" drop-down box that opens, and click the first line style.

4. After that, according to the diagonal position of the figure below, drag the mouse from the diagonal position of the cell to draw a diagonal line.

This can be achieved with beveled borders in the cell format.

You can also use the insert line to draw an oblique line.

Enter the name of the column and the name of the row (such as item, quantity, etc.) in the cell, click the relevant text, and then right-click the mouse to format the cell Font and select subscript or superscript.

Continue to click on the cell, and right-click the mouse to format the cell Border and select the left or right slash.

Click the "Draw" button, select "Line", and the mouse will change to a cross Move it to the starting position where you want to add a slash, hold down the left mouse button and drag to the end position, release the mouse, and the slash will be drawn. In addition, you can use the "Text box" button to easily add text above and below the slash, but there is a border around the text, if you want to cancel it, you can select the Chinese word box, bring up the quick display menu, select "Object Format" "Pattern", and select the "No Border" item.

In fact, it's quite simple: 1. Select the cell - right click - cell format - border - select the slash - OK, 2. When entering the text, you only need to master a skill: ctrl+enter, you can enter the text at the beginning, and then use the previous shortcut key, and continue to enter the corresponding position in the space!

Hope is the answer you want.