Set the header in cells 2010 of Excel

When making reports, you may have encountered this problem, that is, how to set the header in a cell. It includes a slash, two slashes, and N slashes, many slashes seem useless.

650) This. width = 650; "Title =" 181.jpg" src = "http://s3.51cto.com/wyfs02/M00/49/48/wKioL1QSYsDTtXlrAAA9jw0MQgI130.jpg" alt = "wkiol1qsysdttxlraaa94250mqgi130.jpg"/>

I don't know if C1 can be used. Here is just an example.

 

First, it is very easy to create the header of a single slash, that is, to set the border in the cell attribute, and then add the diagonal slash.

650) This. width = 650; "Title =" 182.jpg" src = "http://s3.51cto.com/wyfs02/M02/49/48/wKioL1QSY36irYAkAADy6ER2fn0102.jpg" width = "584" Height = "478" alt = "wkiol1qsy36iryakaady6er2fn0102.jpg"/>

 

It's easy, and then you can enter data. When entering data, you should note that the cell data location should be set to top, and then use spaces and manual line breaks to control the data (Alt + enter ). Effect

650) This. width = 650; "Title =" 183.jpg" src = "http://s3.51cto.com/wyfs02/M01/49/48/wKioL1QSZFvQIYgaAABxIog5RIA805.jpg" alt = "wkiol1qszfvqiygaaabxiog5ria805.jpg"/>

Very simple. The following describes how to implement the headers of the three slashes. The three slashes cannot be set with borders, but they are also very simple. Insert --- shape --- line ).

650) This. width = 650; "Title =" 184.jpg" src = "http://s3.51cto.com/wyfs02/M02/49/47/wKiom1QSZT_B-k7uAAHNRgXM6qM768.jpg" alt = "wKiom1QSZT_B-k7uAAHNRgXM6qM768.jpg"/>

 

Next, draw a line with the mouse in the table. If the diagonal line is complete or the input data is complete, you only need to remember to set the data location to the top, and remember to use Alt + enter to automatically wrap the line.

This article from the "GUO Yong technology blog" blog, please be sure to keep this source http://guoyong.blog.51cto.com/408495/1551508

Set the header in cells 2010 of Excel