Strikethrough in Excel & Word helps to delete it (Strikethrough Shortcut in Excel). An example sometimes, while creating a document we don’t need a few texts we can just delete it. But when we want to show the unwanted text we used the Strikethrough text option. This option will let the text remain where it is. But simply it will put a horizontal stroke on the text. This will describe that the text is no longer need or relevant.
There are various shortcuts assign to each function in MS Office. Strikethrough too is assigned some shortcuts. This makes our work easy and saves time. There are lots more shortcuts in Excel. Click here
How to do Strikethrough In Excel
There is no icon for this function or option in any of the ribbon in Excel. You need to go through a few steps to assign Strikethrough in Excel:
- Step 1: Select the cell or range of cells you want to Strikethrough in Excel.
- 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.
- Step 3: Go to the Font tab in the Format Cell dialog box.
- Step 4: In the effects, put a tick on Strikethrough.
Result: You will see a horizontal strike on the text in the cell. i.e ( E̶x̶a̶m̶p̶l̶e̶ )
However, this procedure would be too time-consuming. So the shortcut to Strikethrough the text is Excel is PRESS CTRL+5.
You can learn such tips & tricks in our Free Excel Course Lessons
Procedure: Select the cell or range of cell and Press the Strikethrough Shortcut CTRL+5
How to do Strikethrough in Word
Now, Steps to assign Strikethrough in Word:
- Step 1: Select the text or texts and click on the Strikethrough button which is available in Home Tab, Font group
- Step 2: CTRL+D(Opens the Format cell dialog box)
- Step 3: ALT+K (Tick on Strikethrough)
- Step 4: ENTER.
You can even customize or put a strikethrough button on your ribbon. You can put this button on Quick Access Toolbar. Also, whenever you want to put a strike on non-adjacent cells in Excel. You press the Ctrl key and select the cell and then press the Shortcut CTRL+5.
Strikethrough Shortcut Key for Excel or Word
Excel has a keyboard shortcut for strikethrough as follows:
- Step 1: Select the cells in Excel for which you want to Strikethrough
- Step 2: Press CTRL+5 Strikethrough Shortcut Key in Excel
- Step 3: Strikethrough in excel will be applied it’s simple.
Similarly, for Microsoft Word a keyboard shortcut for Strikethrough as follows:
- Step 1: Select the word for which you want to Strikethrough
- Step 2: Press CTRL+5 as Strikethrough Shortcut Key in Word
- Step 3: Strikethrough in a word will be applied it’s simple.
Still, if you want an automatic task to create strikethrough. Click Here and Copy-Paste it. You are done with strikethrough shortcut. If you want to learn more about Excel Tips & Tricks then kindly join Excel Ninja Training Program. This training program offers high-quality video lectures and 24×7 support.
Blended Learning Best Practices (with Catlin Tucker) – SULS085
13+ Google Classroom Quick Tip Videos for Teachers
Go Global: Online Publishing for All Students – SULS084
cogu joins MIBR as manager and coach
Strategic Resources Files Mustavaara Technical Report
Ur-Energy Announces Extension of State Bond Loan and Provides Update
Pettit Marine Paint Develops the Most Effective Anti-fouling Paint to Hit the Market in Many Years – ODYSSEY® TRITON
Core Lab Reports Third Quarter 2020 Results From Continuing Operations:
A Difference-Making Disinfectant
How Car Tires Are Manufactured
5 Real World Applications of the Doppler Effect
Join Hands with Instagram’s New Algorithm to Boost Your Business’s User Engagement
BioMicrobics Acclaimed by Frost & Sullivan for Its Continuous Innovation-led Growth in the Water and Wastewater Treatment Market
SME Education Foundation Seeks Industry Involvement for Unadilla Valley High School Initiative to Create STEM Opportunities for Students
Verisem Acquires State-of-the-Art Vegetable Seed Processing Facility, Further Enhancing Capabilities
Global Synthetic and Bio Based Polypropylene Market 2020-2026 Growing Demand in the Automotive Industries
AI-Driven Dynamic Filmmaking is the Future
Growing Concerns around Global Warming Are Set to Drive Hypercar Market Forward: TMR
Angry Birds VR and Acron: Attack of the Squirrels Gear up for Halloween
This Is a $103 Billion Profit Opportunity
Power Plant Boiler Market by Type, Capacity, Technology, Fuel Type, and Region – Global Forecast to 2025
Rising Phoenix Royalties Announces Second Yoakum County, Permian Basin, Oil and Natural Gas Royalty Acquisition
Chem-Dry Grows Amid Pandemic with Signed Agreements to Open 64 New Franchises Across the Nation
Key Trends and Recent Innovations in Powder Bed Fusion, IDTechEx Identifies
Bitcoin Breaks $12K Resistance and Aims for $14K as BTC Rallies Higher in the Expense of Altcoins
Pasternack Now Offers a Broad Selection of Field Replaceable Connectors Available for Same-Day Shipment
Star Wars: Tales from the Galaxy’s Edge Gameplay Trailer Drops With November Date for Oculus Quest
Central Banks Are Getting a Prototype of CBDC
The Briefing: RVShare raises over $100M, Google disputes charges, and more
Mode Adds Bitcoin to Reserves, Joining Microstrategy and Square
Bitcoin Breaks the $12,000 Overhead Resistance; Here’s Why
Has Bitcoin met its match with this altcoin?
Syte Sees $30M Series C For Product Discovery
What could a Democrat Sweep in US Elections mean for Bitcoin?
Yearn Finance Adds GUSD Vaults and Updated Keep3r Network Details
B2BX Exchange Announces B2BX Token Buyback
Coinend: 1, 2, 3 Take off -New Gamified Crypto Prediction Platform!
GenTech Proudly Secures Deal with TruLife Distribution to Drive Growth in SINFIT Digital Sales
Coinend: 1, 2, 3, Take off – New gamified crypto prediction platform!
PayPal to allow transactions in Bitcoin, Ethereum etc. from 2021
Ripple CTO Assesses XRP as a Bridge Cryptocurrency Between CBDCs, Stablecoins, and Fiat
PayPal Introduces Crypto Trading, Plans To Start Crypto Shopping Facility
Top 10 Big Data trends of 2020
Techcrunch5 days ago
Original Content podcast: It’s hard to resist the silliness of ‘Emily in Paris’
Gaming1 week ago
‘Call of Duty: Mobile’ Season 11 Anniversary Update Is Out Now with a New Battle Pass Coming Soon, New Maps, XP Card Changes, and a Lot More
AI1 week ago
Key Challenges and Benefits of AI Chatbots: A Balanced Perspective
Startups5 days ago
Solve the ‘dead equity’ problem with a longer founder vesting schedule
1 week ago
Bitfinex launches EOS, Litecoin, and Polkadot Perpetual Swaps
AI1 week ago
Future of Contact Centers Enabling Employees to Work from Home
Startups5 days ago
Three views on the future of media startups
AI6 days ago
How AI Revolutionize the Way Video Games Developed and Played