Excel Shortcut Strikethrough Basics
When working with Excel, it’s important to know how to use strikethrough formatting to indicate that a cell’s content is no longer relevant. Here are some basics on how to use Excel’s strikethrough formatting:
Keyboard Shortcut for Strikethrough
The quickest way to apply strikethrough formatting to a cell’s content is by using the keyboard shortcut
Ctrl + 5. Simply select the cell or range of cells you want to apply strikethrough formatting to and press
Ctrl + 5. To remove strikethrough formatting, select the cell or range of cells and press
Ctrl + 5 again.
Using the Ribbon for Strikethrough
If you prefer using the Ribbon, you can also apply strikethrough formatting by clicking on the “Font” tab and then clicking on the strikethrough button. This button looks like a letter “S” with a line through it. To remove strikethrough formatting, select the cell or range of cells and click on the strikethrough button again.
Strikethrough on Mac
If you’re using Excel on a Mac, the keyboard shortcut for strikethrough formatting is
Command + Shift + X. You can also apply strikethrough formatting using the Ribbon by clicking on the “Home” tab, clicking on the “Font” button, and then clicking on the strikethrough button. To remove strikethrough formatting, select the cell or range of cells and click on the strikethrough button again.
Overall, knowing how to use strikethrough formatting in Excel can help you better organize and communicate your data. By using keyboard shortcuts or the Ribbon, you can quickly apply and remove strikethrough formatting to your cells.
Advanced Strikethrough Techniques
Excel’s strikethrough feature is a handy tool for marking completed tasks or indicating that certain values are no longer relevant. However, there are several advanced techniques that can be used to make strikethrough even more powerful and versatile.
Format Cells Dialog Box
One way to access the strikethrough feature is through the Format Cells dialog box. This can be done by selecting the cell or cells you want to format, right-clicking, and selecting Format Cells from the context menu. In the Format Cells dialog box, navigate to the Font tab and check the Strikethrough box.
Using VBA for Strikethrough
For those who are comfortable with VBA, there are several ways to automate and customize strikethrough. One option is to create a macro that applies strikethrough to a specific range of cells. Another option is to use VBA to apply strikethrough conditionally based on certain criteria.
Conditional Formatting for Strikethrough
Excel’s conditional formatting feature can also be used to apply strikethrough to cells based on specific conditions. For example, you could apply strikethrough to cells that contain completed tasks, or to cells that contain values that are no longer relevant.
Overall, there are several ways to use strikethrough in Excel to make your spreadsheet more organized and visually appealing. By using these advanced techniques, you can take full advantage of the power and flexibility of Microsoft Excel.