fanssraka.blogg.se - Keyboard shortcut for strikethrough in excel

#Keyboard shortcut for strikethrough in excel how to#
#Keyboard shortcut for strikethrough in excel free#

If the strikethrough format is one you’ll be using frequently, you may want to access it a bit more quickly.

Method 3: Add to Quick Access Toolbar (QAT)

When you click OK, the selected cell(s) will have the displayed text formatted with the strikethrough effect.

You will see a preview of the strikethrough format in the Preview section of the window.

This will open the Format Cells dialog box, from which you can select the Strikethrough checkbox.

Go to the Home tab on the ribbon and click on the Font Settings button within the Font command group.

Select the cell(s) which should have the strikethrough format.

It’s at the bottom right corner of the Font tab, and it says Font Settings when you hover over it.If that’s one too many shortcuts, and you’re not willing to memorize it, follow these steps instead: The picture in step 4 above shows the button that you need to click.

If you have never used one of the small buttons on the ribbon to open a dialog box, then you may be having trouble finding it. Other Microsoft office programs like Microsoft Word, Microsoft Outlook, and Microsoft Powerpoint will also let you use the strikethrough option to format text. The fastest way to select all of the cells in your spreadsheet is to press Ctrl + A on your keyboard, or to click the gray button above the row 1 heading and to the left of the column A heading. Note that you can format cells in other ways, too when multiple cells are selected. Simply select the cells that you want to strikethrough in Excel 2013, then use the menu option or the keyboard shortcut option described above.

#Keyboard shortcut for strikethrough in excel how to#

While we focus specially on how to apply the strikethrough effect to a single cell in our guide above, the same options can be used for multiple cells at once. Since getting to the Font dialog box to locate the strikethrough text option is a little cumbersome, then this keyboard shortcut is especially useful if you are going to format cells in this way on a regular basis.

#Keyboard shortcut for strikethrough in excel free#

You can still use strikethrough text or numbers in formulas, so feel free to draw a line through any text in Excel that you might be considering removing, or that other viewers might want to ignore.Īs mentioned above, the keyboard shortcut to strikethrough text is Ctrl + 5. Strikethrough in Excel is particularly useful as a visual aid. Additional Information on How to Format Cells with Strikethrough in Excel Is there a lot of formatting applied to your spreadsheet that you don’t want? Rather than changing each individual formatting option, learn how to clear cell formatting in Excel 2013 and save yourself some time and frustration. That is the keyboard shortcut for Strikethrough in Excel 2013. You will just want to click the box to remove the check mark.Īdditionally, the strikethrough effect can be applied or removed by simultaneously pressing the Ctrl + 5 keys on your keyboard. You can use these same steps to remove strikethrough in a cell. Our guide below will show you how to find the strikethrough option both through the ribbon, as well as a shortcut that you can use to quickly draw or remove a line through cell data.

The strikethrough effect is particularly helpful when you are working with data in a spreadsheet, so you might be looking for a way to use that formatting option in Excel 2013. It provides you with a way to visually delete or mark information as something that is not important, but it allows you to keep it around so that readers can still see it, or in case you decide later that you need it. The strikethrough effect is a helpful thing to use when you are creating documents. Microsoft Excel has a large number of different ways to adjust the appearance of data in your cells, and the strikethrough formatting is one of those options, though it can be tough to find. The ability to strikethrough in Excel can come in handy when you need to format cells text in Excel in a way that keeps that text in the spreadsheet, but indicates that it should be ignored.