Additional Information on How to Format Cells with Strikethrough in Excel 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. That is the keyboard shortcut for Strikethrough in Excel 2013. You will just want to click the box to remove the check mark.Īdditionally, the strikethrough effect can be applied or removed by simultaneously pressing the Ctrl + 5 keys on your keyboard. You can use these same steps to remove strikethrough in a cell. Now that you have completed our draw line through text in Excel steps you will be able to use or remove this formatting in the cells in your spreadsheets. Step 2: Select the cell to which you want to apply the strikethrough effect. Step 1: Open your spreadsheet in Excel 2013. While this guide will be focused specifically on doing this to one cell, you can choose any number of cells that you would like. The steps in this guide are going to show you how to draw a line, also called “strikethough”, through information contained within a cell in your Excel spreadsheet. How to Draw a Line Through Numbers or Text in Excel 2013 (Guide with Pictures) 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. 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.
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 a helpful thing to use when you are creating documents. Microsoft Excel has a large number of different ways to adjust the appearance of data in your cells, and the strikethrough formatting is one of those options, though it can be tough to find. The ability to strikethrough in Excel can come in handy when you need to format cells text in Excel in a way that keeps that text in the spreadsheet, but indicates that it should be ignored. Our article continues below with additional information on how to draw line through text in Excel 2013, including pictures of these steps.