How to cross cells in Excel

You're making a table in Excel and have a blank data cell and you want to cross that box but don't know how to do it. Let TipsMake.com help you through the article How to cross cells in Excel offline!

You're making a table in Excel and have a blank data cell and you want to cross that box but don't know how to do it. Let TipsMake.com help you through the article How to cross cells in Excel offline!

How to cross cells in Excel Picture 1How to cross cells in Excel Picture 1

Step 1 : You open the Excel file to perform. Select the cell you want to cross out -> Right-click and select Format Cell .

How to cross cells in Excel Picture 2How to cross cells in Excel Picture 2

Step 2 : Then, in the Format Cells window, select to the Border section.

Here you choose how to slash (1) or (2).

Or choose a line style (3).

Then select OK to finish.

How to cross cells in Excel Picture 3How to cross cells in Excel Picture 3

Step 3 : Then to perform the information writing in the cell you use spaces (Space) and press Alt + Enter to enter the line in the cell to align the text accordingly.

How to cross cells in Excel Picture 4How to cross cells in Excel Picture 4

Thank you for following the article. I wish you successful implementation!

4 ★ | 1 Vote