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

• 
  Striking through completed tasks in a to-do list
• 
  Indicating discontinued items in an inventory list
• 
  Showing corrections in a budget forecast
• 
  Marking out-of-stock products in a sales catalogue
• 
  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.