Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Make a Table Header with 2 Slashes in Excel

Date:2019-9-2 Author:Cordelia

In addition to a cell with a diagonal line, sometimes you may also need to make a table header with 2 slashes in Excel if there are multiple kinds of data to be organized. It requires you to insert 2 lines in a cell as well as text on each side of the lines. So how could you make it come true?

Take this table as an example, now I want to insert 2 slashes to the cell A1.

How to Make a Table Header with 2 Slashes in Excel

Switch to Insert tab, select the straight line in the Shapes menu.

How to Make a Table Header with 2 Slashes in Excel

Then you can draw a line directly in the cell and choose the color of it in Drawing Tools.

How to Make a Table Header with 2 Slashes in Excel

Click the straight line in Insert
Shapes and you can draw it in the cell again.

How to Make a Table Header with 2 Slashes in Excel

After drawing 2 lines, it’s time to insert text to the cell. To set the format right, right-click the cell and choose Format Cells…

How to Make a Table Header with 2 Slashes in Excel

Switch to Alignment in the popping out window. Set the Text alignment as General in Horizontal and Center in Vertical. You can also check Wrap text in Text control.

How to Make a Table Header with 2 Slashes in Excel

Now you can input the texts of header in A1.

How to Make a Table Header with 2 Slashes in Excel

Press Space key to set the location of each text. And if you didn’t check Wrap text in last step, you can press Alt+Enter to assign the text to another line.

How to Make a Table Header with 2 Slashes in Excel

After finishing the adjustments, the texts have been placed on each side of the 2 slashes.

How to Make a Table Header with 2 Slashes in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *