Use strikethrough to mark tasks done in Excel

If you use Microsoft Excel to track tasks, you'll probably want to use Strikethrough to mark them as complete. Alas, the Strikethrough command does not appear conveniently on the Font section of the Ribbon as it does in Microsoft Word.

There are three quick ways to access it.

1) The fastest is the Shortcut key: Ctrl-5. (That's a number five.)

2) If you're going to adjust the font or format of a cell anyway, you could right-click it, select Format Cells, and then click the Strikethrough box under Effects:

clip_image002

3) Create your own handy Strikethrough button. Click the icon at the far right of the Quick Access Toolbar to open this list:

clip_image003

Select More Commands and then, in the Choose commands from dropdown list, select Commands Not in the Ribbon. Scrolls down until you find Strikethrough, select it, click the Add button, and then OK.

clip_image005

Now you have a Strikethrough button that is always just a click away.

Suzanne