How to put slash in Excel to make a single slashe or double slashes header of table
If you want to split the header of table by slash, how could you draw a slash in Excel? Excel only provides a way to draw a slash by default, that is, draw a slash between the two corners of a cell, the method is very simple, you can achieve it by Format Cells, but you can't draw double slashes and triple slashes to the header; If you want to draw more than two diagonal lines, you have to use the indirect method.
Chapters:
0:00 How to put slash in Excel?
1:30 How to draw double slashes in a table header in Excel?
2:12 Add text with TextBox
2:59 Add text between two slashes
Description:
How to put slash in Excel to make a single slashe or double slashes header of table
After drawing a slash on the header, you should also add text above or between the slash, which has three methods, which are to add spaces between the text, use superscript or subscript, and use text boxes.
One. How to put slash in Excel to the header of table? (*How to put a slash through a cell in Excel?)
1. Pull the row height of the first row high, right-click the first cell of the table (i.e. A1), select "Format Cells" in the pop-up menu, select the "Border" tab in the open window, click the "Slash" icon, click "OK", then Excel draws a diagonal line of the same color as the border in the header of table.
2. Add text
Method 1:
A. Click cell A1, enter "Title", press "Alt + Enter" on your keyboard to wrap, and then enter ".No".
B. Click on cell A2 to end the input state of A1, click A1 again to reselect it, click the "Left Alignment" icon above "Alignment" under the "Home" tab, and set the alignment of A1 to "Align Left".
C. Double-click "Title" to position the cursor in front of it, press the "Spacebar" on the keyboard to move it to the right, then the position of "Title" and ".No" are moved.
Method 2:
A. Also enter "Title" in cell A1, press "Alt + Enter" on the keyboard to wrap, and then enter ".No"; Select "Title" and right-click, select "Format Cells" in the pop-up menu, open the "Font" window, click "Superscript" to check it, and then click 16 under "Size", set the word "Title" after setting as "Subscript" to 16, click "OK"; Check ".No" and right-click, also open the "Font" window, check "Subscript", then set the "Size" to 16, click "OK"; Move the "Title" a little to the right, and the text is added.
B. Use superscript and subscript, the text should be smaller.
Two. How to draw double slashes in a table header in Excel?
1. Select the "Insert" tab, select cell A1 in the header of table, click "Shapes", select "Line" in the pop-up shapes, move the pointer to the vertex on the upper left corner in A1, it will then become a plus sign +, hold down the left button and drag down to the right, drag until the right border of A1, then draw a slash, the same way to draw the second slash, then the double slash is drawn.
2. Set the slash to the same color as the border. Double-click the first slash to select it, switch to the "Format" tab of the editing shape at the same time, click "Shape Outline", select "Orange" under "Standard Colors", then the selected slash becomes the selected color; The same method sets the other slash to "orange."
3. Add text
A. Add the word "title" indicating the first row. Click the slash above, select the "Format" tab, click the "Text Box" icon, move the pointer to cell A1, press the left button and drag to draw a text box, click in the text box to position the cursor inside, enter "Title"; Select "Title", select the "Format" tab again, click "Shape Fill", select "No"; Click "Shape Outline" again and select "No"; The border and background of the text box are removed; Select the "Home" tab, click the "Font Color" icon, select "Orange, Accent 2, Darker 25%", and the word "Title" is set.
B. Add the "Main" between the two slashes. Make a copy of the text box, change the "Title" to "Main", and turn it parallel to the upward slash by rotating the text box.
C. Add the word ".No" indicating the first column. Make another copy of the "Title", change the "Title" to ".NO" and adjust the position, so that the table slash header is made.
Watch video How to put slash in Excel to make a single slashe or double slashes header of table online without registration, duration hours minute second in high quality. This video was added by user Loinsure 05 April 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,769 once and liked it 8 people.