Excel three column slash table head how to make

Excel three column slash table head how to make

Step one: Add the border line. There is no option to add a border line, you can use the edge of the cell. As shown in the following figure.

Step two: Add a slash.

1, Excel2003 version: Toolbar Right-click menu (or View-toolbar)-Draw-Dot line icon, drag and draw a slash in Excel.

2, Excel2007 and Excel2010 version: Insert-shape-point line icon, drag and draw a slash in Excel.

Step three: Add text. The reason why this method is perfect, all lies in the perfect place to put the text. Other methods are cell input line wrapping, and text boxes add text to the method. But none of this method is simple and practical.

1, Excel2003 version, the toolbar right menu (or view-toolbar)-form-in the form of the Point AA (label)-drag and draw out the label-to change the text required.

2, Excel2007 and EXCEL10 version, development tool-insert-in point AA (label)-Drag and drop the label-to modify the text as needed. As shown in the following figure.

Attached: If you Excel does not develop Tools tab, Excel2007 left Office Button-Excel option-In the Options window, see the Development Tools tab at a glance; Excel2010, file-options-Custom Ribbon-select "Development tools" in the right-hand list.

The effect of the final setting is shown in the following illustration.

Add: When you study VBA, you open the Developer tab and remember how to add it.