Excel slash header how to do

How do I draw an Excel slash? It's always a good idea to watch a table in Excel with a slash in Excel, so how do you add a slash? Here's to Excel2003, 2007 and 2010 version of the form of diagonal slash method, I hope you can quickly grasp.

Here is a casual form, to do a demo for everyone, the following figure:

The first step, will need to slash the table "long" and "high" adjustment larger, the following figure:

The second step, then select the need to slash the table, click the "right", the selection of "format cells", in the "cell format" inside choose "Border", click the "Slash" button, the following figure:

The third step, in the form of the input slash-divided text, remember to use "ALT + enter" return, the following figure;

The fourth step, finally in the first row of text in front of the space bar adjustment, as shown in the "Time" preceded by a space.

The Excel2003 of the form slash is done, is not very simple.

How to draw a single slash in Excel 2007 and Excel 2010.

The first step is to Gechang and wide adjustment of the initial unit (pictured below);

Step two, click the "Start"--> format--> format cells, you can also select the first cell, and then right-click, in the pop-up drop-down list select "Format Cells", then go to "border", click the "Slash" button, and then determine (the following figure);

Step three, now back to the worksheet, you can see a slash in the head of the table.

Enter text in it, such as here: "Region date" (pictured below);

Fourth step, then how to make the "region" to the top of the cell slash, so that "date" to the bottom of the slash?

Here are three ways to achieve this:

Method One, the use of soft return (ALT + Enter): Between the "region" and "date" with "ALT + return" (Soft return), and then in the "area" before the use of "space" slowly to adjust the position can be;

Method two, use superscript and subscript: Select Date and then right-click to format cells, and under special effects will be "subscript" before the hook selected, determine, and then select "Region" to set it as "superscript", set up, and then use the "space bar" slowly adjust the position;

Method Three, insert text box: Select Plugins, in the Text tab, click the Text Box button, then pull a "text box" entry area on the top of the slash, and then pull out the text box in the lower section of the slash to enter a date, and then select text box to click Format, and in shape fill, select No Fill Color , select No outline in shape outline.