excel

How To Draw A Line Through Text In Excel

Jump to

    Striking through text in Excel is a common formatting task, often used to indicate completed items or changes. This guide provides straightforward steps to draw a line through text in Microsoft Excel.

    Additionally, we'll delve into how Sourcetable presents a more user-friendly alternative for this formatting function than Excel.

    Draw a Line Through Text in Excel

    Using Strikethrough Shortcut

    To quickly draw a line through text, select the cell and press Ctrl + 5. This strikethrough shortcut is the fastest method to cross out text or numbers in Excel.

    Applying Strikethrough from the Ribbon

    Apply strikethrough format via the ribbon by selecting the cell content, navigating to the Home tab, and clicking the strikethrough button. This method works for any cell content type.

    Accessing Format Cells Dialog

    Open the Format Cells dialog by right-clicking the cell and selecting Format Cells, or use the shortcut Ctrl + 1. Under the Font tab, check the Strikethrough option.

    Adding Strikethrough to Quick Access Toolbar

    Customize the Quick Access Toolbar by adding a strikethrough button for one-click access. This streamlines the process of crossing out text in Excel.

    Using Excel Online and Excel for Mac

    Excel Online and Excel for Mac users can apply strikethrough formatting. Select the text and use the strikethrough option available within the ribbon or the shortcut keys.

    Automating with Macros

    Create a macro to apply or remove strikethrough formatting, which is ideal for repetitive tasks. Record a macro that toggles the strikethrough format for selected cells.

    Removing Strikethrough

    To remove strikethrough, use the same methods: press Ctrl + 5, use the ribbon, the Format Cells dialog, or conditional formatting to reverse the strikethrough effect.

    Common Use Cases

    • excel

      Striking through completed tasks in a to-do list

    • excel

      Indicating discontinued items in an inventory list

    • excel

      Showing corrections in a budget forecast

    • excel

      Marking out-of-stock products in a sales catalogue

    • excel

      Crossing off achieved milestones in a project timeline

    Excel vs Sourcetable: Streamlining Data Management

    Excel is a widely-used tool for data analysis, known for its versatility and comprehensive features. However, Sourcetable offers a modern approach by integrating multiple data sources into a single spreadsheet interface. This feature simplifies data management and enhances productivity.

    Unlike Excel, Sourcetable's AI copilot assists users in creating complex formulas and templates. This artificial intelligence support minimizes the learning curve and reduces the potential for human error, making it an innovative solution for data-driven tasks.

    With Sourcetable's chat interface, users can interact with the AI to streamline their workflow, a feature absent in Excel. This conversational AI makes Sourcetable accessible for users at all skill levels, providing a more intuitive experience.

    Recommended Reading

    • How to... how to put a line through a word in excel
    • How to... how to draw a line on excel
    • How to... how to make a line on excel
    • How to... how to cross through text in excel
    • How to... how to have multiple lines of text in excel cell
    • How to... how to add a vertical line in excel
    • How to... how to red line 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