Where Is My Strikethrough in Excel? Finding and Applying This Formatting Feature

So, you’re working on a spreadsheet, maybe a budget, a project plan, or even a simple to-do list, and you need to strike through some text. You know, that classic way to visually indicate something is completed, void, or no longer relevant. You’ve probably used it before, and now you’re staring at your screen, brow furrowed, thinking, “Where is my strikethrough in Excel?” It’s a surprisingly common question, and honestly, I’ve been there myself. You’re not alone! It’s not as obvious as bold or italics, and sometimes, in the rush of data entry, those little formatting buttons can feel like they’ve vanished into thin air.

The good news is that strikethrough is absolutely present and accounted for in Excel. It’s a handy tool for visual clarity and organization within your spreadsheets. This article will guide you through the various ways to find and apply the strikethrough formatting, ensuring you can efficiently mark up your data and convey information effectively. We’ll dive deep into the ribbon, explore dialog boxes, and even touch upon a quicker keyboard shortcut. By the end of this, you’ll be a strikethrough pro, never again wondering, “Where is my strikethrough in Excel?”

Understanding the Strikethrough Functionality in Excel

Before we start hunting, it’s useful to understand what strikethrough actually does in Excel. Essentially, it’s a font effect that draws a horizontal line through the center of selected text. Its primary purpose is to visually distinguish content without deleting it. Think of it as a digital highlighter for items you want to note as finished, cancelled, or superseded. This can be incredibly useful for:

Task Completion Tracking: Marking off completed tasks in a project plan or to-do list.
Price Comparisons: Showing an original price that has been superseded by a sale price.
Drafting and Revision: Indicating text that has been removed or altered during a document’s revision process.
Highlighting Obsolete Data: Visually setting aside information that is no longer relevant to the current analysis.

The beauty of strikethrough in Excel is that it’s a formatting option. This means the underlying data remains intact. You can easily toggle the strikethrough on and off, or even remove it altogether, without losing the original text. This non-destructive nature is what makes it such a valuable tool for data management and presentation.

Finding Strikethrough on the Excel Ribbon: The Primary Location

For most users, the first place they’ll look for formatting options is the Excel ribbon. And you’d be right to do so! The strikethrough option is indeed nestled within the ribbon, although it’s not as prominently displayed as some other common formatting tools. Here’s precisely where to find it:

Select the Cell(s): First, you’ll need to select the cell or range of cells containing the text you want to apply strikethrough to.
Navigate to the “Home” Tab: Ensure you are on the “Home” tab of the Excel ribbon. This is usually the default tab when you open Excel.
Locate the “Font” Group: Within the “Home” tab, look for the “Font” group. This section contains most of the standard text formatting options like font type, size, color, bold, italics, and underline.
The “More Font Options” Dialog Box: Now, this is where the strikethrough hides. You won’t find a dedicated button for strikethrough directly on the ribbon. Instead, you need to click the small, diagonal arrow icon in the bottom-right corner of the “Font” group. This little arrow is the “Dialog Box Launcher” for the Font settings.
Apply Strikethrough: Once the “Format Cells” dialog box opens, navigate to the “Font” tab (it should be the default). Here, you’ll see a list of “Underline” options and, crucially, a checkbox labeled “Strikethrough” under the “Effects” section. Simply check this box.
Confirm: Click “OK” to apply the strikethrough formatting to your selected cells.

I remember the first time I really needed to use strikethrough extensively. I was organizing a massive inventory list, and I wanted to visually track which items had been sold. I spent a good ten minutes clicking around the Home tab, feeling increasingly frustrated. “Where is my strikethrough in Excel?” I muttered to myself. It wasn’t until I noticed that tiny little arrow in the corner of the Font group that it clicked. It’s a classic case of a useful feature being tucked away just a little too neatly for its own good!

Using the “Format Cells” Dialog Box: A Comprehensive Approach

The “Format Cells” dialog box, which we accessed via the dialog box launcher, is the most comprehensive way to apply strikethrough and other advanced formatting. It’s the central hub for all things related to how your text and numbers look in Excel.

Here’s a more detailed breakdown of navigating the “Format Cells” dialog box for strikethrough:

