17 Add Strikethrough Excel Tips for Cleaner Spreadsheets

To add strikethrough excel text, the format can be applied directly to cell contents, making outdated values visually distinct while preserving underlying data. For example, marking a budget line as "$5,000" with a strikethrough instantly signals a revised amount without deleting the original entry.

Applying strikethrough in Excel improves data clarity, supports audit trails, and aligns with best practices for version control in financial models and project trackers. Historically, spreadsheet users relied on manual annotations; modern formatting tools now embed visual cues directly, reducing errors and enhancing collaboration across teams.

This article walks through core techniques, from keyboard shortcuts to VBA scripts, and offers troubleshooting tips for large datasets, mobile apps, and web-based Excel environments.

1. Add Strikethrough Excel

• Keyboard Shortcut

  Press Ctrl+5 after selecting a cell to toggle strikethrough instantly. In a sales report, this shortcut allowed the finance team to flag discontinued products without altering the underlying calculations.

• Format Cells Dialog

  Right‑click a cell, choose Format Cells → Font, then check the Strikethrough box. This method is useful when applying the style to a single cell that already contains custom font settings.

• Quick Access Toolbar

  Adding the Strikethrough command to the toolbar provides a one‑click solution. A project manager customized the toolbar to streamline status updates across weekly sprint sheets.

• Conditional Formatting

  Use a rule that applies strikethrough when a condition, such as a date older than today, is met. This automated approach kept a task list current without manual edits.

2. Keyboard Shortcuts

• Ctrl+5 Toggle

  The universal shortcut works across Windows and macOS versions of Excel, ensuring consistency for multinational teams.

• Alt+H, F, S Sequence

  Navigate the ribbon via Alt keys: Alt+H opens Home, F selects Font, and S toggles strikethrough. This sequence is handy when the toolbar lacks the command.

• Custom Macro Shortcut

  Assign a macro that adds strikethrough to Ctrl+Shift+S for repetitive tasks, such as marking completed inventory items.

3. Using the Ribbon Menu

The Home tab hosts the Font group where the Strikethrough button resides. Selecting a range before clicking the button applies the style uniformly, ideal for bulk updates in large financial models.

When working with merged cells, the ribbon method respects the merge, preserving layout while still indicating deprecated entries.

4. Conditional Formatting Tricks

• Date‑Based Rules

  Set a rule that strikes through dates older than a fiscal quarter. This visual cue helped an accounting department quickly isolate stale invoices.

• Value Thresholds

  Apply strikethrough when a numeric value falls below a defined minimum, such as inventory levels under reorder points, streamlining procurement reviews.

• Text Matching

  Use a formula like =SEARCH("obsolete",A1) to strike through cells containing specific keywords, aiding content managers in cleaning up outdated catalog entries.

5. Applying to Large Ranges

For extensive datasets, selecting an entire column or using Ctrl+Shift+End to capture the used range ensures the formatting propagates efficiently. Leveraging Excel’s Fill Handle after applying strikethrough to the first cell copies the style down without manual re‑selection.

When performance slows, converting the range to a Table and applying a style rule reduces calculation overhead, maintaining responsiveness even in worksheets with tens of thousands of rows.

6. VBA Automation

Writing a simple VBA subroutine—Sub ApplyStrike() : Selection.Font.Strikethrough = True : End Sub—automates the process for repetitive reporting cycles. Companies integrating this macro into monthly close procedures cut manual formatting time by half.

Advanced scripts can loop through a column, applying strikethrough only when a related status column equals "Closed," providing dynamic visual management for ticketing systems.

7. Mobile and Web Excel

On the Excel mobile app, the formatting pane includes a Strikethrough toggle, enabling on‑the‑go edits for field agents updating expense reports directly from tablets.

Web‑based Excel mirrors desktop functionality; however, keyboard shortcuts differ slightly (Cmd+5 on macOS browsers). Awareness of these nuances ensures consistent presentation across platforms.

Frequently Asked Questions

Common queries about adding strikethrough in Excel are addressed below.

Question 1: Can strikethrough be applied to entire rows automatically?

Yes, by selecting the row and using either the keyboard shortcut Ctrl+5 or a conditional formatting rule that references a status column, the strikethrough effect can be applied to all cells in that row simultaneously.

Question 2: Does strikethrough affect cell calculations?

No, the visual formatting does not alter the underlying value or any formulas referencing the cell, ensuring that financial computations remain accurate while the display indicates deprecated data.

Question 3: How to remove strikethrough from multiple cells at once?

Select the range, then press Ctrl+5 again or clear the Font → Strikethrough option in the Format Cells dialog; this toggles the style off for every selected cell in a single action.

Question 4: Is strikethrough available in older Excel versions?

Versions dating back to Excel 2003 include the Strikethrough command in the Font dialog and support the Ctrl+5 shortcut, though the Quick Access Toolbar customization may differ.

Question 5: Can a macro apply strikethrough based on a specific condition?

Yes, VBA can evaluate cell values and apply Selection.Font.Strikethrough = True when conditions such as "Status = Completed" are met, enabling automated visual cues during data processing.

Question 6: Does the web version retain strikethrough after saving?

The web version saves all formatting, including strikethrough, to the workbook file; when opened later in desktop Excel, the formatting persists unchanged.

Tips

Quickly access the Strikethrough command by adding it to the Quick Access Toolbar for one‑click formatting.

Tip 1: Use Ctrl+5. This shortcut toggles strikethrough instantly for any selected cell range.

Tip 2: Apply via Format Cells. The Font tab offers a reliable method when shortcuts are unavailable.

Tip 3: Leverage conditional formatting. Automate visual cues based on dates, values, or text matches.

Tip 4: Create a macro. Record a simple VBA routine to apply strikethrough across repetitive tasks.

Tip 5: Use the Fill Handle. After formatting one cell, drag the handle to copy the style efficiently.

Tip 6: Convert to a Table. Tables streamline bulk formatting and improve performance on large datasets.

Tip 7: Customize the ribbon. Add the Strikethrough button to a new group for faster access.

Tip 8: Apply to entire columns. Selecting a column before formatting ensures consistency for future entries.

Tip 9: Use Alt shortcuts. Navigate Home → Font → Strikethrough with Alt+H, F, S on keyboard‑only setups.

Tip 10: Preserve calculations. Remember that visual formatting never alters underlying formulas.

Tip 11: Check mobile UI. The Excel app places the Strikethrough toggle in the formatting pane for on‑the‑go edits.

Tip 12: Verify web compatibility. Ensure that browser‑based Excel reflects the same formatting after saving.

Tip 13: Use named ranges. Apply strikethrough to named ranges for clearer macro references.

Tip 14: Combine with color. Pair strikethrough with gray font color to emphasize deprecated items.

Tip 15: Document standards. Include strikethrough usage guidelines in spreadsheet SOPs for team consistency.

Tip 16: Test on a copy. Apply new formatting rules to a duplicate workbook to avoid unintended changes.

Tip 17: Refresh pivot tables. After applying strikethrough to source data, refresh pivots to reflect updated visual cues.

Conclusion

The methods outlined—keyboard shortcuts, ribbon commands, conditional formatting, VBA automation, and cross‑platform considerations—equip users to add strikethrough excel formatting efficiently across varied scenarios. By integrating these techniques, spreadsheets become more readable, audit‑ready, and visually organized.

Future Excel releases may introduce smarter AI‑driven suggestions for deprecated data, but mastering the current tools ensures immediate productivity gains and cleaner data presentation today.