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!
How 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 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 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 4
Thank you for following the article. I wish you successful implementation!
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
May be interested
How to create List Box in Excel
How to split tables and join tables in Word
Instructions to design business cards on Word extremely fast and beautiful
Instructions on how to print text, print documents Word, Excel, PDF details
What is a macro in Excel? How to create and run a Macro in Excel
How to fix formulas in Excel, fix data ranges in Excel