{"id":2639,"date":"2019-09-20T13:30:49","date_gmt":"2019-09-20T05:30:49","guid":{"rendered":"https:\/\/owa.sodexo-cn.com\/blog\/?p=2639"},"modified":"2019-09-20T13:30:49","modified_gmt":"2019-09-20T05:30:49","slug":"%e3%80%90excel%e3%80%91-slash-header-read-not-worry","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=2639","title":{"rendered":"\u3010Excel\u3011 slash header, read not worry"},"content":{"rendered":"\n<p>Hi, everyone, today I am going to talk to you about how to make a slash header. In daily work, everyone must deal with the slashing head, which is a distinctive feature of Chinese-style forms. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"384\" height=\"141\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/1-3.jpg\" alt=\"\" class=\"wp-image-2632\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/1-3.jpg 384w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/1-3-300x110.jpg 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/figure>\n\n\n\n<p>PS: Before making a slash header, be sure to first determine the font size of the table and the row height column width of the table.<\/p>\n\n\n\n<p>1. Input text<\/p>\n\n\n\n<p>Enter &#8220;Item&#8221; in cell A1, then hold down the Alt key and press Enter. Force a line break in the cell and enter the &#8220;work number&#8221;. Then set the cell to the left.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"449\" height=\"148\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/2-1.jpg\" alt=\"\" class=\"wp-image-2633\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/2-1.jpg 449w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/2-1-300x99.jpg 300w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/figure>\n\n\n\n<p>Place the mouse cursor in front of the &#8220;item&#8221; and press the space bar to adjust the distance between the text and the left side of the cell.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"449\" height=\"171\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/3-1.jpg\" alt=\"\" class=\"wp-image-2634\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/3-1.jpg 449w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/3-1-300x114.jpg 300w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/figure>\n\n\n\n<p>2. Format Cells<\/p>\n\n\n\n<p>Click the A1 cell and press Ctrl +1 to set the cell format<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"541\" height=\"488\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/D.jpg\" alt=\"\" class=\"wp-image-2640\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/D.jpg 541w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/D-300x271.jpg 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Next, let\u2019s talk about making a slash header with three elements.<\/h4>\n\n\n\n<p>1. Input text<\/p>\n\n\n\n<p>First adjust the row height and column width of the cell, enter the three heading content, press Alt+Enter to force the three headings to be displayed, and then use the space to adjust the position, and get the following effect:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"346\" height=\"113\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/5.jpg\" alt=\"\" class=\"wp-image-2636\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/5.jpg 346w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/5-300x98.jpg 300w\" sizes=\"auto, (max-width: 346px) 100vw, 346px\" \/><\/figure>\n\n\n\n<p>2. Draw lines<\/p>\n\n\n\n<p>Draw a line and draw two dividing lines from the top left corner of the cell.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"277\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/F.jpg\" alt=\"\" class=\"wp-image-2641\" srcset=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/F.jpg 557w, https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2019\/09\/F-300x149.jpg 300w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Friendly Reminder: In practical applications, try not to use the function of slash header and merge cells, and the subsequent data aggregation will cause a lot of trouble.<\/h4>\n","protected":false},"excerpt":{"rendered":"<p>Hi, everyone, today I am going to talk to you about how &#8230; <a title=\"\u3010Excel\u3011 slash header, read not worry\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=2639\" aria-label=\"\u9605\u8bfb \u3010Excel\u3011 slash header, read not worry\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2639","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"views":2648,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2639"}],"version-history":[{"count":1,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2639\/revisions"}],"predecessor-version":[{"id":2642,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2639\/revisions\/2642"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}