Command For Strikethrough Mac

This short tutorial explains different ways to add, use and remove strikethrough format in Excel desktop, Excel Online and Excel for Mac.

Excel is great for manipulating numbers, but it does not always make clear how to format text values the way you want. Strikethrough is a vivid example.

It is super easy to cross out text in Microsoft Word - you simply click the strikethrough button on the ribbon. Naturally, you'd expect to see the same button on the Excel ribbon. But it's nowhere to be found. So, how do I strikethrough text in Excel? By using any of the six methods described in this tutorial :)

  • How to do strikethrough in Excel

Key Command For Strikethrough Mac

How to strikethrough in Excel

To ensure that everyone is on the same page, let's define the term first. What does it mean to strikethrough in Excel? Simply, to put a line through a value in a cell. There are a handful of different ways to do this, and we are going to begin with the fastest one.

However, by default, MS Word does not provide shortcut for strikethrough command. Even though strikethrough is an often used command, it is surprising that Microsoft has not created a shortcut key for strikethrough. But the good thing is that we can customize MS Word to create such a shortcut key combination. Strikethrough Shortcut in Google Docs. For Mac: Highlight the word or phrase you want to strikethrough and push Command + Shift + X. Double-check that your highlighted text now as a line through it. For Windows and Linux: Highlight the word or phrase you want to strikethrough and push Alt + Shift + 5. Double-check that your highlighted text now.

Excel strikethrough shortcut

Want to have the job done as quickly as possible? Press a hotkey or key combination.

One common formatting attribute that does not have such a combination is strikethrough. Most people add it by displaying the Font dialog box and then selecting Strikethrough in the Effects area of the dialog box. You can define your own shortcut key for strikethrough by customizing Word. All you need to do is follow these steps. Apr 17, 2013  I use a lot of strike-through during my day (well, hopefully I do as I get things done!). Here’s a couple of keyboard short-cuts for strike-through on MS Office products: OneNote: Ctrl + – Excel: Ctrl + 5 Word: Ctrl + D (font menu) then Alt + K (tick strike-through) then. Example of a strikethrough: Line on Text. In this article, I’m going to focus on how to add strikethrough on a text in Microsoft Word for both Windows and Mac. The strikethrough command on Word Ribbon. Unlike Microsoft Excel, Word has the strikethrough icon on the ribbon under the Home tab. To paste emojis in the text: Press Control + Command + Space. Enter a strikethrough text on a Mac. You won’t believe, but 8000 people are googling how to do a strikethrough text on a Mac everyday. Although some applications don’t support it, this combination well works in TextEdit and Word. Easy Strikethrough Hello all, there is a very simple way to make a shortcut for the 'strikethrough text' command in Leopard 1) Open System Preferences and open the Keyboard & Mouse section 2) Switch to the Keyboard Shortcuts tab - Here you will see a list of all the keyboard shortcuts available 3) click the + button in the bottom left.

Here's the keyboard shortcut to strikethrough in Excel: Ctrl + 5

The shortcut can be used on an entire cell, certain part of the cell contents, or a range of cells.

To apply the strikethrough format to a cell, select that cell, and press the shortcut:

To draw a line through all values in a range, select the range:

To strikethrough non-adjacent cells, select multiple cells while holding the Ctrl key, and then press the strikethrough shortcut:

To cross out part of the cell value, double-click the cell to enter the Edit mode, and select the text you want to strikethrough:

Apply strikethrough via cell format options

Another quick way to draw a line through a cell value in Excel is by using the Format Cells dialog. Here's how:

  1. Select one or more cells on which you want to apply the strikethrough format.
  2. Press Ctrl + 1 or right-click the selected cell(s) and choose Format Cells… from the context menu.
  3. In the Format Cells dialog box, go to the Font tab, and tick off the Strikethrough option under Effects.
  4. Click OK to save the change and close the dialog.

Add a strikethrough button to Quick Access Toolbar

If you think that the above method requires too many steps, add the strikethrough button to the Quick Access Toolbar to always have it at your fingertips.

  1. Click the small arrow in the upper left corner of the Excel window, and then click More Commands…
  2. Under Choose commands from, select Commands Not in the Ribbon, then select Strikethrough in the list of commands, and click the Add button. This will add Strikethrough to the list of commands on the right pane, and you click OK:

Look at the upper left corner of your worksheet again, and you will find the new button there:

Put a strikethrough button onto Excel ribbon

