Buzz
Dividing a cell into 2 by crossing it out makes the information on your Excel spreadsheet clearer and more organized. Excel is a software that supports users in data processing, integrating many features and functions for convenient operations, and crossing out cells in Excel is one of them.
Guide to Cross Out Cells in Excel Easily
I. Quick Guide to Cross Out Cells in Excel Using Shortcuts
- 1. Quick Instructions
- Select the cell to cross out => press Ctrl + 1 => go to Border, choose the cross out style => Click OK.
2. Detailed Instructions
Step 1: Open the Excel file, select the cell to cross out => Press the Ctrl + 1 shortcut.
Step 2: Go to Border, choose the cross out style (left slant or right slant) => Press OK.
==> Result after applying crossed-out text in Excel cells:
II. Guide to Cross Out Cells in Excel Using Mouse
Step 1: Open the Excel file, select the cell to insert crossed-out text => Right-click and choose Format Cells.
Step 2: Press Border, choose cross-out style => Press OK.
III. Guide to Cross Out Cells in Excel via Ribbon
Step 1: Open the Excel file, select the cell to apply cross-out text.
Step 2: On the toolbar, click Format => Select Format Cells.
- Download links for various Excel versions:
- - Excel 2021
- Excel 2019
- Excel 2016
- Excel 2010
- Excel 2007
- Excel 2003
IV. Guide to Remove Crossed-Out Lines in Excel Cells
To remove the crossed-out formatting in Excel cells is extremely simple, follow these steps:
- Step 1: Select the cell with crossed-out lines in Excel.
- Step 2: On the Home tab, click Clear => choose Clear Format, clear the crossed-out cell.
After successfully crossing out cells in Excel, you can write crossed-out text in Excel to save space for your spreadsheet or to make your data table look organized, visually appealing, and reflect the professionalism of an Excel data handler.
