Mastering text formatting in spreadsheet software significantly enhances data clarity, and learning how to add strikethrough in excel toolbar is a prime example. While Excel lacks a dedicated, one-click icon for this specific function on the main ribbon by default, several highly effective methods exist to apply this visual cue. This functionality is essential for indicating deprecated information, completed tasks, or price changes without deleting the original data, making it a valuable skill for both analysts and casual users.
Understanding the Strikethrough Function in Excel
The strikethrough format draws a horizontal line through the center of the cell text, serving as a visual marker that the content is no longer valid or active. Unlike deleting content, which removes information permanently, this formatting preserves the data for reference while signaling its status. It is a non-destructive editing tool that maintains the integrity of your dataset while improving readability. Many users searching for how to add strikethrough in excel toolbar are often surprised to find the command hidden within the Font dialog box rather than displayed prominently on the Home tab.
Method 1: Using the Keyboard Shortcut
The fastest and most efficient way to apply this format is by using a keyboard shortcut, bypassing the need to navigate toolbars entirely. This method works universally across all versions of Excel and requires no customization of the interface. To execute this, simply select the cell or text string you wish to modify and press the combination of Ctrl + 5 simultaneously. This shortcut directly toggles the strikethrough attribute on and off, providing instant feedback and saving significant time during data entry or review sessions.
Method 2: Accessing the Format Cells Dialog
Opening the Legacy Dialog Box
For users who prefer a visual interface or need to adjust multiple font attributes at once, the Format Cells dialog is the standard solution. The primary challenge users face when learning how to add strikethrough in excel toolbar is locating this specific command, as it is not immediately visible on the default ribbon. To open the dialog box, right-click on the selected cell and choose "Format Cells" from the context menu, or press Ctrl + 1 for a quicker keyboard-driven approach.
Applying the Format
Once the Format Cells window is active, navigate to the "Font" tab. Here, you will find a list of text modification options such as bold, italic, and underline. Scroll through the list to locate the "Strikethrough" checkbox. Click the box to enable the feature, and the preview window at the top of the dialog will immediately display the line through your text. Confirm the change by clicking "OK," and the formatting will be applied to your selected cell range.
Method 3: Customizing the Quick Access Toolbar
To streamline your workflow and make this function as accessible as a native toolbar icon, you can add the command to your Quick Access Toolbar (QAT). This customization is the definitive answer to the question of how to add strikethrough in excel toolbar for frequent users. By default, the QAT is located in the top-left corner of the Excel window, next to the ribbon file icon.
Begin by clicking the downward arrow next to the QAT. From the dropdown menu, select "More Commands..." to open the Excel Options dialog. In the "Choose commands from" dropdown, select "All Commands." Scroll down the extensive list until you find "Strikethrough." Select it and click the "Add" button to move it to your QAT panel. Click "OK" to finalize the setup, and you will now have a dedicated button for quick application.