If your Quick Access Toolbar is reserved only for the most frequently used commands, which strikethrough is not, place it onto the ribbon instead. As with QAT, it's also one-time setup, performed in this way:

  1. Right-click anywhere on the ribbon and select Customize the Ribbon… from the pop-up menu:
  2. Since new buttons can only be added to custom groups, let's create one. For this, select the target tab (Home in our case) and click the New Group button. Then, click Rename… to name the newly created group to your liking, say My Formats:
  3. With the new group selected, perform the already familiar steps: under Choose commands from, select Commands Not in the Ribbon, find Strikethrough in the list of commands, select it, and click Add:
  4. Click OK to save the changes, and find the Strikethrough button on your Excel ribbon:

You can now cross out text in Excel with a single button click! And it will also remind you the keyboard shortcut in case you forget it :)

Tip. By using Up and Down arrows in the Excel Options dialog box, you can move your custom group with the Strikethrough button to any position on the ribbon:

How to strikethrough automatically with conditional formatting

In case you are planning to use a strikethrough to cross out the completed tasks or activities in a checklist or to-do list, you may want Excel to do it for you automatically as you enter some text in a related cell, for example 'done':
Ps1 emulator mac high sierra.

The task can be easily accomplished with Excel Conditional Formatting:

  1. Select all the cells you want to cross out on condition (A2:A6 in this example).
  2. On the Home tab, in the Styles group, click Conditional Formatting > New Rule…
  3. In the New Formatting Rule dialog box, select Use a formula to determine which cells to format.
  4. In the Format values where this formula is true box, enter the formula that expresses the condition for your topmost cell:

    =$B2='Done'

  5. Click the Format…
  6. In the Format Cells dialog box, switch to the Font tab and select the Strikethrough Optionally, you can make some other formatting changes, e.g. set a light grey font color for crossed out entries:
  7. Click OK to close the Format Cells dialog box, then click OK one more time to close the New Formatting Rule window, and you are all set!

Instead of defining a task status with text, you can insert checkboxes, link them to some cells (which you can hide later) and base your conditional formatting rule on the value in the linked cells (TRUE is a checkbox is checked, FALSE if not checked).

As the result, Excel will check off the completed tasks automatically depending on whether the checkbox is selected or not.

If you'd like to create something similar in your worksheets, the detailed steps can be found here: How to create a checklist with conditional formatting.

Add strikethrough with a macro

If you are not allergic to using VBA in your Excel worksheets, you can apply strikethrough on all selected cells with this line of code:

The step-by-step instructions on how to insert VBA code in Excel can be found here.

How to use strikethrough in Excel Online

In Excel Online, the strikethrough option is exactly where you'd expect to find it - next to the other formatting buttons on the Home tab, in the Font group:
Autocad for mac for students.

However, there's a fly in the ointment - it's not possible to select non-adjacent cells or ranges in Excel Online. So, if you need to cross out multiple entries in different parts of your sheet, you will have to select each cell or a range of contiguous cells individually, and then click the strikethrough button.

Mac

The strikethrough shortcut (Ctrl + 5) works perfectly in Excel Online too and is often the fastest way to toggle the strikethrough formatting on and off.

How to strikethrough in Excel for Mac

A quick way to strikethrough text in Excel for Mac is by using this keyboard shortcut: ⌘ + SHIFT + X

Shortcut For Crossing Out

It can also be done from the Format Cells dialog in the same way as in Excel for Windows:

  1. Select the cell(s) or part of a cell value you wish to cross out.
  2. Right-click the selection and chose Format Cells from the popup menu.
  3. In the Format Cells dialog box, switch to the Font tab and select the Strikethrough checkbox:

How to remove strikethrough in Excel

The correct way to remove strikethrough from a cell depends on how you've added it.

Remove strikethrough added manually

If you applied strikethrough via a shortcut or cell format, then press Ctrl + 5 again, and the formatting will be gone.

A longer way would be opening the Format Cells dialog (Ctrl + 1) and unchecking the Strikethrough box there:

Remove strikethrough added with conditional formatting

If strikethrough is added by a conditional formatting rule, then you need to remove that rule to get rid of strikethrough.

To have it done, select all the cells from which you want to remove strikethrough, go to the Home tab > ­ Styles group, and click Conditional Formatting > Clear Rules > Clear Rules from Selected Cells:

If some other conditional formatting rule(s) is applied to the same cells and you'd like to keep that rule, then click conditional Formatting > Manage Rules… and delete only the strikethrough rule.

For more information, please see How to delete conditional formatting rules in Excel.

That's how you can add and remove the strikethrough formatting in Excel. I thank you for reading and hope to see you on our blog next week!

You may also be interested in:

To use a keyboard shortcut, press and hold one or more modifier keys and then press the last key of the shortcut. For example, to use Command-C (copy), press and hold the Command key, then the C key, then release both keys. Mac menus and keyboards often use symbols for certain keys, including modifier keys:


