Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel – Draw a Line through Text (Strikethrough) #shorts

Microsoft Excel Tutorial – How to draw a line through text.
Some people call it Strikethrough. Others call it crossing out text.
How can you do it in Microsoft Excel.

This short video starts with a memory aid about taking inventory with a mechanical pencil and making hashmarks. You might start with |||| to mean 4. After the 4th vertical hashmark, you cross out the lines to indicate 5. It is the 5th line that crosses the others out. This is how I remember that Ctrl+5 is Strikethrough!

Download the workbook from https://www.mrexcel.com/youtube/PmQpp46p3ls/

Table of Contents
(0:00) Counting with Hashmarks
(0:12) Cross out text with Ctrl+5 in Excel
(0:22) Strike through one word in a cell in Excel
(0:33) Wrap-up

Common Search Terms? This video answers these search terms:
how do draw a strikethrough in excel
how do i draw a line through text in excel
how to draw line text in excel
how to draw line through text excel
how to draw line through text on excel
how to draw line through word in excel

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.