The strikethrough effect is a helpful thing to use when you are creating documents. It provides you with a way to visually delete or mark information as something that is not important, but it allows you to keep it around so that readers can still see it, or in case you decide later that you need it.
The strikethrough effect is particularly helpful when you are working with data in a spreadsheet, so you might be looking for a way to use that formatting option in Excel 2013. Our guide below will show you how to find the strikethrough option both through the ribbon, as well as a shortcut that you can use to quickly draw or remove a line through cell data.
How to Draw a Line Through Data in Excel 2013
The steps in this guide are going to show you how to draw a line, also called “strikethough”, to information contained within a cell in your Excel spreadsheet. While this guide will be focused specifically on doing this to one cell, you can choose any number of cells that you would like.
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Select the cell to which you want to apply the strikethrough effect.
Step 3: Click the Home tab at the top of the window.
Step 4: Click the small Font Settings button at the bottom-right corner of the Font section in the ribbon.
Step 5: Check the box to the left of Strikethrough, then click the OK button.
You can use these same steps to remove strikethrough in a cell. You will just want to click the box to remove the check mark.
Additionally, the strikethrough effect can be applied or removed by simultaneously pressing the Ctrl + 5 keys on your keyboard. That is the keyboard shortcut for Strikethrough in Excel 2013.
Is there a lot of formatting applied to your spreadsheet that you don’t want? Rather than changing each individual formatting option, learn how to clear cell formatting in Excel 2013 and save yourself some time and frustration.