On keyboards made for Windows PCs, use the Alt key instead of Option, and the Windows logo key instead of Command.

Some keys on some Apple keyboards have special symbols and functions, such as for display brightness , keyboard brightness , Mission Control, and more. If these functions aren't available on your keyboard, you might be able to reproduce some of them by creating your own keyboard shortcuts. To use these keys as F1, F2, F3, or other standard function keys, combine them with the Fn key.

Cut, copy, paste, and other common shortcuts

  • Command-X: Cut the selected item and copy it to the Clipboard.
  • Command-C: Copy the selected item to the Clipboard. This also works for files in the Finder.
  • Command-V: Paste the contents of the Clipboard into the current document or app. This also works for files in the Finder.
  • Command-Z: Undo the previous command. You can then press Shift-Command-Z to Redo, reversing the undo command. In some apps, you can undo and redo multiple commands.
  • Command-A: Select All items.
  • Command-F: Find items in a document or open a Find window.
  • Command-G: Find Again: Find the next occurrence of the item previously found. To find the previous occurrence, press Shift-Command-G.
  • Command-H: Hide the windows of the front app. To view the front app but hide all other apps, press Option-Command-H.
  • Command-M: Minimize the front window to the Dock. To minimize all windows of the front app, press Option-Command-M.
  • Command-O: Open the selected item, or open a dialog to select a file to open.
  • Command-P: Print the current document.
  • Command-S: Save the current document.
  • Command-T: Open a new tab.
  • Command-W: Close the front window. To close all windows of the app, press Option-Command-W.
  • Option-Command-Esc: Force quit an app.
  • Command–Space bar: Show or hide the Spotlight search field. To perform a Spotlight search from a Finder window, press Command–Option–Space bar. (If you use multiple input sources to type in different languages, these shortcuts change input sources instead of showing Spotlight. Learn how to change a conflicting keyboard shortcut.)
  • Control–Command–Space bar: Show the Character Viewer, from which you can choose emoji and other symbols.
  • Control-Command-F: Use the app in full screen, if supported by the app.
  • Space bar: Use Quick Look to preview the selected item.
  • Command-Tab: Switch to the next most recently used app among your open apps.
  • Shift-Command-5: In macOS Mojave, take a screenshot or make a screen recording. In earlier macOS versions, use Shift-Command-3 or Shift-Command-4 for screenshots. Learn more about screenshots.
  • Shift-Command-N: Create a new folder in the Finder.
  • Command-Comma (,): Open preferences for the front app.

Sleep, log out, and shut down shortcuts

You might need to press and hold some of these shortcuts for slightly longer than other shortcuts. This helps you to avoid using them unintentionally.

  • Power button: Press to turn on your Mac or wake it from sleep. Press and hold for 1.5 seconds to put your Mac to sleep.* Continue holding to force your Mac to turn off.
  • Option–Command–Power button* or Option–Command–Media Eject : Put your Mac to sleep.
  • Control–Shift–Power button* or Control–Shift–Media Eject : Put your displays to sleep.
  • Control–Power button* or Control–Media Eject : Display a dialog asking whether you want to restart, sleep, or shut down.
  • Control–Command–Power button:* Force your Mac to restart, without prompting to save any open and unsaved documents.
  • Control–Command–Media Eject : Quit all apps, then restart your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them.
  • Control–Option–Command–Power button* or Control–Option–Command–Media Eject : Quit all apps, then shut down your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them.
  • Shift-Command-Q: Log out of your macOS user account. You will be asked to confirm. To log out immediately without confirming, press Option-Shift-Command-Q.

* Does not apply to the Touch ID sensor.

