How do I make an Excel single-slash\multi-slash header? - EeeKB

Single-slash\multi-slash headers are often used when you are creating an Excel table. It is easy to add a slash by right clicking a table cell, using "Format Cells", and adding a single slash or using "Insert - Shape - Line" to manually add multiple slashed.

After adding the slash, what shall we do to enter content? Many students are concerned about this problem.

EeeKB now provide you with two simple ways:
  1. Use Text Box to Add Content

    Click "Insert - Text Box - Horizontal\Vertical Text Box".

    Your mouse will turn to a down arrow. Drag the mouse to generate a text box. Then, type the header content in the text box. If necessary, you can also edit the text format.

    Once you complete the content typing and editing in the text box, move your mouse until it becomes an 4-direction arrow, and drag the text box into the slash header cell. Now, you can adjust the position of the header content by placing and resizing the text box.

    Note: Remember to set the text box requirement as No Fill and No Line format.)

    By the same method, type other content of the header into text boxes which are then dragged respectively into right places in the header cell. (The single-slash header is just taken for instance here. The multi-slash header simply needs more text boxes.)

  2. Direct Typing

    Type header content in cells directly, pressing "Alt+Enter" for line feed. Then, use line feed and space key to adjust the content position.

    This method is relatively simple, however, not so controllable as text boxes. The layout may be not so good looking as well.

If it does not work all the same, you are suggested to dig the Forum to see if any solution can be best for you.

We welcome all of your comments and suggestions!

We welcome all of your comments After your experience of EeeKB, if time allows, pls score this article in the feedback table at the page bottom. We will appreciate your help for our improvement. Any recommendation or good thoughts will be welcomed in "Additional Comments". (For faster solution to your problem, technical queries could be put into discussion in appropriate posts at the Microsoft Community)
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2625107 - Last Review: 05/26/2014 11:27:00 - Revision: 3.3

Microsoft Excel 2010, Microsoft Office Excel 2007

  • kbinfo kbhowto kbstepbystep kbtypenonkb kbpubtypesc kbexpertisebeginner KB2625107