How To Draw A Line Through Text In Excel

Introduction

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.

While Excel requires manual formatting steps, Sourcetable's AI chatbot lets you create, format, and analyze spreadsheets through natural conversation, making tasks like this effortless. Try out Sourcetable to transform how you work with spreadsheets.

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.

Sourcetable vs Excel: A Modern Approach to Spreadsheets

Excel has been the standard for spreadsheet analysis for decades, but its complex functions and manual processes can slow down your work. Sourcetable reimagines the spreadsheet experience with AI at its core, allowing you to create, analyze, and visualize data through simple conversations with an AI assistant. Whether you're working with uploaded files or connected databases, Sourcetable eliminates the need to learn complex formulas or manual processes. Try Sourcetable today to experience how AI can answer any spreadsheet question.

AI-Powered Analysis

While Excel requires manual formula creation and feature knowledge, Sourcetable's AI chatbot handles all analysis tasks through natural conversation. Simply describe what you want to analyze, and Sourcetable does the work for you.

Data Handling

Excel struggles with large datasets and requires manual updating. Sourcetable handles files of any size and connects directly to databases, providing seamless data analysis through AI-guided interactions.

Visualization Capabilities

Instead of manually creating charts in Excel, Sourcetable's AI assistant automatically generates stunning visualizations based on your conversational requests, making data presentation effortless.

Conclusion

Strikethrough formatting in Excel helps communicate data changes and cancelled items effectively. The process requires specific steps that vary by Excel version and operating system.

Working with Excel formatting doesn't have to be complicated. Sourcetable's AI chatbot instantly answers your Excel questions and helps you create spreadsheets faster. Learn how to streamline your spreadsheet workflows with Sourcetable today.