Accessing the Dialog Box: As mentioned, you can click the dialog box launcher in the Font group on the Home tab. Alternatively, you can right-click on the selected cell(s) and choose “Format Cells…” from the context menu. Another common method is to use the keyboard shortcut Ctrl + 1 (or Cmd + 1 on a Mac). This is a speedier way to get there once you’re familiar with it.
The “Font” Tab: Within the “Format Cells” window, ensure you are on the “Font” tab. This tab governs all aspects of your font’s appearance.
Font Styles and Sizes: You can adjust your font style (e.g., Arial, Calibri), font size, and font color here. This is useful if you want to make the strikethrough text stand out even more, perhaps in a different color or a smaller font.
Underline Options: Below the font style and size, you’ll see the “Underline” section. While strikethrough isn’t technically an underline, it’s often grouped conceptually with these line-based formatting effects.
The “Strikethrough” Checkbox: Directly below the “Underline” dropdown, you’ll find the “Strikethrough” checkbox. It’s usually clearly labeled. Tick this box to enable the effect.
Preview Window: As you make selections, notice the “Preview” window at the bottom of the dialog box. This is incredibly helpful! It shows you exactly what your selected text will look like with the chosen formatting applied, including the strikethrough. This ensures you’re applying exactly what you intend.
Applying the Changes: Once you’ve checked the “Strikethrough” box and are happy with the preview, click the “OK” button. Your selected cells will now display the text with a line through it.

I find myself using the Ctrl + 1 shortcut constantly. It’s become second nature. When I need to apply strikethrough, or any other font formatting for that matter, my fingers just naturally go to that key combination. It saves so much time compared to navigating through the ribbon, especially when dealing with multiple cells or complex formatting adjustments. It really underscores how a little bit of knowledge about shortcuts can dramatically improve your Excel workflow.

Keyboard Shortcut for Strikethrough: The Speedy Route

While there isn’t a direct, single keyboard shortcut to *apply* strikethrough like there is for bold (Ctrl+B) or italics (Ctrl+I), there’s a fantastic shortcut to access the dialog box where strikethrough resides. As mentioned earlier, this is Ctrl + 1 (or Cmd + 1 on a Mac).

Here’s how you can leverage this for quick strikethrough application:

Select the Cell(s): Highlight the cells you wish to format.
Press Ctrl + 1: This immediately opens the “Format Cells” dialog box.
Navigate to the Font Tab: The “Font” tab should already be active. If not, click on it.
Use Tab and Arrow Keys (Optional but efficient): Once the dialog box is open, you can use the Tab key to cycle through different sections and controls, and the arrow keys to select options. For example:
- Press Tab until you reach the “Effects” section.
- Use the down arrow key to highlight “Strikethrough.”
- Press the Spacebar to check or uncheck the box.
Press Enter: Once the “Strikethrough” box is checked, press Enter (or click “OK” with the mouse) to apply the formatting.

This method might seem like a few more steps than a direct shortcut, but it’s significantly faster than clicking through the ribbon. It’s the closest thing to a dedicated keyboard shortcut for strikethrough, and for anyone who spends a lot of time in Excel, mastering this little sequence can make a noticeable difference in your efficiency. It’s a small victory, but it adds up!

Applying Strikethrough to Multiple Cells or Ranges

The beauty of Excel’s formatting tools is their ability to work on multiple selections simultaneously. Applying strikethrough to a single cell is straightforward, but what if you have a whole column of tasks to mark as done, or a block of text that needs to be indicated as removed?

The process is the same, regardless of the number of cells involved:

Select the Entire Range: Use your mouse to drag and highlight all the cells you want to apply strikethrough to. This could be a contiguous block (e.g., A1:A10) or even non-contiguous cells by holding down the Ctrl key (or Cmd on Mac) while clicking on individual cells or selecting multiple ranges.
Use Your Preferred Method: Once the range is selected, you can then use either:
- The “Font” dialog box launcher on the ribbon.
- The Ctrl + 1 (or Cmd + 1) keyboard shortcut.
Check the Strikethrough Box: In the “Format Cells” dialog box, navigate to the “Font” tab, find the “Strikethrough” checkbox under “Effects,” and tick it.
Confirm: Click “OK.”

Excel will then apply the strikethrough formatting to every cell within your selected range. This is incredibly powerful for bulk operations. I often use this when cleaning up imported data where certain fields consistently need to be marked as obsolete. Selecting the whole column and applying strikethrough in one go saves me hours of manual work.

Conditional Formatting: Automating Strikethrough

