Excel how to enter a single slash \ Multi Slash header

Source: Internet
Author: User

When you make an Excel table, you use a slash-and-slash-head. It's not hard to add a slash, you can right-click a cell to add a single slash using format cell formatting or to add multiple slashes manually by using insert - shape - line .
Slash add good, content how to enter it? This is a problem that many students are concerned about.

Easy to find two simple ways:



  1. Add content by using a text box

    ClickInsert-text Box-HorizontalVertical Text Box”。






    The mouse will go down the arrow like


    , drag the mouse to generate a text box. Then type the header content in the text box. You can also make some text formatting edits if you want.






    When the text box content is entered and edited, move the mouse, and when it is turned into four arrows, drag the text box to the diagonal header cell. You can then adjust the position of the header content by adjusting the position and size of the text box.






    Attention: Do not forget to set the text box toNo paddingWireless BarFormat Oh ~)

    The same way, the other contents of the header into the text box, and finally drag the past, find a suitable place to put the good! (Here small easy to single slash head for example, multiple slash table head as long as more than a few text boxes can be built)





  2. Direct input

    Enter the header content directly in the cell and press "alt+enter" to wrap the line. Then you can adjust the position of the content by wrapping and spacebar.






    This method is relatively simple, but not as good as the text box control, the layout may not be so beautiful.




Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.