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!
Step 1 : You open the Excel file to perform. Select the cell you want to cross out -> Right-click and select Format Cell .
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.
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.
Thank you for following the article. I wish you successful implementation!
4 ★ | 1 Vote
You should read it
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- How to split cells, combine cells in Excel
- How to calculate and color blank cells in Excel
- How to Lock Cells in Excel
- How to merge cells in Excel - Instructions to merge cells in Excel 2010, 2013, 2016
- Instructions on how to create diagonal lines in Excel box