Removing visual clutter from spreadsheet data is often necessary to maintain professionalism or to indicate completed tasks. In Microsoft Excel, the most efficient way to achieve this is by applying a strikethrough format, which draws a line through the center of the text. This guide provides a detailed walkthrough of how to line through text in Excel, covering both keyboard shortcuts and menu adjustments for various operating systems.
Applying Strikethrough with Keyboard Shortcuts
For users seeking speed, keyboard shortcuts offer the fastest method to apply a line through text. The process differs slightly depending on whether you are using Windows or Mac.
Windows Users
Select the cell or range of cells containing the text you wish to modify. Press and hold the Ctrl key, then press the 5 key. You may need to press the key on the numeric keypad; if your keyboard lacks a dedicated numeric pad, try Shift + Alt + 5 .
Mac Users
Mac users can achieve the same result by selecting the text and pressing Command + Shift + X . This shortcut toggles the strikethrough on and off instantly, allowing for quick corrections without navigating through menus.
Using the Font Dialog Box
For users who prefer a visual approach or need to adjust multiple formatting options simultaneously, the Font dialog box provides granular control. Begin by selecting the cells with the text you want to modify. Right-click on the selection and choose "Format Cells," or press Ctrl + 1 on Windows or Command + 1 on Mac.
In the Format Cells window, navigate to the "Font" tab. Locate the "Effects" section and check the box labeled "Strikethrough." Confirm your changes by clicking "OK." This method is particularly useful when you are already adjusting other properties like font style or color.
Utilizing the Home Ribbon
The Home tab in the Excel ribbon offers a direct button for users who prefer tool-based interaction. After selecting the target cell, navigate to the "Home" tab in the top menu ribbon. Within the "Font" group, you will find an icon that resembles the letter "AB" with a horizontal line through the center.
Clicking this icon will instantly apply or remove the strikethrough effect. This interface is ideal for beginners who are still becoming familiar with Excel’s extensive library of keyboard shortcuts.
Managing Multiple Formats with Format Painter
If your document requires consistency across multiple cells or sections, the Format Painter tool is indispensable. First, select the cell that already has the strikethrough format applied. Click on the "Format Painter" icon in the Home tab, which will change your cursor to a paintbrush.
Drag this brush over the cells you wish to update. The formatting, including the line through the text, will be copied exactly. To apply multiple formats without returning to the original cell, double-click the Format Painter icon and click on each target cell individually before pressing Esc to exit the mode.
Customizing the Quick Access Toolbar
Frequent users of the strikethrough function might find it beneficial to add the command to the Quick Access Toolbar. By default, this toolbar sits above the ribbon, housing the save, undo, and redo functions.
Click the downward arrow next to the toolbar and select "More Commands." In the Excel Options window, choose "Commands Not in the Ribbon" from the list, locate "Strikethrough," and add it to your toolbar. This customization streamlines the workflow, allowing you to apply the line with a single click regardless of which tab is currently active.
