How to Remove Strikethrough in Google Sheets


Do you have a spreadsheet that contains cells with lines through them? While using this formatting option, called “strikethrough” serves a useful purpose of identifying information as deleted without actually deleting it, you might find that your current needs require the removal of that formatting. Fortunately, just as Google Sheets provides the ability to add strikethrough formatting, you are also able to remove it.

Our guide below will show you where to find strikethrough in Google Sheets. You can then select it to remove strikethrough from a selected group of cells that contain it. Conversely, if you wish to add strikethrough to a cell, these same steps can help you to achieve that result as well.

 

How to Clear Strikethrough Formatting in a Google Sheets Spreadsheet

The steps in this article will assume that you currently have a spreadsheet with cells that have the strikethrough formatting. These steps will show you how to select the cells with strikethrough, then remove that strikethrough formatting.

Step 1: Go to Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet containing the strikethrough that you want to remove.

 

Step 2: Select the cell with strikethrough to remove.

select the cells with strikethrough

 

 

Step 3: Click the Format tab at the top of the window.

click the google sheets format tab

 

 

Step 4: Click the Strikethrough option.

how to remove strikethrough in google sheets

 

 

Note that you can also remove or add strikethrough formatting to a cell by pressing Alt + Shift + 5 on your keyboard. Additionally there is a Clear formatting option at the bottom of the menu in step 4. If there is additional formatting applied to a cell besides the strikethrough, then you can select the Clear formatting option to remove the other formatting as well.

 

Do you have a spreadsheet in Excel that has strikethrough, and you would like to know how to remove that as well? Learn about Excel strikethrough to see how the setting is controlled in that application as well.

 

 

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.