How to draw a slash in excel

How do I draw a slash and type up and down in Excel**? When we use excel to do **, many times we will be required to do the header to draw a slash, and type up and down, such as the name, the month to do **, the name and the month to correspond, when doing the header, the name and the month need to be in the same **, and use the slash to distinguish it, so how to achieve it, let's take a look.

How do I draw a slash and type up and down in Excel**?

For example, this table, I'm going to add.

Name + Month", separated by a slash.

Adjust the size of the header cell to be appropriately large enough to accommodate more than two cells.

** Adjust out the border. Check ** - Right click - Format cells - Select outer border, inner box.

Click. Start - Format - Format the cell (or select the first cell, right click - format the cell), Border - Slash.

When the slash appears, enter the name month in the header.

Method 1: Alt+Enter

Then slowly adjust the distance between the two groups of words with spaces.

Method 2: Select "Month", right-click - format cells - superscript.

Check "Name", right-click - format cells - subscript.

Then slowly adjust the distance between the two groups of words with spaces.

How do I draw a slash and type up and down in Excel**? When we use excel to do **, many times we will be required to do the header to draw a slash.

For example, draw a diagonal line in A1: right-click A1 to format the cells, borders, and click on the diagonal on the right.

Draw the cursor with the first diagonal line, then click the Line tool again, and then draw the second diagonal line; 3. Point View Toolbar The "Text Box" (horizontal) tool in the drawing toolbar, draw a text box in any cell, right-click the small circle in the dotted border, click "Format Text Box" in the right-click menu, and the "Color and Line" tab in the window point appears, and in the "Fill" and.

Open Excel, enter the page, select the cell you need to insert a slash, right-click it, select Format Cell, pop up window, switch to the border options bar, click the slash in the lower right corner of the text, and click OK to insert.

Here's how to draw a diagonal line in excel:1. Open Excel**, and then click Insert, as shown in the figure below

2. After entering the insert page, click on the shape selection, and then select the straight family vibrato, as shown in the figure below

3. After selecting the straight line, you can draw a diagonal line in **, as shown in the following figure:

4. After drawing the slash, you can choose to set the color and the size of the slash in the toolbar, as shown in the following figure

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 next to Hui Burn, and one will run down, and it will be separated.

The steps to draw an oblique calendar line in excel** are as follows:

1. Open Excel** and select the ** that needs to be inserted into the slash.

2. After selecting the cell, right-click, find and click "Format Cell" in the pop-up right-click menu of Zen Zhizheng.

3. In the pop-up window, find the "Border" option in the navigation bar and click to enter.

4. In the border setting window, click the "Slash" command in the lower right corner, and then click OK to add a slash to the cell.

The steps to draw an oblique calendar line in excel** are as follows:

1. Open Excel** and select the ** that needs to be inserted into the slash.

2. After selecting the cell, right-click, find and click "Format Cell" in the pop-up right-click menu of Zen Zhizheng.

3. In the pop-up window, find the "Border" option in the navigation bar and click to enter.

4. In the border setting window, click the "Slash" command in the lower right corner, and then click OK to add a slash to the cell.

1. First open Excel** as a sample table.

2. Then select the cell you need to insert a slash and right-click. In the pop-up menu, select Format Hidden Cells.

3. In the pop-up dialog box, click "Border". Click the slash in the lower-right corner and click OK. Slippery.

5. After the line is marked, click "Insert" and "Shape" in the menu bar again, select the slash style, and repeat the operation.

Draw a slash header.

1. Insert a new ** or click the ** you want to add a slash header.

2. On the Layout tab, click Draw Slash Header.

3. In the Header Style list, click the desired style. There are five styles to choose from, and you can use the Preview box to preview the selected header to determine what style you want.

4. Enter the required row and column headings in each title box.

Note: When using the Draw Slash Header header, the new header will replace the original header.

If the cell can't fit the header you entered, you'll see a warning and the characters won't fit will be truncated.

Adjust the slash header cell.

When you need to resize the header and drag the border of the header cell, the combined objects in the header do not move with it. In this case, you can adjust the header in the following ways.

Select the slash header, then select any of the handles of the combined objects in the header, and drag the handle until the slash header fits.

Click Draw Slash Header, and then click OK.

Use the diagonal line in the border to draw a slash header.

1. Select the cell you want to draw the slash header, right-click, and then click Format Cell.

2. Click the Borders tab, click Outer Borders and click the diagonal button from the top left to the bottom right.

3. Click the "OK" button. You can also modify the style and color of the lines in this window.

Use the drawing tools to draw the slash header.

1. Select the cell you want to draw the slash header, right-click, and then click Format Cell.

2. Click the Borders tab, click Outer Bends, and then click OK.

3. Click the Insert tab, and in the Illustration group, click Shape.

4. Select the line, in the cell where you want to draw the slash header, place the mouse in the upper left corner, drag the mouse, and place the lower right corner of the line in the desired position.

5. Repeat the previous step, you can add multiple slashes.

Tip By adding a text box and setting the outer border line color of the text box to the wireless bar color, you can enter a title where you want.

Click "View - Tools - Drawing", in the "Drawing" toolbar that appears, click the "Line" icon, and then draw a little line in the cell, if you want to draw a second line, then click the "Line" icon again, and draw another line.

If you want to enter text in this cell with slashes, then set the cell to align to the left, and then enter the text, if you want to force a line break, then press Alt+Enter to adjust the up and down position of the text, press the blank key, you can adjust the left and right position of the text.