Want to know how to make text stand out in Excel? You can add visual cues to your text by using the strikethrough effect. In this article, we’ll show you how to easily strikethrough text in Excel.
The Purpose of Strikethrough in Excel and How to Use It
Strikethrough is a handy formatting feature in Microsoft Excel. You can use it to cross out or delete text/numbers that are outdated or incorrect, but still useful for historical purposes. It can also be used for highlighting important info for later review. Here’s how:
- Select the cell(s) containing the data you want to strikethrough.
- Go to the “Home” tab on the ribbon menu and look for the “Font” group.
- Click on the “Font” group” and find the “Strikethrough” icon.
- Click once to apply strikethrough format. Then, click outside of the cell(s) to save your changes.
Strikethrough works across multiple cells at once, as long as they are selected together. To remove strikethrough, just follow steps 1-3 and uncheck the “Strikethrough” option.
Using strikethrough properly can help make your spreadsheet more organized and easier to read. You can even combine it with conditional formatting and colors or styles (e.g. bolding) for more effective communication. Text wrapping/merging can also be helpful.
Learn How to Apply Strikethrough in Excel
Want to add Strikethrough to your Excel worksheets? It’s easy! Here are the five steps:
- Select the cell(s) with the text you wish to strikethrough.
- Head to the “Font” tab in the Home ribbon.
- Tick the “Strikethrough” box in the “Effects”.
- Alternatively, use the keyboard shortcut “Ctrl + 5” to apply strikethrough.
- To undo it, uncheck the “Strikethrough” box or use the shortcut again.
Strikethrough is useful for tracking changes and flagging completed tasks. It also helps to correct errors without deleting data! It makes worksheets more understandable, and quickly highlights important points for others.
Recently, I used Strikethrough to review my monthly expenses. It helped me mark off paid bills and old receipts quickly.
Now, let’s learn how to customize line styles when applying Strikethrough in Excel!
Applying Strikethrough in Excel
Excel can be great for data tracking. But, what about marking certain cells as “complete“? That’s when strikethrough comes in. This tool lets you put a line through the cell, without deleting it. It’s easy to use and saves time. In this section, I’ll show you how to use Strikethrough in Excel.
To use Strikethrough in Excel, follow these steps:
- Select the cells you want to mark
- Go to the Home Tab
- Click Strikethrough
Image credits: pixelatedworks.com by Yuval Jones
Selecting Cells to Apply Strikethrough
Open the Excel worksheet and navigate to the cells where you want to apply strikethrough. Click on the first cell and drag your cursor over any other cells you wish to apply it to. Right-click on any of the selected cells and choose “Format Cells” from the context menu. In the Format Cells window, navigate to the Font tab and check the “Strikethrough” box in the Effects category. Click OK when done.
It’s important to remember that this function will only cross out what is inside a cell, not any other properties like borders or fill colors. To remove strikethrough, deselect the same checkbox.
Select only the relevant range of cells to properly use the feature. Avoid applying it randomly as this could lead to confusion when analyzing data. Also, be aware of applying different fonts with different styles in a single worksheet as this could affect readability.
In short, selecting cells to apply strikethrough means identifying specific ranges to apply this formatting feature correctly. Be organized and take note of its scope and relevance while avoiding common mistakes like duplicating information.
Lastly, Applying Strikethrough Using Font Group in Home Tab explains how to quickly format texts in MS without going through long processes.
Applying Strikethrough Using the Font Group in the Home Tab
To apply a strikethrough using the Font group in the Home tab, follow these six steps:
- Open your Excel spreadsheet and select the cell with the text you want to strikethrough.
- Go to the “Home” tab at the top of your screen.
- In the “Font” group, click the arrow next to the “Borders” button.
- A drop-down menu will appear; select “More Borders“.
- In this new window, go to the “Border Styles” tab.
- Checkmark “Strikethrough” – this will add a strikethrough line to your selected text.
Strikethrough is an easy way to draw attention to certain cells without having to delete or change any text. It’s useful for tracking progress or noting data changes over time.
For example, I once used it to keep track of wedding guest RSVPs.
Click the “Strikethrough” option to achieve similar results!
Clicking the Strikethrough Option
To start, choose the cell or cells that you want to have Strikethrough formatting. Go to the Home tab in Excel’s Ribbon. Look for the Font group. You will find an icon labeled ‘Strikethrough’. Click on it.
A quicker way to apply Strikethrough is by using a keyboard shortcut. Select the cells and press “Ctrl” + “5”. The strikethrough format will appear instantly.
If you want other forms of Strikethrough like colour or font size, use the ‘Format Cells’ dialogue box. Go to the Fonts section. Find the ‘Strikethrough’ option under effects. Check it.
Now that your cells are marked with Strikethrough formatting, you can make modifications like adding comments, doing corrections or highlighting data points. You can make notes in new rows/columns or add a comment in each cell.
I once prepared a report which had lots of data that needed annotations for future use. So, I used Strikethrough formatting heavily to recognize different values later.
Next, let’s learn how to Remove Strikethrough in Excel.
Removing Strikethrough in Excel
As an Excel user, I often need to remove strikethrough formatting from cells. This is so spreadsheets are concise and easy to read. Unneeded formatting can cause problems and even errors. Let’s look at three techniques to remove strikethrough formatting in Excel.
- Select cells with strikethrough
- Use the Font Group in the Home Tab
- Click the strikethrough option to remove the unwanted format
Image credits: pixelatedworks.com by Adam Woodhock
Selecting Cells with Strikethrough to Remove
- Step 1: Highlight the Cells – Select the range of cells with strikethrough. Or, click an individual cell if you only want to remove strikethrough from one cell.
- Step 2: Click Font Group – Go to the ‘Home’ tab. Locate the ‘Font’ group on the right side of the screen.
- Step 3: Remove Strikethrough – Access the Font Group. Look for the ‘Strikethrough’ option (
S). Deselect it by clicking. The Strikethrough will instantly disappear from all selected cells.
Removing Strikethrough is useful when you want to update data without deleting it in an Excel spreadsheet. This way, it’s easy to see where changes are needed without affecting other parts of the worksheet.
Fun Fact: Excel was first released for Mac in September 1985 by Microsoft. It became popular because of its flexibility and portability across computer platforms like Windows and MacOS X.
Using the Font Group in the Home Tab to Remove Strikethrough is a great way to easily remove formatting in your Excel spreadsheet. Keep reading for more tips!
Using the Font Group in the Home Tab to Remove Strikethrough
Remove strikethrough from a cell or range of cells in Excel by following these 6 steps:
- Open your Excel document and select the cell or range of cells with the strikethrough formatting.
- Go to the “Home” tab in the top menu bar.
- Locate the “Font” group tab.
- Uncheck the “Strikethrough” button among other formatting options, like Underline, Bold, Italicize, etc.
- Apply changes by clicking elsewhere on the document or pressing enter.
- Strikethrough formatting is now gone!
Improving readability and professionalism can be achieved by removing strikethrough from a cell. The Font Group in the Home Tab provides quick access to all essential formatting tools for editing a cell’s font.
Recently, my friend and I faced difficulties when working on an Excel project. We had to update data across multiple sheets. It was confusing to figure out which records had been modified due to inconsistent documentation — some cells were underlined, some only had text, and many had
strikeout formatting! Changing what we already had was more difficult than entering new information.
Another way to remove formats related only to a particular property such as font size is by clicking ‘The Strikethrough Option to Remove Formatting.’ This might be a better choice than using the Font Group in the Home Tab.
Clicking the Strikethrough Option to Remove the Format
Open an Excel sheet. Select the cells that have strikethrough formatting. On the Home tab of the ribbon, find the Font group. Click on the Strikethrough button. This deactivates the strikethrough option for all selected cells.
Removing strikethrough does not delete any content. It only removes the visual cue indicating something has been crossed out. To fix accidental strikethrough, follow the steps above. Save the Excel document before closing to save your changes.
Tips for Using Strikethrough in Excel:
- Achieve better productivity and efficiency with large data sets.
- Streamline work processes using Excel spreadsheets.
Tips for Using Strikethrough in Excel
Excel is a regular part of my job and I’m aware of how vital it is to communicate data accurately. A great way to show changes/updates in a spreadsheet is the strikethrough function. Here, I’ll share some tips and tricks for using it effectively. We’ll explore three main purposes: showing which tasks are done, deleted items, and out-of-date info. Let’s learn how to use this useful feature to its full potential!
Image credits: pixelatedworks.com by Yuval Duncun
Indicating Completed Tasks with Strikethrough
- Select the cell containing the completed task.
- Click on the Home tab at the top of your Excel worksheet.
- In the Font section, select the Strikethrough icon (it looks like an ‘S’ with a line through it).
Strikethrough in Excel is helpful when comparing data sets or scanning for finished tasks. For example, if you are managing a project with a list of tasks given to different team members, when they finish their assigned task, indicate completion by striking through the cell or row.
Strikethrough has an advantage. It keeps the original data for future use, instead of deleting it. This is useful when working with large datasets or complicated projects.
Once a colleague deleted a row in an Excel spreadsheet while trying to mark it as complete. This mistake caused setbacks for the team and delayed the project by days.
To prevent this from happening again, we use Strikethrough to indicate completion status. Performance improved and errors decreased.
Explore other ways to use strikethrough to boost productivity and accuracy. In the next section, we will discuss Indicating Deleted Items with Strikethrough.
Indicating Deleted Items with Strikethrough
To indicate deleted items with strikethrough in Excel, there are 3 easy steps to follow:
- Select the cells you wish to delete.
- Go to the “home” tab from Excel’s ribbon menu.
- Click on the “strikethrough” button in the font section.
Afterwards, the data will be crossed out. This makes it easier to see what’s been removed or changed. It also serves as a reminder when working on later versions.
Strikethroughs help you keep track of changes more efficiently and effectively. You don’t have to worry about losing important data if it gets deleted, since it will still be visible. Plus, it helps reduce confusion when collaborating with others.
From my experience, Excel strikethrough once saved me from a major problem during a project presentation. With two other team members, we had been working on it for weeks. While checking the final version, I noticed some data was missing. By using strikethroughs on an older version, we realised one of us had accidentally removed it without realising how significant it was.
Indicating Out-of-Date Information with Strikethrough.
Strikethrough is an Excel feature that is helpful for quickly showing data that is outdated. It comes in handy when dealing with large amounts of info. Here’s how to use strikethrough to mark out-of-date data:
- Select the cell or range.
- Right-click and pick “Format Cells”.
- Go to the “Font” tab.
- Check the “Strikethrough” box under “Effects.”
- Click “OK”.
Strikethrough is a great way to scan through data quickly and easily find issues. It also provides a visual cue that the data isn’t current, without needing to read the contents of each cell.
It can also be used to show an option is no longer valid. For example, if one pricing option is no longer available,
strikethrough can indicate this.
It’s important to be consistent when using
strikethrough. Consider adding a legend or key to explain why something is struck through.
FAQs about How To Strikethrough In Excel
1. How to Strikethrough in Excel?
To strikethrough text in Excel, follow these simple steps:
- Select the cell(s) or range that you want to strikethrough
- Click on the Home tab on the ribbon
- Click on the Font Dialog Box Launcher (small icon) in the bottom right corner of the Font group
- In the Font tab of the dialog box, check the Strikethrough box and click OK
2. Can I use a keyboard shortcut to strikethrough text in Excel?
Yes, you can use a keyboard shortcut to strikethrough text in Excel. Here is the shortcut:
CTRL + 5
3. Can I strikethrough individual words in a cell?
Yes, you can strikethrough individual words in a cell. Simply select the word(s) within the cell, and follow the same steps as mentioned earlier to apply strikethrough formatting.
4. How do I remove strikethrough formatting in Excel?
To remove strikethrough formatting in Excel, select the cell or range of cells that contain the strikethrough formatting, click on the Font Dialog Box Launcher, and uncheck the box next to Strikethrough.
5. Can I apply strikethrough formatting to numbers and symbols in Excel?
Yes, you can apply strikethrough formatting to numbers and symbols in Excel, just like you would apply it to text. Simply select the cell(s) or range and follow the steps mentioned earlier to apply the strikethrough formatting.
6. Is it possible to automate the strikethrough formatting of cells in Excel?
Yes, you can automate the strikethrough formatting of cells in Excel by using conditional formatting. Here are the steps:
- Select the cell(s) or range that you want to apply the strikethrough formatting to
- Click on the Home tab on the ribbon and click on Conditional Formatting
- Select New Rule and choose Use a formula to determine which cells to format
- In the formula field, enter =LEN(A1)>0 (change A1 to the first cell in your range)
- Click on the Format button and go to the Font tab
- Check the Strikethrough box and click OK
- Click OK again to apply the rule
Nick Bilton is a British-American journalist, author, and coder. He is currently a special correspondent at Vanity Fair.