If you are using a Mac, it is Command Shift + X. The shortcut is Ctrl 5 when you are running Windows.
Click Add button to move the command to the toolbar. Microsoft Excel does have a keyboard shortcut that you can use for applying the strikethrough format. Select All Commands to list Strikethrough. You can add the Strikethrough command button into the Quick Access Toolbar which can be found in the top section of the Excel window.įollow the steps below to add the command into the Quick Access Toolbar: To draw a line through all values in a range of cells, select the range and press Alt + Shift + 5 on Windows, Command () + Shift + X on Mac, or Alt + Shift + 5 on ChromeOS. In Excel for Mac, hold down the (command) and shift keys, and then press X. To strikethrough a single cell, select it and press Alt + Shift + 5 on Windows, Command () + Shift + X on Mac, and Alt + Shift + 5 on ChromeOS. This will strikethrough all selected cells unless all selected cells already have strikethrough, in which case it will return them to normal. The last approach in our list is using the Quick Access Toolbar. Simply select all the cells to which you want to apply strikethrough, then hold Ctrl and press 5. If you want to access this function by using the shortcut keys, press and hold down Command Ctrl and then press the O key. For example, the Command+O Ctrl+O shortcut keys are shown next to the Open entry in the File menu. Right-click and select the Format Cells option and activate the Font tab A great deal of your applications functionality can be called up by using shortcut keys. Step 4: In the effects, put a tick on Strikethrough. Step 3: Go to the Font tab in the Format Cell dialog box. 
Step 2: In the Home Ribbon > Font Group > Click on the small arrow sign at the right bottom corner of the Font Group OR Right-click and click on Format cell. Press Ctrl + 1 and activate the Font tab Step 1: Select the cell or range of cells you want to Strikethrough in Excel.Select the cell(s) containing the text you want to format and use one of the following: You can open the Format Cells window in a few ways. You can strikethrough by enabling this from the Format Cells window, just like any other formatting option. To access the Font dialog box using a keyboard shortcut and then apply Strikethrough: Select the text you want to strikethrough. Simply press the Ctrl + 5 key combination to toggle between formatting with and without strikethrough. Let’s see how you can apply this formatting in Excel. Strikethrough is a handy formatting option to eliminate data that is not relevant anymore.
#Excel strikethrough hotkey how to
In this guide, we’re going to show you how to strikethrough in Excel. Strikethrough Shortcut in Quick Access Toolbar Strikethrough Shortcut on Ribbon Strikethrough Shortcut in Format Cells Dialogue Box Strikethrough Shortcut Keyboard Key We can use any of the above-listed strikethrough shortcuts to apply cross out or create a line through a text and values in Excel cells.
0 kommentar(er)
