How to set a double slash header in Excel

Source: Internet
Author: User
Tags date

Method One: You can take advantage of the drawing tools in Excel. The Drawing toolbar in Excel is not open by default, right-click in the toolbar and open the Drawing toolbar. And then adjust the size of the cell, draw the diagonal you want, draw the text box in the margin, enter the header text, double-click the Format text box, select the Color and Line tab, fill Color, select No fill, line color, select Wireless Bar color.
Hold down the CTRL key while you drag the text box you just created, copy the formatted text box, change the text inside, and then use the "shift+ click" to select the object of the header, right-click, and select "Combination".

Technical Highlights: Use the Borders tab in the Format Cells dialog box to set a slash, and use the Alignment tab to adjust the text position with the SPACEBAR.


Method Two: The concrete operation steps are as follows.

1. Click the A1 cell in the worksheet, enter the contents of the slash header, such as the two headings "project name" and "date" in this example, enter "project name" first, then press the shortcut key to ALT + ENTER, so that you can wrap within the cell, press ALT + ENTER once, and enter date.

2. Press CTRL + ENTER so that you can select the cell without leaving the cell.

3. Press the shortcut key ctrl+1 to open the Format Cells dialog box. (You can also open the dialog box if you right-click on the cell and choose the command "format Cells" from the shortcut menu that pops up, but it's quicker to use shortcut keys.) )

4. In the Format Cells dialog box, click the Borders tab, and then click the left Slash button.

5. In the Format Cells dialog box, click the Alignment tab to set the horizontal and vertical alignment of the text to justified. When you have finished setting up, click the OK button.

6. Observe the text in the header, obviously the location of the project name is not very appropriate. Double-click the A1 cell, position the insertion point to the left of the project name, and press the spacebar two times to make the item name position to the right. Press CTRL + ENTER to leave the edit state and select the A1 cell, and if you find that the project name is wrapped, you can adjust the width of the column to fit it so that you can adjust the line width to fit the size of the table head. Of course, you can also change the size of the text in the header. Finally we can get the header slash effect.

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.