How to draw a slash in Excel

Source: Internet
Author: User

For the use of Excel software is not familiar with novice friends, usually because of the need to enter some special symbols or forms of special operations and stagnation, such as today's small series to recommend how to draw a slash in Excel, the tutorial is as follows:

  The first method, which I call an external method, is named because it involves word.

  The first step: make a diagonal header in Word, draw the table first, then select the table and the border, and pull the slash directly. (Hint: Click the Layout tab and tap the draw slash head button)

  Step Two: when the mouse pointer becomes a black, solid, diagonal arrow in the head of the slash, CTRL + C copies the header.

  Step three: in Excel, select Paste command in the right-click menu and select MicroSoft Office Word Document object in the dialog box so that the slash header that you just created in Word is pasted into Excel for fine-tuning.

  The second method I call internal law, because it is complete inside Excel, hence the name.

  First step: Adjust the grid as the header so that it can hold the text. Bring up the Drawing toolbar for Excel, click Rectangle, and draw a rectangular box at any point in the worksheet, not too big to put down a word.

  The second step: the right mouse button on the "Rectangle", select "Add Text", the box becomes a text box, enter text in this text box.

  Step Three: right-click the text box, select Format AutoShape, and in the dialog box, select the fill and line colors in the color and Line tabs for no fill color.

Press these three steps to enter other text, each text is a box, I entered here is the month and year date.

  Step Fourth: Use the line tool in the Drawing toolbar to draw a slash.

  Fifth Step: group synthesis slash header, hold down SHIFT, and select three text boxes and two diagonal lines when the four-headed arrow appears under the mouse pointer. Shift key do not release, right-click to select the Group/Group command, so that multiple objects just selected will be merged into one object.

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.