Instructions on how to cross cells in Excel

To cross cells in Excel, you just need to use the cell adjustment tool in Excel with very simple usage features. Cross lines in Excel are very familiar, especially when you create a table in Excel to divide the title cell into 2 different contents in the same cell.

The diagonal line in an Excel cell will divide an empty cell in Excel into two parts to represent the two functions of rows and columns, and describe the two contents of columns and rows. The article below will guide you through cross-hatching cells in Excel with different versions.

Instructions for crossing cells in Excel 2016, 2019

How to cross out Excel cells from Font on the Ribbon

Step 1:

First, click on the cell that needs to divide the diagonal line in the data table. Next, the user clicks on the Home tab on the toolbar. You look down at the Font group and then click on the arrow icon as shown below.

Instructions on how to cross cells in Excel Picture 1

Step 2:

Switch to the new interface, click on Border .

Instructions on how to cross cells in Excel Picture 2

The user will now see the interface to draw borders for cells in Excel. You will draw a slash to the right or left depending on the content in the writing box.

Instructions on how to cross cells in Excel Picture 3

You choose the direction of the crossed out box you want to use and then click OK below to create.

Instructions on how to cross cells in Excel Picture 4

As a result, we have crossed cells in Excel as shown below.

Instructions on how to cross cells in Excel Picture 5

How to cross out Excel cells from the right-click menu

Step 1:

Also in the cell you want to cross, right-click and select Format Cells in the displayed list.

Instructions on how to cross cells in Excel Picture 6

Step 2:

This time also displays the Format Cells dialog box, click Border to choose to create borders for cells in Excel.

Instructions on how to cross cells in Excel Picture 7

Step 3:

We can also choose the direction of the slashes in the cell to use for our Excel table.

Instructions on how to cross cells in Excel Picture 8

How to write text in crossed out cells in Excel

Step 1:

In the slashed box you want to insert content, first double-click twice in the box with the slashed line . Next we enter the first content we want to add to the cell and then use the Space key to align to the right side of the cell.

Instructions on how to cross cells in Excel Picture 9

Step 2:

Press the key combination Alt + Enter to break the line and then enter the second content for the column row in the table.

Instructions on how to cross cells in Excel Picture 10

Step 3:

As a result, we will get the content in the diagonal box as shown below.

Instructions on how to cross cells in Excel Picture 11

If the text in the cell is shifted up or down, you will use the alignment icon as shown below.

Instructions on how to cross cells in Excel Picture 12

Instructions for removing slashes in Excel

If you do not want to use slashes in the cell, just select the delete function.

Click on the box with the crossed out box, click on the Home tab, then look down at the Editing group and click on the Clear icon . Next select Clear Format in the displayed list.

Instructions on how to cross cells in Excel Picture 13

Video instructions for crossing cells in Excel 2016, 2019

How to create diagonal lines in Excel 2007

Step 1:

First of all, we have the data table below as an example. Here, I will perform the operation of dividing the first cell in the table into 2 small cells with a clear diagonal division including Area and Category. The Zone column will include all locations below. The Category column includes Product Type and Quantity.

In the cell that needs to be divided, the user right-clicks and selects Format Cells. to set up all the properties that affect this cell in the data table.

Instructions on how to cross cells in Excel Picture 14

Step 2:

The Format Cells dialog box interface appears. Here, we click on the Border tab . Because the requirement here is to divide 1 Excel cell into 2 diagonal triangles, creating an Excel diagonal, we follow the steps below:

1. 1: Border tab to create a border for the table.
2. 2: Create Excel diagonal lines in two different directions, left and right. When pressing once to create a diagonal line, pressing twice to cancel that diagonal line.
3. 3: Select the diagonal style for the cell including dark and light styles or select cut lines.
4. 4: Choose to add an internal or external threading frame.
5. 5: Choose the color for the border.

Finally click OK to save the changes.

Instructions on how to cross cells in Excel Picture 15

Immediately after that, you will have a table with cells with lines.

Instructions on how to cross cells in Excel Picture 16

Step 3:

Finally, we just need to enter text for each created cell . Press the Space key to align the text, depending on the length and length of the text in each cell. Press the key combination Alt + Enter to enter a new line in that cell.

Instructions on how to cross cells in Excel Picture 17

The final result will be a data table with the first cell forming 2 small triangles with diagonal lines as shown.

Instructions on how to cross cells in Excel Picture 18

Creating 1 cell into 2 triangle cells in Excel with diagonal lines will help the table be clearer, more flexible as well as accurate in presenting content and data. Depending on the content of each table, users can customize the text content accordingly.

Jessica Tanner

Update 26 July 2024