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!
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
- Merge cells in Excel
- How to color formula cells in Excel automatically
- 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
- How to split 1 cell into 2 cells in Excel - Split cells in Excel
- How to Sort Cells Alphabetically in Excel
- How to merge cells in Excel 2003 2007
- How to delete cells in Excel
Maybe you are interested
Transparent solar cells help smartphones charge themselves with sunlight
Tips for formatting cells in Excel for professional spreadsheets
How to Justify Text in Cells on Excel - Adjust Text Spacing
What is a bifacial solar cell? What are the advantages?
Successfully developed 'indoor solar cells' with conversion efficiency up to 37%
How to name an Excel cell or data area - Define Name feature on Excel