Finder and system shortcuts

  • Command-D: Duplicate the selected files.
  • Command-E: Eject the selected disk or volume.
  • Command-F: Start a Spotlight search in the Finder window.
  • Command-I: Show the Get Info window for a selected file.
  • Command-R: (1) When an alias is selected the Finder: show the original file for the selected alias. (2) In some apps, such as Calendar or Safari, refresh or reload the page. (3) In Software Update preferences, check for software updates again.
  • Shift-Command-C: Open the Computer window.
  • Shift-Command-D: Open the desktop folder.
  • Shift-Command-F: Open the Recents window, showing all of the files you viewed or changed recently.
  • Shift-Command-G: Open a Go to Folder window.
  • Shift-Command-H: Open the Home folder of the current macOS user account.
  • Shift-Command-I: Open iCloud Drive.
  • Shift-Command-K: Open the Network window.
  • Option-Command-L: Open the Downloads folder.
  • Shift-Command-N: Create a new folder.
  • Shift-Command-O: Open the Documents folder.
  • Shift-Command-P: Show or hide the Preview pane in Finder windows.
  • Shift-Command-R: Open the AirDrop window.
  • Shift-Command-T: Show or hide the tab bar in Finder windows.
  • Control-Shift-Command-T: Add selected Finder item to the Dock (OS X Mavericks or later)
  • Shift-Command-U: Open the Utilities folder.
  • Option-Command-D: Show or hide the Dock.
  • Control-Command-T: Add the selected item to the sidebar (OS X Mavericks or later).
  • Option-Command-P: Hide or show the path bar in Finder windows.
  • Option-Command-S: Hide or show the Sidebar in Finder windows.
  • Command–Slash (/): Hide or show the status bar in Finder windows.
  • Command-J: Show View Options.
  • Command-K: Open the Connect to Server window.
  • Command-L: Make an alias of the selected item.
  • Command-N: Open a new Finder window.
  • Option-Command-N: Create a new Smart Folder.
  • Command-T: Show or hide the tab bar when a single tab is open in the current Finder window.
  • Option-Command-T: Show or hide the toolbar when a single tab is open in the current Finder window.
  • Option-Command-V: Move: Move the files in the Clipboard from their original location to the current location.
  • Command-Y: Use Quick Look to preview the selected files.
  • Option-Command-Y: View a Quick Look slideshow of the selected files.
  • Command-1: View the items in the Finder window as icons.
  • Command-2: View the items in a Finder window as a list.
  • Command-3: View the items in a Finder window in columns.
  • Command-4: View the items in a Finder window with Cover Flow.
  • Command–Left Bracket ([): Go to the previous folder.
  • Command–Right Bracket (]): Go to the next folder.
  • Command–Up Arrow: Open the folder that contains the current folder.
  • Command–Control–Up Arrow: Open the folder that contains the current folder in a new window.
  • Command–Down Arrow: Open the selected item.
  • Right Arrow: Open the selected folder. This works only when in list view.
  • Left Arrow: Close the selected folder. This works only when in list view.
  • Command-Delete: Move the selected item to the Trash.
  • Shift-Command-Delete: Empty the Trash.
  • Option-Shift-Command-Delete: Empty the Trash without confirmation dialog.
  • Command–Brightness Up: Turn target display mode on or off.
  • Command–Brightness Down: Turn video mirroring on or off when your Mac is connected to more than one display.
  • Option–Brightness Up: Open Displays preferences. This works with either Brightness key.
  • Control–Brightness Up or Control–Brightness Down: Change the brightness of your external display, if supported by your display.
  • Option–Shift–Brightness Up or Option–Shift–Brightness Down: Adjust the display brightness in smaller steps. Add the Control key to this shortcut to make the adjustment on your external display, if supported by your display.
  • Option–Mission Control: Open Mission Control preferences.
  • Command–Mission Control: Show the desktop.
  • Control–Down Arrow: Show all windows of the front app.
  • Option–Volume Up: Open Sound preferences. This works with any of the volume keys.
  • Option–Shift–Volume Up or Option–Shift–Volume Down: Adjust the sound volume in smaller steps.
  • Option–Keyboard Brightness Up: Open Keyboard preferences. This works with either Keyboard Brightness key.
  • Option–Shift–Keyboard Brightness Up or Option–Shift–Keyboard Brightness Down: Adjust the keyboard brightness in smaller steps.
  • Option key while double-clicking: Open the item in a separate window, then close the original window.
  • Command key while double-clicking: Open a folder in a separate tab or window.
  • Command key while dragging to another volume: Move the dragged item to the other volume, instead of copying it.
  • Option key while dragging: Copy the dragged item. The pointer changes while you drag the item.
  • Option-Command while dragging: Make an alias of the dragged item. The pointer changes while you drag the item.
  • Option-click a disclosure triangle: Open all folders within the selected folder. This works only when in list view.
  • Command-click a window title: See the folders that contain the current folder.
  • Learn how to use Command or Shift to select multiple items in the Finder.
  • Click the Go menu in the Finder menu bar to see shortcuts for opening many commonly used folders, such as Applications, Documents, Downloads, Utilities, and iCloud Drive.

Document shortcuts

