Todays podcast is the first in a series featuring guest podcasters. Bob Umlas, Excel MVP and author This Isnt Excel, Its Magic shares one of the tips from his book. This is one of my favorite Bob Umlas tips how to add a blank row between every row in your dataset. Episode 467 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:
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
Well, we're still here in Seattle at the MVP summit.
I have Bob Umlas.
Now, Bob is the MVP MVP's.
He has a book called "This isn't Excel it's Magic!" With 85 tips and when I read the book at least 50 of those tips were new to me.
I said Bob,"you got to come and do a podcast and show this trick which is my favorite trick." Here's Bob.
Thanks Bill.
Hi everybody.
So, in this particular case, we have a small data set, 15 rows.
And what you want to do is just double space it.
You want to insert a black row between each line.
So, in this case with only 15 rows would be really easy to do it manually.
Just inserting in each one.
But if there was several thousand rows we weren't difficult, I came up with this technique.
If you pick a parallel range or nearby raised enter one, and the number two and then double-click the Fill handle and it acts on those how far down to go.
and while that's Selected You can remove the right mouse.
Click here and copy it.
Go down to the bottom.
In this case, I could click cell E16.
But, I'm going to use a CTRL+Down arrow and then the down are once again.
Just so that this would be the technique they for a couple of thousand rows And then I can just hit the Enter key to paste.
And now, I have two sets of the numbers 1 through 15 in here.
If I select column E And then to the left, That's the active column and all I need to do is hit the sort ascending key.
And I am done aside from clearing column E.
It's sort of the blank rows right into place.
That's how you do it.
Don't you love that trick?
The whole book is filled with amazing things like that.
Again, The book is called "This is an excel It's magic" from Bob Umlas.
Hey, thanks for stopping by.
We'll see you next time for another net cast from MrExcel
I am Bill Jelen.
Well, we're still here in Seattle at the MVP summit.
I have Bob Umlas.
Now, Bob is the MVP MVP's.
He has a book called "This isn't Excel it's Magic!" With 85 tips and when I read the book at least 50 of those tips were new to me.
I said Bob,"you got to come and do a podcast and show this trick which is my favorite trick." Here's Bob.
Thanks Bill.
Hi everybody.
So, in this particular case, we have a small data set, 15 rows.
And what you want to do is just double space it.
You want to insert a black row between each line.
So, in this case with only 15 rows would be really easy to do it manually.
Just inserting in each one.
But if there was several thousand rows we weren't difficult, I came up with this technique.
If you pick a parallel range or nearby raised enter one, and the number two and then double-click the Fill handle and it acts on those how far down to go.
and while that's Selected You can remove the right mouse.
Click here and copy it.
Go down to the bottom.
In this case, I could click cell E16.
But, I'm going to use a CTRL+Down arrow and then the down are once again.
Just so that this would be the technique they for a couple of thousand rows And then I can just hit the Enter key to paste.
And now, I have two sets of the numbers 1 through 15 in here.
If I select column E And then to the left, That's the active column and all I need to do is hit the sort ascending key.
And I am done aside from clearing column E.
It's sort of the blank rows right into place.
That's how you do it.
Don't you love that trick?
The whole book is filled with amazing things like that.
Again, The book is called "This is an excel It's magic" from Bob Umlas.
Hey, thanks for stopping by.
We'll see you next time for another net cast from MrExcel
