Look at the below checklist where I have used a check box with conditional formatting to apply strikethrough.

Use Conditional Formatting to Apply StrikethroughĬonditional formatting is one of the best ways to apply formatting in a smart way. You can also assign it to a shape to create a button. The above code will help you to apply strikethrough on selected cells. Macro codes work like a charm and, if you want to use a VBA for strikethrough here is the code for you. Want to know the best part? You can also access other formatting options which are nowhere on the ribbon through the same. You can apply it on multiple cells and on the partial text. The steps to highlight every other row in excel by using an excel table are as follows: Step 1: Select the entire data entered in the excel sheet.

In the font tab, tick marks the strikethrough option.

Use shortcut key ctrl + 1 to open the format options.

Select all the cells on which you want to apply it.

Apply Strikethrough from Format OptionĪs I said there is no direct option in Excel for strikethrough, but actually, there’s an option that you can access from format options. You can compare data that’s in rows instead of columns using the same method, but you’ll choose Column Differences in the Go To Special window instead of Row Differences.This button also works if you want to apply it to a particular part of a text and on multiple cells. If you want to mark those differences so you can find them again, just click the Fill Color button while the cells are still selected. Each cell that is different from the first column will be selected. Press and release the Spacebar key on the keyboard. What is the shortcut key to highlight a row in Excel Use Shortcut Keys to Select Rows Press and hold the Shift key on the keyboard. Additional columns will be compared to each of the previous columns. Tip: In the above formula, B2 indicates the first cell of your selection, and B2:E2 is the first row range that you want to highlight the largest cell. Excel will compare the cells in second column to the cell on the same row in the first column. In the window that pops up, choose Row Differences and click OK. Or if you prefer to use the mouse, click the Find & Select button on the ribbon and choose Go To Special. Then press F5 or Ctrl+G (both are shortcut keys for the Go To command) and click the Special button. If they aren’t in adjacent columns, select one list, then hold down the ctrl key while highlighting the rest. Do you ever need to find the differences between two lists? There are many ways to go about doing this in Excel, but surprisingly, the GoTo command provides a really quick and easy way to accomplish this.įirst, highlight the lists that you want to compare.

Excel shortcut for highlighting row