Today, Bob calls in with a question. He has an Excel spreadsheet where someone managed to cross out only part of a cell. For example, someone crossed out the original due date and then keyed a new due date in the same cell and the new date does not have the strikethrough formatting applied. Episode 547 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Welcome back to the MrExcel netcast, I'm Bill Jelen.
Today we have a question sent in by Bob.
If you have a question for the podcast, please feel free to either leave us a voicemail or drop me a note and we'll get to you on a future podcast.
Bob's question was pretty interesting; he said hey I received a spreadsheet from someone and they did this cool thing in Excel I can't figure out how they did it, basically they had a column of due dates and while the original due date had been maybe July 11, somehow they managed in a single cell to cross out July 11th and put it in July 13th.
He said you know how can you do that?
How can you change the format within a cell?
Let me go down here to a new cell where we have a due date of July 12 and you'll notice that this is actually text and they're not real dates so we can actually type a couple of spaces and then type the new due date, so I'll put July 21st in there and then the trick is we either have to select cells in Edit Mode or in the Formula Bar, so I'll go up into the Format Bar and select the original cells July 12, so here I've selected just a few of the characters.
I missed there I held down the Shift key and hit the Right Arrow to select the last character and then if it's something that's available on the Formatting Toolbar we could go ahead and do that.
For example bold italics or underline will work, but in this case we're going to have to go to Format Cells that's control 1 and we get a shortened version of the Format Cells that only lets us change the font but sure enough there's a setting there called Strike Through, so we choose Strike Through and basically then we've added Strike Through to just a certain set of characters within the cell.
Great way basically for this where we have due dates that are shifting you get to show the original date cross it out and then add the new date as well.
Hey and another cool thing if you're a fan of Strike Through, it's usually not on the Standard Toolbar but there is a great shortcut key for that that's CTRL 5 will let you turn on and off Strike Through of course for a whole cell.
Hey, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
Today we have a question sent in by Bob.
If you have a question for the podcast, please feel free to either leave us a voicemail or drop me a note and we'll get to you on a future podcast.
Bob's question was pretty interesting; he said hey I received a spreadsheet from someone and they did this cool thing in Excel I can't figure out how they did it, basically they had a column of due dates and while the original due date had been maybe July 11, somehow they managed in a single cell to cross out July 11th and put it in July 13th.
He said you know how can you do that?
How can you change the format within a cell?
Let me go down here to a new cell where we have a due date of July 12 and you'll notice that this is actually text and they're not real dates so we can actually type a couple of spaces and then type the new due date, so I'll put July 21st in there and then the trick is we either have to select cells in Edit Mode or in the Formula Bar, so I'll go up into the Format Bar and select the original cells July 12, so here I've selected just a few of the characters.
I missed there I held down the Shift key and hit the Right Arrow to select the last character and then if it's something that's available on the Formatting Toolbar we could go ahead and do that.
For example bold italics or underline will work, but in this case we're going to have to go to Format Cells that's control 1 and we get a shortened version of the Format Cells that only lets us change the font but sure enough there's a setting there called Strike Through, so we choose Strike Through and basically then we've added Strike Through to just a certain set of characters within the cell.
Great way basically for this where we have due dates that are shifting you get to show the original date cross it out and then add the new date as well.
Hey and another cool thing if you're a fan of Strike Through, it's usually not on the Standard Toolbar but there is a great shortcut key for that that's CTRL 5 will let you turn on and off Strike Through of course for a whole cell.
Hey, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
