excel

How To Add Strikethrough In Excel Toolbar

Jump to

    Applying a strikethrough in Excel can be an effective way to mark items as completed or to indicate edits. This formatting option is not immediately visible in the standard Excel toolbar, and many users seek guidance on how to add it for quicker access.

    Our guide will provide step-by-step instructions on customizing the Excel toolbar to include the strikethrough feature. We will also explore why using Sourcetable might offer a more straightforward solution for applying strikethrough formatting.

    How to Add Strikethrough in Excel Toolbar

    Using Keyboard Shortcut

    To quickly apply strikethrough in Excel, select the cell or text and press Ctrl+5. This is the simplest method for striking through text, making it ideal for marking completed tasks or unnecessary items.

    Quick Access Toolbar Method

    Add strikethrough to the Quick Access Toolbar for even faster formatting. Once added, a single click on the strikethrough icon applies the format. This method enhances efficiency, especially for frequent use.

    Strikethrough in Excel for the Web

    For users of Excel for the web, click the ellipsis (...) in the Home menu to access and apply the strikethrough format. This option maintains the functionality of Excel across different platforms.

    Conditional Formatting Rule

    Apply strikethrough to cells dynamically with conditional formatting rules. This feature is useful for automatically striking through items based on specific conditions, ensuring data accuracy and visual consistency.

    Applying to Checkboxes

    Strikethrough can be applied to checkboxes in Excel. This visual cue can be used to represent the completion or deactivation of an item linked to a checkbox.

    Copying Strikethrough Format

    Use the Format Painter to copy strikethrough formatting from one cell to another. This tool streamlines the process of maintaining uniformity in your document's text formats.

    Common Use Cases

    • excel

      Marking completed tasks in a project management spreadsheet

    • excel

      Indicating discontinued items in an inventory list

    • excel

      Showing corrections in a budget forecast

    • excel

      Highlighting cancelled appointments in a schedule

    • excel

      Visualizing progress in a to-do list

    Excel vs. Sourcetable: Streamlined Data Analysis

    Excel, a long-standing leader in spreadsheet software, is challenged by Sourcetable's innovative approach to data consolidation. Sourcetable's unique ability to aggregate data from multiple sources sets it apart, offering a seamless query experience for diverse datasets.

    Where Excel relies on traditional formula creation, Sourcetable introduces an AI copilot. This AI feature guides users through formula generation, template creation, and more, simplifying complex tasks within its chat interface.

    Sourcetable's edge over Excel extends to user assistance. The AI copilot in Sourcetable represents a leap in user support, providing real-time help and enhancing productivity without the steep learning curve often associated with advanced Excel functions.

    Recommended Reading

    • How to... how to strikethrough excel
    • How to... how to do a strike through in excel
    • How to... how to strikethrough text excel
    • How to... how to remove a strikethrough in excel
    • How to... how to filter strikethrough in excel
    • How to... how to strike out a word in excel
    • How to... how to add navigation bar in excel


    Sourcetable Logo

    Try Sourcetable To Get Insights From Your Data

    Ask questions about your data in a powerful spreadsheet that your whole team knows how to use.

    Drop CSV