Windows & Other OS

How to cross out in Microsoft Excel

Drawing a line across your text is easy with Microsoft Excel’s strikethrough option. You can use a keyboard shortcut or graphical menu to strike out the text . We will show you both methods.

How to strike through text in Excel with a keyboard shortcut

The quickest way to strike through text in Excel is to use a dedicated keyboard shortcut .

To use this method, first open your spreadsheet in Microsoft Excel. In your worksheet, click the cell where you want to apply the strikethrough.

Select a cell in Excel.

While your cell is selected, press Ctrl + 5 (Windows) or Command + Shift + X (Mac) to apply the strikethrough effect.

Apply strikethrough with a keyboard shortcut in Excel.

Your text now has a line through it. To remove the strikethrough, select its cell and press Ctrl + 5 (Windows) or Command + Shift + X (Mac).

That’s a pretty good way to draw people’s attention to certain cells. also can rotate text in its cells so that they stand out from other cells.

How to apply strikethrough from the format menu

There is also a graphical menu option to apply strikethrough to your cells.

To use it, first start your spreadsheet with Microsoft Excel. In your spreadsheet, click the cell where you want to draw a line through the text.

Select a cell.

At the top, on the Excel ribbon, click on the “Home” tab.

Click on the tab

On the “Home” tab, in the “Source” section, select the arrow icon.

A “Cell Format” window will open. Here, in the “Effects” section, enable the “Strikethrough” option. Then, at the bottom, click “OK”.

Enable

Your selected cell now has the strikethrough effect applied.

Strikethrough text in Excel.

And this is how you mark things up in your Microsoft Excel spreadsheets. Very useful!


also can strike through text in Microsoft Word .

RELATED:   How to install the new Microsoft Store in Windows 10

Related posts

Leave a Comment