While manually applying strikethrough is effective, there are times when you want the formatting to be applied automatically based on certain conditions. This is where Excel’s Conditional Formatting feature shines. Imagine you want any task in your to-do list to automatically get a strikethrough when you type “Done” in an adjacent status column.

Here’s how you can set up conditional formatting to achieve this:

Select the Cells to Format: Highlight the cells where you want the strikethrough to appear. For example, if your task descriptions are in Column A and your status is in Column B, you would select the range of cells in Column A that you want to format (e.g., A2:A100).
Go to the “Home” Tab: On the ribbon, click the “Home” tab.
Click “Conditional Formatting”: In the “Styles” group, click the “Conditional Formatting” button.
Choose “New Rule”: From the dropdown menu, select “New Rule…”
Select Rule Type: In the “New Formatting Rule” dialog box, choose “Use a formula to determine which cells to format.” This is the most flexible option for creating custom rules.
Enter the Formula: In the “Format values where this formula is true” field, you’ll enter a formula that evaluates to TRUE when the condition for strikethrough is met. Let’s assume your status is in Column B, and you want strikethrough applied to Column A when Column B says “Done.” If your selected range for Column A starts at A2, the formula would be something like: =$B2="Done"

Explanation of the Formula:
- The $ before B ensures that the formula always checks Column B, even as it applies to different cells in Column A.
- The 2 refers to the row number of the *first* cell in your selected range (A2). Excel will automatically adjust this row number for subsequent cells in your selection (e.g., it will check B3 for A3, B4 for A4, and so on).
- ="Done" is the condition. The formula returns TRUE if the cell in Column B of the same row contains the text “Done.”

Set the Formatting: Click the “Format…” button. This opens the “Format Cells” dialog box again. Go to the “Font” tab, check the “Strikethrough” box, and click “OK.”
Confirm the Rule: Click “OK” in the “New Formatting Rule” dialog box.

Now, whenever you type “Done” (or whatever text you specified) in the corresponding cell in Column B, the text in Column A will automatically be struck through. This is incredibly powerful for dynamic spreadsheets. You can imagine extending this to auto-strike through items that have a “Cancelled” status, or perhaps items that are older than a certain date.

I find conditional formatting invaluable for managing project trackers. When a task moves to the “Completed” phase, the description automatically gets struck through. It provides an immediate visual cue without any manual intervention. It truly takes the guesswork out of things and makes the spreadsheet feel alive.

Removing Strikethrough Formatting

Just as easily as you can apply strikethrough, you can also remove it. This is important if you make a mistake, change your mind, or if the data’s status changes again.

Here are the methods to remove strikethrough:

Manually Removing:
1. Select the cell(s) with the strikethrough text.
2. Open the “Format Cells” dialog box (Ctrl + 1 or Cmd + 1).
3. Go to the “Font” tab.
4. Uncheck the “Strikethrough” box.
5. Click “OK.”
Using Conditional Formatting: If the strikethrough was applied via conditional formatting, you need to edit or delete that rule.
1. Select the cells that have the conditional formatting applied.
2. Go to “Home” tab > “Conditional Formatting” > “Manage Rules…”
3. In the “Conditional Formatting Rules Manager,” find the rule that applies strikethrough.
4. You can either edit the rule (e.g., change the condition or the formatting) or delete it entirely by selecting the rule and clicking the “Delete Rule” button.
5. Click “OK.”
Clearing Formatting: If you want to remove *all* formatting from a cell (including strikethrough, bold, color, etc.) and revert it to its default appearance, you can use the “Clear Formats” option.
1. Select the cell(s).
2. Go to the “Home” tab.
3. In the “Editing” group, click the “Clear” dropdown arrow.
4. Choose “Clear Formats.”
Caution: This will remove all formatting, so use it carefully!

I’ve accidentally applied strikethrough to the wrong cells more times than I care to admit. Thankfully, removing it is just as straightforward as applying it. The key is knowing which method you used to apply it in the first place – manual or conditional formatting – to know how to undo it effectively.

Table: Comparing Strikethrough Application Methods

To help clarify the different ways you can apply and manage strikethrough, here’s a table summarizing the methods:

