• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Cross Out in Excel

How to Cross Out in Excel

By: Filonia LeChat
  • Share
  • Share on Facebook

Just because the data in your Excel spreadsheet isn't what you want it to be doesn't mean you don't want it to be visible. Whatever your reason for needing to cross out cell contents, Excel's strikethrough feature lets you put this effect into action. In a couple of clicks, you'll see your cells showing small, neat lines through the characters within.

Step

Launch Excel 2013. Open an existing spreadsheet or create a new one and type in some text to apply the strikethrough effect.

Step

Right-click the cursor into the cell to cross out and click "Format Cells" from the fly-out menu. The Format Cells window opens.

Step

Click a check mark into the Strikethrough box under the Effects section.

Step

Click the "OK" button and you are returned to the spreadsheet with the cross-out appearing.

Video of the Day

Step

Click the "Format Painter" button, the small yellow paintbrush in the Clipboard section of the Home tab's ribbon which stores your last formatting action in Excel's memory.

Step

Move to another cell you want to cross out. Click into the cell and the Strikethrough effect is applied.

Show Comments

Related Articles

How to Use Minus Function in Excel

How to Use Minus Function in Excel

Around The Home
Productivity
By: Lysis
How to Do a Strikethrough in OpenOffice

How to Do a Strikethrough in OpenOffice

Around The Home
Productivity
By: C. Taylor
How to Make an Overbar in Excel

How to Make an Overbar in Excel

Around The Home
Productivity
By: C. Taylor
How to Use Wingdings in Excel

How to Use Wingdings in Excel

Around The Home
Productivity
By: KristyW
How Do I Check for Circular References in Excel?

How Do I Check for Circular References in Excel?

Around The Home
Productivity
By: Aaron Parson
How to Change a Percent Into a Decimal in Excel

How to Change a Percent Into a Decimal in Excel

Around The Home
Productivity
By: C. Taylor
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.