In this tutorials, let us learn the easiest way to strikethrough any cell in Excel.
I will be showing some examples here, see how am I striking all the cells here.
Keyboard Shortcut to strikethrough text in cell is Ctrl+5.
Generally, people will be applying this strikethorugh by going to format cells and go to font and then apply the strikethrough effect.
Now, let us use this strikethrough option based on a condition.
In this example, let us strikethough the State name whenever the status column is filled with completed.
1. Select the entire range of State names, where I would like to apply the formatting.
2. Click on conditional formatting, click on New rule
3. Select the option 'use a formula to determine which cells to format'
4. In the formula bar, type as F5="Completed"
5. Click on Format button
6. Go to font tab and tick the checkbox 'strikethrough' under effects and click on Ok
7. Click ok.
Now let us type completed in cell F5 and see that the State Andhra pradesh is getting strikethrough.
Try entering in more cells in column F and see that the state names getting strikethrough.
So friends, this is the Easiest Way To Strikethrough Cell in Excel.
Watch this video tutorial for better understanding:
For Personalized detail learning, write to dptutorials15@gmail.com
If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.
***********************************************
★ My Online Tutorials ► https://www.dptutorials.com
LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources
Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2
Support the Channel via shopping: http://ift.tt/2jH38PR
Tools for youtube vlogging:
• Canon 200D Camera: https://amzn.to/3d7jDR4 http://fkrt.it/AMz75_uuuN
• Benro Tripod: https://amzn.to/3exQoax http://fkrt.it/An1lm_uuuN
• Microphone: https://amzn.to/3c5lEvS http://fkrt.it/A2RHz_uuuN
• Collar Microphone: https://amzn.to/2X8DWrS http://fkrt.it/yL8kdQNNNN
• Screen recorder: https://techsmith.pxf.io/2BMjA
• Boom Arm Stand: https://amzn.to/3extb87 http://fkrt.it/ypUD8QNNNN
• Zoom H1 Audio Recorder: https://amzn.to/2TNdHFj http://fkrt.it/ypb7WQNNNN
• Harison Softbox Studio Lights: https://amzn.to/3caGbzg http://fkrt.it/ypCaRQNNNN
• Chroma Key Green Screen: https://amzn.to/2M60mn4 http://fkrt.it/A3gnb_uuuN
• Background Support Stand: https://amzn.to/3dbACSv http://fkrt.it/A3cCb_uuuN
• Acoustic Foam Background: https://amzn.to/3gzFtyC http://fkrt.it/ypsGdQNNNN
• USB RGB LED Strip: https://amzn.to/36BpCLF http://fkrt.it/A3T_5_uuuN
• Wireless Mouse: https://amzn.to/2TPIrW7 http://fkrt.it/A3Bqz_uuuN
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
***********************************************
You Can Connect with Me at:
YouTube: http://www.youtube.com/c/dptutorials
Twitter: https://twitter.com/dptutorials15
Facebook: http://ift.tt/2kfRnDi
BlogSpot: http://ift.tt/2kB14dh
Follow:
#dptutorials #Primavera #PrimaveraFree #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning
Comments