如何给excel单元格加斜线（How to slash a excel cell）.docVIP

如何给excel单元格加斜线（How to slash a excel cell） Ask: How do I add a slash to the excel cell and add content on both sides of the diagonal? Answer: Select the cell to add the slash header, right-click, select the settings cell format, click the border tab, select the last diagonal line of the border option (i.e. slash style), and make sure the point is ok. In this cell, enter the amount of time, the cursor stops in the number, time center, press alt+enter, change to the two line, and then use space to adjust the location properly. For example, what you want is quantity / time. Answer: In view of the tool out of the Drawing toolbar, draw a slash in the cell header directly using the line tool, this method is also suitable for slash header complex, text input, the same drawing square text box, adjust the text box at the appropriate position of slash box, add text, the frame is set to no fill color can be. Answer two: You must ask the slash header complex based on, a simple operation must be used, as long as the set in the slash Format Cells dialog box, press the ALT+ENTER release of artificial input, in the edit box to press the spacebar to adjust in order to obtain the best position to sideline frame does not exceed the quasi line, of course, this kind of operation you will have. For complex types, however, there are slash header settings in WORD, but they are also style type limitations. In EXCEL, you can directly use the line and text box on the Drawing toolbar, no matter how complicated it is. It is important to note that while inserting text pointer will become the + style, just click to place the text into the health, remember to click, only need to adjust the position of the selected text box (in edit mode), press CTRL key and the cursor on the left are slightly adjusted Answer three: 1, draw a slash, format - cell - frame - click the lower right corner - to determine, enter the text with the ALT+ENTER input two lines within a cell, with the input of blank will be put