excel

How To Cross Through Text In Excel

Jump to

    Striking through text in Excel can visually indicate items that are completed or irrelevant, but many users find the process unintuitive. This guide provides a clear, step-by-step method to apply the strikethrough format to your Excel data efficiently.

    We will also highlight how using Sourcetable, a user-friendly alternative, can significantly simplify the strikethrough process compared to traditional Excel methods.

    How to Cross Through Text in Excel

    Utilizing Excel's Strikethrough Shortcut

    To quickly cross out text or numbers in Excel, use the keyboard shortcut Ctrl + 5. This strikethrough shortcut is efficient for both Excel Online and Excel for Mac, as well as the desktop version.

    Formatting Cells for Strikethrough

    Select the cell or highlight the text you want to cross out. Then, open the Format Cells dialog box to access strikethrough customization options.

    Adding Strikethrough to Quick Access Toolbar

    For frequent use, add the strikethrough feature to your Quick Access Toolbar. This allows one-click access to cross out text in Excel cells.

    Incorporating Strikethrough into Excel Ribbon

    Customize your Excel ribbon by adding the strikethrough option. This makes the feature readily accessible within the ribbon interface.

    Automatic Strikethrough with Conditional Formatting

    Use Excel's conditional formatting to set up automatic strikethrough rules, ideal for creating interactive checklists that cross out completed tasks.

    Applying Strikethrough with VBA

    For advanced customization, apply strikethrough to cells using Visual Basic for Applications (VBA) code in Excel.

    Partial Cell Strikethrough

    Excel allows strikethrough to be applied to only part of a cell's value, providing flexibility for formatting specific sections of text or numbers.

    Common Use Cases

    • excel

      Highlighting completed tasks in a to-do list

    • excel

      Indicating obsolete data in a dataset

    • excel

      Showing corrections in a budget plan

    • excel

      Marking items out of stock in an inventory list

    • excel

      Visualizing progress in project timelines

    Excel vs Sourcetable: Streamlining Data Management

    Excel, the longstanding champion of spreadsheets, meets the modern needs of data analysis with traditional functionality. Sourcetable, however, redefines data integration, offering a centralized platform that simplifies complex data management.

    Unlike Excel, Sourcetable's native AI copilot equips users with interactive assistance. This AI-driven feature accelerates formula creation and template design, enhancing productivity and reducing the learning curve for advanced tasks.

    Sourcetable excels in aggregating data from multiple sources into a single interface. This consolidation is a significant divergence from Excel's manual data compilation, positioning Sourcetable as a solution for real-time data synthesis.

    The intuitive chat interface of Sourcetable's AI copilot sets it apart from Excel's traditional formula input methods. This innovation streamlines workflows and empowers users to harness complex functionalities with ease.

    Recommended Reading

    • How to... how to cross text in excel
    • How to... how to cross out word in excel
    • How to... how to draw a line through text in excel
    • How to... how to strikethrough text excel
    • How to... how to put a line through a word in excel
    • How to... how to do a strike through in excel
    • How to... in excel how to move to the next line


    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