The behavior of these shortcuts may vary with the app you're using.

  • Command-B: Boldface the selected text, or turn boldfacing on or off.
  • Command-I: Italicize the selected text, or turn italics on or off.
  • Command-K: Add a web link.
  • Command-U: Underline the selected text, or turn underlining on or off.
  • Command-T: Show or hide the Fonts window.
  • Command-D: Select the Desktop folder from within an Open dialog or Save dialog.
  • Control-Command-D: Show or hide the definition of the selected word.
  • Shift-Command-Colon (:): Display the Spelling and Grammar window.
  • Command-Semicolon (;): Find misspelled words in the document.
  • Option-Delete: Delete the word to the left of the insertion point.
  • Control-H: Delete the character to the left of the insertion point. Or use Delete.
  • Control-D: Delete the character to the right of the insertion point. Or use Fn-Delete.
  • Fn-Delete: Forward delete on keyboards that don't have a Forward Delete key. Or use Control-D.
  • Control-K: Delete the text between the insertion point and the end of the line or paragraph.
  • Fn–Up Arrow: Page Up: Scroll up one page.
  • Fn–Down Arrow: Page Down: Scroll down one page.
  • Fn–Left Arrow: Home: Scroll to the beginning of a document.
  • Fn–Right Arrow: End: Scroll to the end of a document.
  • Command–Up Arrow: Move the insertion point to the beginning of the document.
  • Command–Down Arrow: Move the insertion point to the end of the document.
  • Command–Left Arrow: Move the insertion point to the beginning of the current line.
  • Command–Right Arrow: Move the insertion point to the end of the current line.
  • Option–Left Arrow: Move the insertion point to the beginning of the previous word.
  • Option–Right Arrow: Move the insertion point to the end of the next word.
  • Shift–Command–Up Arrow: Select the text between the insertion point and the beginning of the document.
  • Shift–Command–Down Arrow: Select the text between the insertion point and the end of the document.
  • Shift–Command–Left Arrow: Select the text between the insertion point and the beginning of the current line.
  • Shift–Command–Right Arrow: Select the text between the insertion point and the end of the current line.
  • Shift–Up Arrow: Extend text selection to the nearest character at the same horizontal location on the line above.
  • Shift–Down Arrow: Extend text selection to the nearest character at the same horizontal location on the line below.
  • Shift–Left Arrow: Extend text selection one character to the left.
  • Shift–Right Arrow: Extend text selection one character to the right.
  • Option–Shift–Up Arrow: Extend text selection to the beginning of the current paragraph, then to the beginning of the following paragraph if pressed again.
  • Option–Shift–Down Arrow: Extend text selection to the end of the current paragraph, then to the end of the following paragraph if pressed again.
  • Option–Shift–Left Arrow: Extend text selection to the beginning of the current word, then to the beginning of the following word if pressed again.
  • Option–Shift–Right Arrow: Extend text selection to the end of the current word, then to the end of the following word if pressed again.
  • Control-A: Move to the beginning of the line or paragraph.
  • Control-E: Move to the end of a line or paragraph.
  • Control-F: Move one character forward.
  • Control-B: Move one character backward.
  • Control-L: Center the cursor or selection in the visible area.
  • Control-P: Move up one line.
  • Control-N: Move down one line.
  • Control-O: Insert a new line after the insertion point.
  • Control-T: Swap the character behind the insertion point with the character in front of the insertion point.
  • Command–Left Curly Bracket ({): Left align.
  • Command–Right Curly Bracket (}): Right align.
  • Shift–Command–Vertical bar ( ): Center align.
  • Option-Command-F: Go to the search field.
  • Option-Command-T: Show or hide a toolbar in the app.
  • Option-Command-C: Copy Style: Copy the formatting settings of the selected item to the Clipboard.
  • Option-Command-V: Paste Style: Apply the copied style to the selected item.
  • Option-Shift-Command-V: Paste and Match Style: Apply the style of the surrounding content to the item pasted within that content.
  • Option-Command-I: Show or hide the inspector window.
  • Shift-Command-P: Page setup: Display a window for selecting document settings.
  • Shift-Command-S: Display the Save As dialog, or duplicate the current document.
  • Shift–Command–Minus sign (-): Decrease the size of the selected item.
  • Shift–Command–Plus sign (+): Increase the size of the selected item. Command–Equal sign (=) performs the same function.
  • Shift–Command–Question mark (?): Open the Help menu.

Other shortcuts

For more shortcuts, check the shortcut abbreviations shown in the menus of your apps. Every app can have its own shortcuts, and shortcuts that work in one app might not work in another.

Keyboard Command For Strikethrough Mac

  • iTunes shortcuts: Choose Help > Keyboard shortcuts from the menu bar in iTunes.
  • Other shortcuts: Choose Apple menu > System Preferences, click Keyboard, then click Shortcuts.

Command For Strikethrough Mac

Learn more

  • Create your own shortcuts and resolve conflicts between shortcuts
  • Change the behavior of the function keys or modifier keys