Formatting text or numbers can make them appear more visible especially when you have a large worksheet. Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects. This article shows you how you can apply different formats and also undo them.
If you want text or numbers in a cell to appear bold, italic, or have a single or double underline, select the cell and on the Home tab, pick the format you want:
Feb 25, 2013 It's unclear which version of Excel you're using, but in both 2011 & 2008 you'll find Strikethrough in Format Cells Font.There's a check box in the Effects section of the dialog. In both versions you can also use the keyboard shortcut: Shift+Command+numeric keypad minus symbol (if you have a numeric keypad). In Excel 2008, Strikethrough is also available in the Font section of the. MS Excel 2011 for Mac: Draw a line through a value in a cell (strikethrough) This Excel tutorial explains how to draw a line through a value (ie: strikethrough) in a cell in Excel 2011 for Mac (with screenshots and step-by-step instructions).
Apply or remove strikethrough formatting. This shortcut toggles strikethrough on and off for the current selection. 222 Excel Shortcuts for Windows and Mac.
Change font style, size, color, or apply effects
Click Home and:
For a different font style, click the arrow next to the default font Calibri and pick the style you want.
To increase or decrease the font size, click the arrow next to the default size 11 and pick another text size.
To change the font color, click Font Color and pick a color.
To add a background color, click Fill Color next to Font Color.
To apply strikethrough, superscript, or subscript formatting, click the Dialog Box Launcher, and select an option under Effects.
Change the text alignment
You can position the text within a cell so that it is centered, aligned left or right. If it's a long line of text, you can apply Wrap Text so that all the text is visible.
Select the text that you want to align, and on the Home tab, pick the alignment option you want.
Clear formatting
Strikethrough Mac Excel
If you change your mind after applying any formatting, to undo it, select the text, and on the Home tab, click Clear > Clear Formats.
This Excel tutorial explains how to draw a line through a value (ie: strikethrough) in a cell in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Excel Strikethrough Shortcut Mac
Question: How do I draw a line through a value in a cell in Microsoft Excel 2011 for Mac? (This is also known as a strikethrough.)
Answer: Select the text that you wish to strikethrough. This can either be the entire cell or only a character in the cell. While your mouse is over the selected text, right-click and then select 'Format Cells' from the popup menu.
Mac Shortcut For Strikethrough
When the Format Cells window appears, select the Font tab. Check the Strikethrough checkbox. Click on the OK button.
Now when you return to your spreadsheet, you should see a strike through your selected text.
