In the format cells box, under effects, click strikethrough. Select the cells or part of a cell value you wish to cross out. Save the workbook and reopen it in excel for the web to see the changes. Add bold, italic, underline, and strikethrough to text in pages on mac. Select the cells containing the data you want to format. However, there is no icon in excel ribbon to do this. If you are using word for mac, strikethrough is accessible through the following shortcut. Use this keyboard shortcut for strikethrough text in excel. It can also be done from the format cells dialog in the same way as in excel for windows. This is especially true for strikethrough fortunately, adding strikethrough in excel is super easyonce you know how to do it. Strikethrough in excel cell keyboard shortcut and examples.
A quick way to strikethrough text in excel for mac is by using this keyboard shortcut. While your mouse is over the selected text, rightclick and then select format cells from the popup menu. In numbers on your mac, make text bold or italic, underline it, or strike through it. In excel 2008, strikethrough is also available in the font section of the formatting palette. Want to apply a strikethrough effect to text in excel. And, if you are using mac then you can use the shortcut key. Add bold, italic, underline, and strikethrough to text in numbers on mac. This can either be the entire cell or only a character in the cell. To change all of the text in a text box or table cell, select the text box or table cell. Draw a line through a value in a cell strikethrough this excel tutorial explains how to draw a line through a value ie.
In word 20 and 2010 and 2007, striking through text is easy and obvious. In this article, we will look at how to use strikethrough in. A quick way to strikethrough text in excel for mac is by using this. In this tutorial, i will share various ways to access the strikethrough option and apply it to text in excel. Strikethrough cell contents in excel online, excel on windows or macos, and even in excel on android or ios devices. Please mark yesno as to whether a reply answers your question. Excel strikethrough shortcut using your ribbon guide pc only. How to strikethrough using a keyboard shortcut on a mac.
This shortcut toggles strikethrough on and off for the current selection. As an mvp my contributions here are purely voluntary. How to strikethrough text in best writing apps mac and. When the format cells window appears, select the font tab. Add bold, italic, underline, and strikethrough to text in pages on mac select the text you want to change. Now, highlight the text you want to apply strikethrough on. Select the cells that you want to strikethrough in your spreadsheet.
1557 301 1516 801 659 446 1420 922 1347 1052 13 1159 666 961 953 243 1473 383 1424 1440 799 809 938 1613 1445 1342 594 1516 418 1351 917 766 19 352 667 763 1407 373 317 1099 516 251 464 598 783