This short tutorial explains different ways to add, use and remove strikethrough format in Excel desktop, Excel Online and Excel for Mac.
Strikethrough Shortcut in Pages First, quit Pages if it is running on your Mac. Click on the Apple logo (in the top left corner of your screen) and choose System Preferences. Now launch Keyboard, choose Shortcuts, and click on App Shortcuts. Press the '+' button to add a new shortcut, and a new. To strike through individual words or text sections in Word, you usually select the text passage and then click the “Strikethrough” button on the menu ribbon. However, if you are working on a notebook or laptop without a mouse connected to it, you would find it easier to do this using a shortcut. Aug 31, 2017 Word provides shortcut key combinations for many different formatting options. 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. I use strikethrough so seldom that my most common method is to use the ‘format cells’ dialog. (My favorite keyboard shortcut for this is Ctrl + 1). But, since I am a big fan of keyboard shortcuts, the Ctrl + 5 method would quickly become part of my ‘toolbox’ of methods, should I start using the format more often.
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 :)
It depends on the Application as a strikethrough is a text ‘style’. But because of Mac’s, human interface design guidelines, most applications will use the standard mac text editor. So let’s look at TextEdit. All Macs should have this application.
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.
Excel strikethrough shortcut
Want to have the job done as quickly as possible? Press a hotkey or key combination.
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:
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.
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:
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':
The task can be easily accomplished with Excel Conditional Formatting:
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:
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.
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
It can also be done from the Format Cells dialog in the same way as in Excel for Windows:
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:Mac Keyboard Shortcut For Strikethrough
Humanity should be grateful for the invention of Mac hotkeys. They probably saved us thousand years of time if put together. There is something addictive in using shortcuts - the quickness, the feeling of a keyboard, the geeky confidence in your fingers when you realize “hurray it works!” Once you get hooked on shortcuts, you’ll never go back to clicking again.
Basic Mac hotkeys combinations
1. Quit all apps![]()
Sometimes an app that you thought you quit is still secretly running in the background. When your Mac lags and you need some fresh memory, you may choose to quit all apps. You probably heard of Force Quit (Cmd + Option + Esc), but it’s a too long way to do it.
Quit many apps in a row: Cmd + Tab
Then, holding down Cmd press Q to cycle between apps you need to close.
2. Delete a file completely
Dragging files to the Trash? Wait, this is not the only option. Here’s a shortcut to quickly delete unwanted files on a Mac, bypassing the Trash. Caution: there’s no way back.
To completely delete a file: Option + Cmd + Delete
Quick fact: ??
Did you know, the Command key ? symbol was borrowed from a road sign that is used across Scandinavia? Its original use is to denote tourist attractions. Early Mac models had Apple key instead of Command, but it later was changed as Steve Jobs feared that there would be too many “apples” in the OS interface. 3. Copy and paste a screenshot directly![]()
Cmd + Shift + 4 is an old classic way to make a screenshot on a Mac. But here comes the combination to take your screenshotting skills to the new level. Normally you would make a screenshot, pick it from your desktop, and only then paste it to the new location. It appears, all this time you could do it easier.
To copy-paste a screenshot: Shift + Control + Cmd + 4 4. Quickly switch to the desktop
Sometimes your screen is so obscured by windows it would take years to click through to the desktop. Thank goodness, there is a Mac keystroke combination designed for people like us: the folks who are drowning in an ocean of windows.
To remove window overload: Cmd + F3
5. Open Spotlight
Spotlight, your Mac’s internal search engine, can make your life 1000% easier. It finds files faster than Finder and intuitively predicts what are you after. To open Spotlight right on the spot (sorry for the pun), use this magic combo.
To launch Spotlight search: Cmd + Space bar Cool shortcut keys for Mac1. Invert display colors
A truly psychedelic key combination. This shortcut inverts all the colors on your Mac's screen to their opposites. Try it, and your world will never be the same. On the flip side, you can find a few practical applications for this command, for example, to adjust your screen to different lighting.
To invert colors on screen: ?md + Option + F5
2. Restore a recently closed tab
This one can be a real savior if you accidentally closed an important tab in a browser, like that pancake recipe or payment confirmation. There’s an easy Mac keyboard shortcut to restore it.
To restore a closed tab: Cmd + Shift + T Hd wallpapers for mac. 3. To shut down your Mac instantly
No, the following Mac shortcut is not about the force shutdown. It’s used when you need to quickly close all dialog windows and shut down your Mac in a legit way. Learn this one, quickly finish your work and finally go outside.
To quickly shut down a Mac: Control + Option + Command + Eject
4. Mac hot keys to invoke Siri
Among all Mac keyboard commands, this is the easiest. Since Siri’s arrival to macOS we got used to talk to Siri about weather and even ask her to play our favorite tracks on Mac. If you are using macOS Sierra or higher, you’ll enjoy the ability to summon Siri using just one hand.
To launch Siri: Cmd + Space bar A shortcut to free up space on your Mac
Well, not exactly a shortcut, but indeed the quickest way to get more storage on your Mac.
Download CleanMyMac + Install + Click Smart Scan
This combination of actions will free up dozens of gigabytes of space taken by garbage: unwanted files, system junk, app leftovers, etc. CleanMyMac removes about 54 GB of junk on an average Mac. Try and see how it cleans your Mac. Finder shortcuts
Finder is quite a resource-demanding tool. When you open a new Finder window it usually takes some time. For quicker access to your main destinations like Applications or Desktop, you can use the following shortcut combinations.
To quickly access Finder folders:
Cmd + Shift + A (for Applications)
Cmd + Shift + U (for Utilities) Cmd + Shift + D (for Desktop) Chrome shortcuts
Having hundreds of opened tabs in a browser has become a widespread syndrome nowadays. Closing tabs with a mouse is not only frustrating but also may freeze up your browser. Using a direct shortcut makes this job easy as a morning walk.
To close a current tab in Chrome: Cmd + W
To close a Chrome window: Cmd + Shift + W To open a new Chrome tab: Cmd + T
How to memorize Mac shortcuts: ??
Psychologists say you have to do something at least 3 times to put it in your long-term memory. Attach small sticky notes to the outlines of your Mac’s screen with 3 or 4 shortcuts you really want to master. Then, leave it all to your fingers. Mac shortcuts for documents1. Copy text without formatting
You want to copy a piece of the text, but the old formatting drags along with it. Now you spend more time formatting rather than actually creating a text. To strip the text from old styling, use the following Mac hotkeys combination. A very good one to stretch your fingers.
To paste text without formatting:
Hold down Shift + Option + Command and hit V 2. Paste special symbols and emojis
Probably this is the easiest documented shortcut key for a Mac. Logitech wireless solar k750 for mac. To enter special symbols, like those lamdas, tildas, and alfas, you need to press just one key. For instance, if you need to type a modified E, hold down the E key for one second and then choose among available variations that appear.
To enter an alternate character: Hold down the character key
To paste emojis in the text: Press Control + Command + Space 3. 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. Now you can use it
Strikethrough Command Windows
To apply strikethrough formatting: Cmd + Shift + X Photo editing programs for mac.
4. Quickly print documents
The next combination works for most apps that allow printing. You don’t need to figure out where the print dialogue is located in every case. Just memorize this quick combination and send your files to print from anywhere.
To invoke a print dialogue: Cmd + P Mac shortcuts to delete many files at once
Acrobat for mac torrent. There comes a time when you need to do a spring cleaning on your Mac: sort out old garbage, move photos to an external drive, or clean up your old downloads. It is time-consuming and takes an immense willpower simply to start. But lucky you are: there are a few shortcuts to remove large heaps of files as quickly as if you had a machete.
To select folder contents: Cmd + A
To delete a group of files after selection: Cmd + Delete To empty the Trash: Cmd + Shift + Delete If you’ve got many files left after backing up, this will save you a good deal of time moving them to the Trash bin. Textedit Strikethrough
To save you from a headache, there are apps that will do the mundane deletion job in an instant. CleanMyMac is perhaps the most reliable one. It has a tool that specifically searches for Large & Old files on your drive for a quick cleanup. CleanMyMac is available for a free download. So, check it out.
This was our take on most useful keyboard shortcuts for Mac. Thanks for reading. Below you'll find a few more links about Mac and productivity.
These might also interest you:Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |