Ever needed to cross something off a list in your Excel spreadsheet? Maybe you finished a task, or an item is no longer relevant. Well, I’m here to tell you it’s super easy to visually mark that text as done or obsolete using a strikethrough. You just need to select the cells you want to change, open the “Format Cells” dialog box, go to the “Font” tab, and tick the box next to “Strikethrough.” A quick click on “OK” and boom, your text is crossed out, making your spreadsheet clearer and more organized.
How to Strike Through Text in Excel: A Step-by-Step Guide
This section will walk you through the straightforward steps to apply that satisfying line through your text in Excel. It’s a fundamental skill that will help you communicate status and changes effectively within your worksheets. We’re going to break it down so you understand each part of the process.
Step 1: Select the cells you want to modify.
First things first, you need to tell Excel which text you want to strike through. Just click and drag your mouse over the cells that contain the text you wish to change. If you want to affect only a single cell, click it. It’s like highlighting the words you want to edit in a regular document.
Remember, you can select multiple cells that are next to each other, or even cells that are scattered throughout your sheet. To select non-adjacent cells, hold down the Ctrl key on your keyboard while clicking on each individual cell you want to include. This flexibility is really handy when you’re dealing with different parts of a long list.
Step 2: Open the Format Cells dialog box.
Once your cells are selected, open the “Format Cells” menu. The quickest way to do this is to right-click anywhere in your selected cells and choose “Format Cells…” from the context menu. Alternatively, you can press Ctrl + 1 on your keyboard, which is a fantastic shortcut that many Excel pros use.
This “Format Cells” dialog box is your control center for a wide range of text and cell appearance changes. It’s where you adjust fonts, colors, borders, and, of course, special effects like strikethrough. Getting comfortable with this dialog box will make you a formatting wizard in Excel.
Step 3: Navigate to the Font tab.
Inside the “Format Cells” dialog box, you’ll see several tabs across the top, like “Number,” “Alignment,” “Font,” “Border,” “Fill,” and “Protection.” We’re interested in the “Font” tab for this task, so go ahead and click on it. You can’t miss it, it’s usually the third one from the left.
The “Font” tab is where all the magic happens for changing how your text looks. Here, you can pick different font styles, sizes, and colors. It’s also where you’ll find those cool effects that really make your text stand out, or in this case, stand out by being crossed out.
Step 4: Check the “Strikethrough” box.
On the “Font” tab, look for a section labeled “Effects.” Underneath that heading, you’ll see a small checkbox labeled “Strikethrough.” Go ahead and click that box to check it. You might even see a preview of what your text will look like in the sample area of the dialog box.
This simple checkbox is the key to adding that horizontal line through your text. It’s a universally understood visual cue that indicates completion or invalidation, making your spreadsheets more expressive and easier to interpret at a glance.
Step 5: Click “OK”.
Once you’ve checked the “Strikethrough” box, confirm your choice. Find the “OK” button at the bottom right of the “Format Cells” dialog box and click it. This action will close the dialog box and apply the formatting changes to all the cells you selected back in Step 1.
And there you have it! Your chosen text will now appear with a line running right through the middle of it. This visual change instantly signals that the item is no longer active or relevant, or is simply marked as done, helping you track your progress and changes in your data.
After you complete these steps, the text in your selected cells will immediately display with a horizontal line drawn through the center. This visual cue indicates whether the item is completed, cancelled, or no longer applicable, without deleting the information.
Pro Tips for Striking Through Text in Excel
- Use Strikethrough for Task Management: If you’re using Excel for a To-Do list, applying strikethrough is a fantastic visual way to mark tasks as completed. It keeps the original task visible for reference but clearly shows its status.
- Apply to Multiple Cells at Once: Don’t waste time formatting cells individually. Select a range of cells, or an entire row or column, before opening the “Format Cells” dialog box to apply strikethrough efficiently.
- Create a Custom Style: If you frequently use strikethrough for specific data types, consider creating a custom cell style. You can include strikethrough in that style, then apply it with a single click from the “Styles” group on the Home tab.
- Conditional Formatting for Automation: For an advanced touch, use conditional formatting to automatically apply strikethrough based on a condition, like if a nearby cell says “Done” or a date has passed. This is super powerful for dynamic lists.
- Quick Access Toolbar Shortcut: You can add the “Format Cells” command directly to your Quick Access Toolbar for even faster access. This way, it’s just one click away, saving you precious seconds.
Your Top Questions About Striking Through Text in Excel, Answered!
Can I strikethrough only part of a cell’s text?
Unfortunately, no, you cannot strike through only a portion of the text within a single cell using the “Format Cells” dialog box. When applied this way, the strikethrough effect affects the entire content of the cell. If you absolutely need to strike through only part of the text, you would have to split the content into multiple cells or use a workaround like inserting a text box with a line over the specific words, which isn’t ideal for data.
Is there a keyboard shortcut for strikethrough in Excel?
While there isn’t a direct, single-key keyboard shortcut like Ctrl+B for bold, you can use an access key sequence. After selecting your cells, you can press Alt, then H (for Home tab), then F (for Font group), then N (to open Format Cells), and finally K (to toggle Strikethrough). It’s a bit of a dance, but it gets the job done without touching your mouse!
How do I remove strikethrough from text?
Removing strikethrough is just as simple as applying it. Select the cells with the strikethrough formatting, open the “Format Cells” dialog box (either by right-clicking and choosing “Format Cells” or pressing Ctrl + 1), go to the “Font” tab, and then simply uncheck the “Strikethrough” box. Click “OK” to remove the line.
Does strikethrough affect formulas or calculations?
Absolutely not! Strikethrough is purely a visual formatting effect. It doesn’t change the cell’s value or content. Any formulas that reference a cell with strikethrough text will still use the underlying data as if no formatting had been applied. It’s like changing the color of a number, the number itself remains the same.
Can I use conditional formatting to apply strikethrough automatically?
Yes, and this is a fantastic feature! You can set up a conditional formatting rule that applies strikethrough when a certain condition is met. For example, you could say, “If the value in column B is ‘Completed,’ then apply strikethrough to the corresponding cell in column A.” This automates the process and keeps your data visually up to date without manual intervention.
Quick Summary of How to Strike Through Text in Excel
- Select cells.
- Open Format Cells dialog.
- Go to Font tab.
- Check Strikethrough box.
- Click OK.
Wrapping Things Up: Mastering Strikethrough in Excel
So there you have it, folks! We’ve journeyed through the simple, yet incredibly useful, process of how to strike through text in Excel. It’s one of those little tricks that, once you know it, you’ll wonder how you ever managed without it. Think about it, in a world full of data and endless spreadsheets, clarity is king. Whether you’re tracking tasks, managing inventory, or just keeping notes, being able to visually mark something as “done” or “no longer valid” without deleting the original information is a huge win. It preserves context, which is super important when you need to look back and understand the history of your data.
This isn’t just about making things look pretty, it’s about effective communication within your spreadsheet. Imagine sharing a task list with a teammate. A quick glance at the strikethrough text tells them instantly what’s been handled, saving time and preventing confusion. We also covered some pro tips, such as using conditional formatting to automate this process. That’s where Excel really shines, letting you set up smart rules that do the work for you. No more manually crossing things out, Excel handles it based on your criteria.
I encourage you to open Excel now if you haven’t already and try these steps. Experiment with applying strikethrough to different cells, then practice removing it. Try selecting multiple cells, or even a whole column, to see how quickly you can apply the formatting. Once you’re comfortable with the basics, delve into conditional formatting. You’ll be amazed at the power it gives you to create dynamic, intelligent spreadsheets. Mastering this seemingly small feature enhances your overall Excel fluency, making your data management more efficient and your professional life a little easier. Keep exploring, keep learning, and keep making those spreadsheets work smarter for you! Now you know how to strike through text in Excel, go forth and organize with confidence.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.