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 Excel - Draw a Line through Text (Strikethrough) #shorts Sample Files - MrExcel Publishing
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
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 Excel - Draw a Line through Text (Strikethrough) #shorts Sample Files - MrExcel Publishing
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
Transcript of the video:
How to draw a line through text in Excel.
That's called strikethrough.
Now, the shortcut for this goes back to the old days when we used to count using little hash marks.
That would be four, and then the fifth line is the one that strikes the others out.
To remember this, it's control+5, because remember the fifth line is the one that strike things out.
So control+5 there and control+5 there. What if you want to strike out just one word?
F2 to edit.
Use the arrow keys to get near the word, shift key with the other arrow key to select the word. And then control+5 while you're editing the cell.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
That's called strikethrough.
Now, the shortcut for this goes back to the old days when we used to count using little hash marks.
That would be four, and then the fifth line is the one that strikes the others out.
To remember this, it's control+5, because remember the fifth line is the one that strike things out.
So control+5 there and control+5 there. What if you want to strike out just one word?
F2 to edit.
Use the arrow keys to get near the word, shift key with the other arrow key to select the word. And then control+5 while you're editing the cell.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
