How to draw a slash in Excel? Introducing the slash in Excel

Nowadays, many people need to use office software for their work. Many people are asking, how to draw a slash in the excel form?

There are many ways to draw slashes in Excel. There are a variety of single slashes, double slashes, three slashes, and four slashes. Tutorials, for office enthusiasts to refer to, hope that the majority of office enthusiasts learn to use, excel 2013 a variety of slash methods as follows:

How to draw a single in Excel Slash

Step 1: First, adjust the length and width of the first cell to a larger point;

Step 2: Click “Start”-- 》Format--"Set the cell format, you can also directly select the first cell, then right click, select “Set cell format” in the pop-up drop-down list, then go to “border", click “ Slash & rdquo; button, then OK;

Step 3: Now return to the worksheet we can see a slash at the header. Enter text in it, such as here I enter: & ldquo; region date & rdquo;;

Step 4: How can we let the "region" & quoquo; to the top of the cell slash, let “ date & rdquo; Going under the slash? Here are three ways I can do this:

(1) Use soft return (ALT + Enter): between "region" and "date” Excel shortcut “Alt+Enter” (soft return), then use “space” in front of the “area” to adjust the position slowly;

(2) Use “superscript" "subscript" "subscript"":check “date” then right click to select “set cell format”, under special effects, "subscript" Check and confirm; then select “Region'; set it to “superscript”, set it up, then use “spacebar” slowly adjust the position.

(3) Insert text box: Select “plugin", click the “text box” button in the “text” tab, then above the slash Pull out a "text box" input area, and then pull out a "text box" in the lower part of the slash; enter the date, then select “ text box & rdquo; click & ldquo; format & rdquo;, in “ Shape fill & rdquo; select “ no fill color & rdquo;, select "no outline" in the "shape outline";

How about a simple single slash head Draw it, let's take a look at the way to make a multi-slash table!

How to draw double slashes in Excel

The method of making multiple slash headers is completely different from the practice of single slashes. of.

Step 1: Click on the “insert” tab and select the "shape" in the "Line" line below "Line";< Br>

Step 2: Use the “Line” tool to draw two diagonal lines in the cell, as shown below;

Step 3: The double slash has been drawn. Here we should compile the text message. It is recommended to use the “Insert Text Box” method to type the text information in the header slash. Click the “insert” tab, select “text box", pull out multiple text boxes, then type the text in the text box, then select “text box"""format” , in the "Shape Fill", select "No Fill Color", select "In the Shape Outline", "No Outline";

Step 4: Although the double slash has been drawn Finished, but in the end we finally put together the text boxes, hold down “Shift+left mouse button> click to select the "text box", and then click “ in the “format“ tab “"combination" in the combination of “text box” is done.

How to draw multiple slashes in Excel

It would be a bit complicated to make multi-slashes according to the method of making double slashes. Here, I will introduce you to a simpler and faster method, using Word to help draw multi-slashes.

Step 1: Open the Word Insert form, then adjust the length and width of the header, adjust it to the same as the header in Excel, click “Layout” Tab, click & ldquo; draw slash header & rdquo; button;

Step 2: In the pop-up "insert slash header", we can see "header style" There are many styles in it, and you can preview a few slashes below, enter the text in the "row title"""column heading" and then determine;

Step 3: Insert After the slash header, we click to select the header, then Ctrl+C to copy it to Excel;

Step 4: Finally, adjust the size of the slash header in Excel. can.