Understanding the Context

Why Strikethrough Formatting Matters in Excel

Before diving into the shortcut, let’s highlight why strikethrough formatting is valuable:

• Visually indicate completed, canceled, or obsolete entries
  
• Improve data clarity for reports, invoices, task lists, and tracking sheets
  
• Save time over manually clicking formatting menus or right-clicking

Key Insights

Instead of struggling through mid-click sequences, mastering the right keyboard shortcut transforms how you edit transparent data directly.

The Ultimate Strikethrough Shortcut You’ve Been Missing

What’s the Shortcut?

The fastest way to apply strikethrough formatting in Excel is:
Ctrl + 5

Yes—just press Ctrl + 5 while your cursor is positioned on the cell or cells you want to format. Instantly, your selected range gets a light, dashed line beneath the text, visually signaling “strikethrough.”

Final Thoughts

How It Works

• Ctrl + 5 applies strikethrough formatting permanently to selected cells.
  
• Works same on blank cells or when editing existing text.
  
• Integrates seamlessly with Excel’s Quick Access Toolbar (QAT) for faster access once set up.

How to Set Up the Strikethrough Shortcut for Quick Access

To make the shortcut even easier to use daily:

1. Customize your Quick Access Toolbar:
   

   • Click the ↑ arrow on QAT.
     
   • Choose More Commands.
     
   • Search for “Strikethrough” (or “Bold+Strikethrough” if grouped).
     
   • Add it to QAT for one-click formatting.

2. Assign a keyboard shortcut (via Excel Options):
   While Excel doesn’t support changing Ctrl + 5 via settings directly, you can use third-party tools like AutoHotkey to create a keyboard shortcut that runs Ctrl+5. This is ideal for power users who want hotkeys tailored to their workflow.