This window is a bit different than in Excel and Word. Hit Ctrl + 1 (Control + 1 for Mac users) to access the Format Cells window, but don’t forget to select the cells you wish to strikethrough first. Keep in mind, this is only an option for PC users. If you want to remove the strikethrough press the shortcut again or hit Ctrl + Z. Select one or more cells you wish to strikethrough and press Ctrl + 5. However, if I just click in the cell (without selecting any text), I can apply the formatting to the entire cell - formatting options are allowed then.
When I push the Home button, everything is greyed out. strikethrough, bold) only selected text in a cell in Excel, but it won't let me.
So, let’s see how to apply the shortcuts. In Excel on Sharepoint, I am trying to format (e.g. And yes, Excel has its own version of the Font dialog box which is called Format Cells. Excelīy now, it’s not hard to guess that there are two methods/shortcuts to apply strikethrough in Excel. And drag the AutoFill Handle over to other cells. Offset is the function that’s not available in Word and the shortcut for it is Alt + E.Įxtra Shortcuts: You can also press Ctrl + Shift + F or Ctrl + Shift + P to access the Font dialog box. Function StrikeThrough (R As Range) As Integer If R.Count 1 Then StrikeThrough R.Font.StrikeThrough End Function /vb 5 back to the current worksheet, then type the following formula in a blank cell, and then press Enter key. hasstrikethrough (B1) Hope this helps / Lars-Åke. Then just use the following formula in cell A1 and copy it down in column A as far as you have data in column B. I would like to return a true or false in column A on the same row. Strikethrough is Alt + K and all the other shortcuts are as described in the previous section with one exception. In reply to Philip Bendalls post on July 26, 2012. Press Ctrl + T (cmd+T on a Mac) to access the Font dialog box and, same as with Word, press Alt + the corresponding letter.