This isn't so much of a dueling podcast as Bill being obnoxious and breaking Mike's worksheet. Maybe there is a use for this, or maybe not. Episode #1191 will show you how.
Transcript of the video:
Bill: Hey, I'm Bill Jelen from MrExcel.com, and I've got a cool Excel tip for you today!
Mike: Hey this is Mike Gel Girvin, I’m ExcelIsFun in YouTube, and I have a different way to do that!
Bill: What, it's been four weeks in a row, I bet Mike wishes I would go back at home.
We're having so much fun, I said “Mike here, I want to show you how to break Excel.” And first I want Mike to show us his cool trick where he takes the tooltip from the formula and moves it.
So Mike, show us that!
Mike: Thanks, MrExcel!
I'm going to put some numbers right here, put a bunch of 2’sm right.
Ctrl+Down arrow, and I'm going to use the keyboard shortcut for Autosum, Alt+=, and then I'm going to take this and just kind of drag it around, Alright, so that's dragging, you know, because sometimes it gets in the way, right, and you're like “Get out of here!” Alright, let me just throw over to MrExcel!
Bill: OK, so I learned that from Mike, right, I mean that's one of those cool tricks.
“What else can you drag?” I wondered.
So we, you know, have some data here, we go into Data Validation, and we say, this is going to allow, let's say, a whole number between 100 and 110.
And then in our input message we're going to add some instructions: “Whole Number”, “Enter a number between 100 and 110.” Alright, click OK, alright!
Now, when we go into that cell, tooltip pops up, when I go out of the cell, tooltip goes away!
Did you know that you can take that tooltip and move it somewhere else?
Right, just like the formula bar, except the guy at Microsoft who's in charge of doing this clearly is not as smart as the guy that does the formula tooltip, because check this out.
When we come over here now, and add Data Validation, we’ll just add something yada yada yada, and something there, alright, and some settings here, we’ll allow a decimal between 100 and 150, click OK.
Now, when I go into that cell, whoops!
They don't show the validation right where I put it, they show the validation back to where I dragged it, it becomes the de-facto point for the validation the whole time.
Even if the validation is like, you know, far, far away, it's always going to go back in that spot.
So, while you can take the formula tooltip and move it wherever you want, never, ever do it with the validation, because you've now broken the validation forever, it's never going to work on this workbook again.
So, there we go, this is the worst Dueling podcast we've ever done.
Next week it'll be much, much better, thanks for stopping by, I'm Bill Jelen from MrExcel, Mike Girvin from ExcelIsFun!
Mike: WOOHOO!
Mike: Hey this is Mike Gel Girvin, I’m ExcelIsFun in YouTube, and I have a different way to do that!
Bill: What, it's been four weeks in a row, I bet Mike wishes I would go back at home.
We're having so much fun, I said “Mike here, I want to show you how to break Excel.” And first I want Mike to show us his cool trick where he takes the tooltip from the formula and moves it.
So Mike, show us that!
Mike: Thanks, MrExcel!
I'm going to put some numbers right here, put a bunch of 2’sm right.
Ctrl+Down arrow, and I'm going to use the keyboard shortcut for Autosum, Alt+=, and then I'm going to take this and just kind of drag it around, Alright, so that's dragging, you know, because sometimes it gets in the way, right, and you're like “Get out of here!” Alright, let me just throw over to MrExcel!
Bill: OK, so I learned that from Mike, right, I mean that's one of those cool tricks.
“What else can you drag?” I wondered.
So we, you know, have some data here, we go into Data Validation, and we say, this is going to allow, let's say, a whole number between 100 and 110.
And then in our input message we're going to add some instructions: “Whole Number”, “Enter a number between 100 and 110.” Alright, click OK, alright!
Now, when we go into that cell, tooltip pops up, when I go out of the cell, tooltip goes away!
Did you know that you can take that tooltip and move it somewhere else?
Right, just like the formula bar, except the guy at Microsoft who's in charge of doing this clearly is not as smart as the guy that does the formula tooltip, because check this out.
When we come over here now, and add Data Validation, we’ll just add something yada yada yada, and something there, alright, and some settings here, we’ll allow a decimal between 100 and 150, click OK.
Now, when I go into that cell, whoops!
They don't show the validation right where I put it, they show the validation back to where I dragged it, it becomes the de-facto point for the validation the whole time.
Even if the validation is like, you know, far, far away, it's always going to go back in that spot.
So, while you can take the formula tooltip and move it wherever you want, never, ever do it with the validation, because you've now broken the validation forever, it's never going to work on this workbook again.
So, there we go, this is the worst Dueling podcast we've ever done.
Next week it'll be much, much better, thanks for stopping by, I'm Bill Jelen from MrExcel, Mike Girvin from ExcelIsFun!
Mike: WOOHOO!
