• Dp

Easiest Way To Strikethrough Cell in Excel || How To Do A Strikethrough In Excel || dptutorials

Updated: Jun 20

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:


• Laptop: https://amzn.to/2ZLp5Fj http://fkrt.it/AM9ab_uuuN

• 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

G+: http://ift.tt/2kAOpa6

Twitter: https://twitter.com/dptutorials15

Facebook: http://ift.tt/2kfRnDi

BlogSpot: http://ift.tt/2kB14dh


Follow:

www.dptutorials.com

www.askplanner.blogspot.com


#dptutorials #Primavera #PrimaveraFree #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning


Support my blog, if you liked

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Google+ Social Icon
  • Blogger Social Icon