Method	How to Access	Best For	Pros	Cons
Ribbon (via Font Dialog Box Launcher)	Home Tab > Font Group > Dialog Box Launcher	Quick manual application on one or a few cells.	Visually intuitive once you know where the launcher is.	Requires multiple clicks; not ideal for bulk operations or automation.
Format Cells Dialog Box (Keyboard Shortcut)	Ctrl + 1 (or Cmd + 1)	Quick manual application; efficient for users comfortable with shortcuts.	Fastest manual method; direct access to all font formatting.	Still manual; requires remembering the shortcut and navigating the dialog.
Conditional Formatting	Home Tab > Conditional Formatting > New Rule	Automated formatting based on cell values or formulas.	Dynamic and efficient for large datasets; reduces manual errors.	Requires understanding formulas and rule creation; setup time upfront.
Clear Formatting	Home Tab > Editing > Clear > Clear Formats	Removing all formatting, including strikethrough.	Quickly resets cells to default appearance.	Removes all formatting, not just strikethrough; use with caution.

This table really highlights that the “best” method often depends on your specific needs and comfort level with Excel’s features. For a quick, one-off strikethrough, the keyboard shortcut is likely your go-to. For ongoing processes or dynamic updates, conditional formatting is the clear winner.

Unique Insights: Beyond Basic Strikethrough

While the core function of strikethrough is simple – drawing a line through text – its application can be much more nuanced and insightful than you might initially think.

1. Visual Hierarchy and Emphasis: Strikethrough isn’t just for “done” items. It can be used to create a visual hierarchy. For instance, in a pricing sheet, you might show the original, higher price struck through, with the new, lower price prominently displayed next to it. This immediately draws the eye to the savings. Similarly, in a list of project requirements, you might strike through outdated or irrelevant requirements to emphasize the current ones.

2. Non-Verbal Communication in Shared Workbooks: When collaborating on spreadsheets, using strikethrough can be a form of non-verbal communication. If you’re reviewing a budget proposal and need to question or suggest removing a specific line item, striking it through can prompt discussion without necessarily deleting it. It’s a softer way of flagging something for attention compared to deleting it outright, which might feel more confrontational.

3. Creating “Ghosted” Text Effects: While Excel doesn’t have a native “ghosted text” effect like some word processors, you can mimic it to some extent. By applying a light grey font color *in addition* to the strikethrough, you can make text appear faded or less important. This could be useful for indicating historical data that is still present for reference but not currently active.

4. Combining with Other Formatting for Richer Meaning: Don’t be afraid to combine strikethrough with other formatting. For example:

Strikethrough + Grey Font: For items that are no longer active or relevant but still need to be visible for context.
Strikethrough + Italics: Perhaps to indicate a cancelled item that was originally a suggestion.
Strikethrough + Bold/Different Color: While this might seem contradictory, you could use it strategically. For example, striking through a competitor’s price and then making your own, lower price bold and in a different color to highlight your advantage.

My personal experience with strikethrough has evolved. Initially, I saw it purely as a “done” marker. But as I’ve worked with more complex datasets and collaborated more, I’ve realized its potential for conveying subtle messages about the status and relevance of information. It’s a simple tool, but with thoughtful application, it can add significant clarity and depth to your spreadsheets.

Frequently Asked Questions About Strikethrough in Excel

Let’s address some common questions that often arise when users are trying to figure out the strikethrough feature.

How do I quickly apply strikethrough to a single cell?

The quickest way to apply strikethrough to a single cell involves using the keyboard shortcut to open the “Format Cells” dialog box. First, select the cell you want to format. Then, press Ctrl + 1 (or Cmd + 1 on a Mac). This will instantly bring up the “Format Cells” window. Make sure you’re on the “Font” tab. You’ll see a checkbox labeled “Strikethrough” under the “Effects” section. Simply click this checkbox to enable it, and then click “OK.” While it’s not a single keystroke like bold or italics, this two-step process (Ctrl+1, then Spacebar/Enter) is very fast once you get used to it.

Alternatively, if you prefer using the mouse, you can select the cell, then click the small dialog box launcher arrow in the bottom-right corner of the “Font” group on the “Home” tab of the ribbon. Once the “Format Cells” dialog box opens, navigate to the “Font” tab, check the “Strikethrough” box, and click “OK.” Both methods achieve the same result, but the keyboard shortcut is generally favored by those looking for maximum efficiency.

Why can’t I find a strikethrough button directly on the ribbon?

