Have you ever wanted to emphasize certain data in your Excel spreadsheet in a unique way? I sure have! One way to achieve this is by using the strikethrough feature in Excel. It’s a simple yet effective way to visually indicate changes or updates to your data. Let me show you how to do it.
Using Strikethrough in Excel
To apply the strikethrough format to a cell or a range of cells in Excel, start by selecting the cell(s) you want to format. Then, right-click and choose “Format Cells” from the context menu. In the Format Cells dialog box, go to the “Font” tab.
Next, you’ll see a checkbox for “Strikethrough” under the Effects section. Check this box and click “OK” to apply the strikethrough format to the selected cells. Voila! The content in the cell(s) will now have a line through the center, indicating that it’s been crossed out or updated.
If you’re a fan of keyboard shortcuts like I am, you’ll be pleased to know that there’s a quick way to apply strikethrough in Excel. With the cell(s) selected, simply press
Ctrl + 5 to toggle the strikethrough format on and off.
Now that you’ve mastered the art of applying strikethrough in Excel, go ahead and give it a try in your own spreadsheets. It’s a handy formatting option that can add clarity and visual impact to your data.
Using strikethrough in Excel can be a game-changer when it comes to highlighting changes or updates in your data. It’s a feature that I personally find incredibly useful, and I hope you will too. With just a few clicks or a simple keyboard shortcut, you can make your data stand out in a meaningful way. Happy formatting!