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: Border tab to create a border for the table.
- 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: Select the diagonal style for the cell including dark and light styles or select cut lines.
- 4: Choose to add an internal or external threading frame.
- 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.
You should read it
- How to split cells, combine cells in Excel
- How to split 1 cell into 2 cells in Excel - Split cells in Excel
- Instructions on how to split cells in Excel 2003 and 2007
- Instructions on how to create diagonal lines in Excel box
- How to split cells, combine cells (cells) in Word table
- Merge cells in Excel
- How to merge and split cells in Word
- Instructions on how to split and merge cells in Word
- How to color formula cells in Excel automatically
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- How to split strings in Excel
- How to calculate and color blank cells in Excel
May be interested
8 ways to number Excel numbers, number Excel numbers with text
How to combine photos in Word, combine 2 photos into 1 frame
How to create a table of contents in Google Slides, Powerpoint Online
The most detailed way to format borders for Excel tables
How to type angle symbols in Word simply and quickly
The most effective way to number pages in Word 365 as desired