Excel’s ribbon interface is designed to prioritize the most frequently used commands directly. Features that are used less often, or those that have multiple options (like different types of underlining or font effects), are often grouped within dialog boxes. Strikethrough falls into this category. Instead of dedicating a button on the already crowded “Home” tab for a less common font effect, Microsoft has placed it within the “Format Cells” dialog box. This allows for a cleaner ribbon interface while still providing easy access to the feature through the dialog box launcher or keyboard shortcuts. It’s a design choice aimed at balancing accessibility with screen real estate. Many users find that once they know the shortcut (Ctrl+1) or where to find the dialog box launcher, the absence of a direct button becomes a non-issue.

Can I apply strikethrough to text within a single cell, not the whole cell?

Yes, absolutely! This is a very useful feature that many users overlook. If you want to apply strikethrough to only a portion of the text within a cell, follow these steps:

Double-click the cell to enter “Edit Mode” or select the cell and press F2. This allows you to edit the cell’s content directly.
Select the specific text within the cell that you want to apply strikethrough to.
Now, use your preferred method:
- Click the dialog box launcher for the “Font” group on the “Home” tab.
- Press Ctrl + 1 (or Cmd + 1).
In the “Format Cells” dialog box, go to the “Font” tab and check the “Strikethrough” box.
Click “OK.”

The strikethrough will only be applied to the text you highlighted within the cell. This is incredibly handy for marking specific words or phrases as completed or void within a larger sentence or entry.

How does strikethrough work with formulas?

Strikethrough is a formatting attribute, not a calculation or a value modification. Therefore, it does not directly interact with formulas in terms of their calculation. If you apply strikethrough to a cell containing a formula, the formula will still calculate correctly. The strikethrough will simply be a visual indicator applied to the cell’s *displayed result*. For example, if cell A1 contains the formula `=SUM(B1:B5)` and you apply strikethrough to A1, the sum will still be calculated and displayed, but with a line through it. This is useful if you want to visually mark a calculation as superseded or inactive without deleting the formula itself.

However, it’s crucial to remember that strikethrough formatting itself cannot be directly referenced or used in a formula. You cannot write a formula like `=IF(A1 has strikethrough, “Yes”, “No”)`. If you need to trigger actions based on whether text should be struck through, you would typically use conditional formatting that applies the strikethrough based on a specific condition (like a status cell containing “Done”). You would then use that same condition in your formula to achieve the desired outcome.

Can I use strikethrough in Excel tables (structured tables)?

Yes, you can apply strikethrough formatting within Excel tables (also known as structured tables) just as you would in any other range of cells. Select the cells within the table that you wish to format, and then use any of the methods described previously: the “Format Cells” dialog box via the ribbon or the Ctrl + 1 shortcut. The strikethrough will be applied to the selected table cells.

If you are using conditional formatting to automatically apply strikethrough, it generally works seamlessly with tables as well. The key is ensuring that your cell references in the conditional formatting formula correctly reference the table columns and rows. For instance, if you have a table where the first column contains task names and the second column contains a status, and your table is named “TasksTable,” you might select the task name column and use a formula like `=TasksTable[Status]=”Completed”` in your conditional formatting rule. Excel is generally smart about handling these references within structured tables.

One thing to be aware of is that applying manual formatting (like strikethrough) to a table can sometimes be overridden if you later apply extensive formatting to the table itself, or if you refresh data in a way that might reset formatting. For consistent results within tables, conditional formatting is often the more robust solution.

Conclusion: Mastering the Strikethrough in Your Spreadsheets

So, there you have it. You’ve navigated the depths of Excel to uncover the elusive strikethrough formatting. Whether you were initially wondering, “Where is my strikethrough in Excel?” or simply looking for the most efficient way to apply it, you’re now equipped with the knowledge to use this valuable feature effectively. From the straightforward application via the “Format Cells” dialog box to the power of conditional formatting for automation, you have multiple avenues to visually mark up your data.

Remember that strikethrough isn’t just about crossing out text; it’s a tool for clarity, communication, and organization. By understanding its nuances and employing the methods discussed—the ribbon’s dialog box launcher, the speedy Ctrl+1 shortcut, or the dynamic power of conditional formatting—you can enhance the readability and impact of your spreadsheets. Don’t let this useful formatting effect hide in plain sight any longer. Go forth and strike through!

Where Is My Strikethrough in Excel? Finding and Applying This Formatting Feature