Select cells that contain formulas that directly reference the active cell. Select all cells directly or indirectly referenced by formulas in the selection. Select all cells directly referenced by formulas in the selection. In a selected column, select the cells that do not match the value in the active cell. In a selected row, select the cells that do not match the value in the active cell. Select the array containing the active cell. With multiple cells selected, revert selection to only the active cell. If inside a table, toggle between selecting the table row and the entire row. If used inside a table, toggle between selecting the data, data and headers, and the entire column.
If used outside a table, select entire column. Shortcut Keys for Selecting Data and Cells Table 5.3 shows the shortcut keys you use to select data and cells. When more than one workbook is open, switch to the next open workbook window. Switch to next pane in a window that has been split. Move to last cell in the used range of the worksheet. Table 5.2 illustrates the shortcut keys that you use to navigate.
Table 5.1 lists the common Windows Ctrl shortcut keys. In fact, many of these keys are consistent across all Windows applications.
We hope this tutorial helps you understand how to strikethrough text in Word or Excel.Excel 2010 automatically recognizes all the Ctrl shortcut keys that were used in legacy versions of Excel. Read: Delete button does not show strikethrough when Track Changes is enabled in Word The text in the cell will have a strikethrough. Click the cell containing the text and press Ctrl + 5. The combination keys to strikethrough a text in Microsoft Excel is Ctrl + 5. In Microsoft Excel, there is a shortcut key to strikethrough text in Excel. What is the Excel shortcut for strikethrough? The combination keys to make a strikethrough in Word is pressing the combination keys Ctrl+D to open the Font dialog box will open we will explain more details in this tutorial. In Microsoft Word, there is a shortcut key to make a strikethrough in text. Shortcut keys are a combination of keys that allows users to do a command quickly. What is the shortcut for strikethrough text in Word? You will see the Strikethrough command on your Ribbon. The command will appear under the custom group. To rename the custom group, click the Rename button on the bottom left of the dialog box.Ī Rename dialog box will appear click OK.Įnsure Strikethrough is selected in the All Command list box on the left and click the Add button. On the right of the dialog box, click where you want to place the command, for example, we select Font under the Home tab in the main tab list.Ĭlick the New Group button on the bottom left of the dialog box. Still, on the left, scroll down to the Strikethrough button in the list.
On the left, select All Commands from the Choose command from the list box. If the Strikethrough button is missing, click the ribbon and select Customize the Ribbon from the menu. The other method to put a line through your text in Excel is as follows:Ĭlick the Strikethrough button in the Font group.