Excel shortcuts

The best Microsoft Excel shortcuts for strikethrough

If you're like most people, you probably use Microsoft Excel for a variety of tasks. Whether you're tracking your personal finances, managing a small business, or working on a complex data analysis, Excel is a powerful tool that can help you get the job done.

One of the things that makes Excel so powerful is its ability to apply formatting to your data. This can help you to make your data more readable, and to highlight important information. One of the most useful formatting options is strikethrough.

Strikethrough is a way to format text so that it appears with a line through the middle. This can be useful for indicating that something is no longer relevant, or for drawing attention to a change.

Applying strikethrough formatting in Excel is easy. Just select the cells you want to format, and then press Ctrl+5 (PC) or Command+5 (Mac). This will apply strikethrough to the selected cells.

If you want to remove strikethrough formatting, just select the cells again and press Ctrl+5 (PC) or Command+5 (Mac). This will toggle the strikethrough off.

There are a few other things to know about using strikethrough in Excel. First, you can't strikethrough cells that contain formulas. This is because the formula would be disrupted if you applied strikethrough formatting.

Second, you can't strikethrough cells that are merged. This is because strikethrough only works on individual cells, and not on merged cells.

Finally, you can't strikethrough cells that are locked. This is because locked cells can't be edited, and strikethrough is a way to indicate that a cell has been edited.

Now that you know how to use strikethrough in Excel, you can start using it to format your data. Just remember to keep these things in mind, and you'll be able to use strikethrough like a pro!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.