How to Cross Out Text in Excel

Using Strikethrough in Excel Desktop

To apply strikethrough in the Excel desktop application, select the cell containing the text you want to strike out. Then, use the strikethrough option located next to other formatting buttons on the ribbon. Alternatively, press Ctrl + 5 on Windows or Command + Shift + X on Mac to quickly toggle strikethrough for selected cells. This formatting can be applied to multiple cell contents at once.

Copying Strikethrough Format

If you need to apply the same strikethrough format to other cells, use the format painter. This tool copies the formatting from a selected cell and applies it to others with a single click.

Strikethrough on Excel for the Web

Excel for the web currently does not offer the strikethrough formatting option. To use this feature, open your workbook in the Excel desktop application where strikethrough is available. Keep an eye on the Microsoft Excel blog for updates on Excel for the web, including new formatting features.

Common Use Cases

• 
  Tracking task completion by marking cells as completed
• 
  Indicating irrelevant or excluded data points in a dataset
• 
  Visualizing absence of data or not applicable entries
• 
  Highlighting errors or discrepancies in data for review
• 
  Organizing a checklist for event planning or project management

Excel vs Sourcetable: Streamlining Data Management

Excel, a long-standing leader in spreadsheet software, allows users to perform data analysis and visualization. However, Sourcetable offers a modern approach by integrating multiple data sources into a single platform for streamlined data queries.

Unlike Excel, Sourcetable's distinctive feature is its AI copilot. This advanced tool assists users in creating complex formulas and templates effortlessly through an intuitive chat interface, enhancing productivity and user experience.

The integration capabilities of Sourcetable set it apart, providing a unified view of data from various sources. This contrasts with Excel's more manual data consolidation methods, requiring additional steps for aggregation.

Sourcetable's AI-driven assistance is a game-changer in data handling efficiency, offering a competitive edge over traditional spreadsheet tools like Excel. It simplifies the technical aspects of data manipulation, making it accessible to a broader range of users.