Charlie -who admits he is relatively new to Microsoft Excel- needs to rearrange the rows of his spreadsheet. Today, in Episode #1512, Bill shows us several methods to accomplish this task.
Today's Episode is brought to you by... New for 2012! "CFO EXCEL PRO": a New, weekly e-Newsletter Publication from CFO.com featuring Bill "MrExcel" Jelen! CFO Excel Pro offers, "... clear, concise illustrated articles written by Microsoft MVP Bill "Mr. Excel" Jelen that provide readers with step-by-step solutions to nagging "real-world" Excel problems.
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Today's Episode is brought to you by... New for 2012! "CFO EXCEL PRO": a New, weekly e-Newsletter Publication from CFO.com featuring Bill "MrExcel" Jelen! CFO Excel Pro offers, "... clear, concise illustrated articles written by Microsoft MVP Bill "Mr. Excel" Jelen that provide readers with step-by-step solutions to nagging "real-world" Excel problems.
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Transcript of the video:
MrExcel Podcast is sponsored by the Excel Pro Weekly Newsletter.
Published by CFO, written by me.
Learn Excel from MrExcel podcast, episode 1512 – Move Entire Rows.
Hey. Welcome back to MrExcel netcast. I’m Bill Jelen.
Today’s question is sent in by Charlie.
Charlie admits he’s relatively new to Excel. He has a large population of data – it’s actually product data, but I obscured his data here – and he wants to know how to move an entire row.
He doesn’t want to sort, he doesn’t have any fields that he can sort by so he can just sort alphabetically; he wants to know how to move an entire row.
For example, he wants to move row 9 above row 3. Well, I have a couple of ways to do that.
Method 1: Choose the entire row.
And then, I’m a keyboard person, so I use Ctrl+x to cut, but if you’re a mouse person you could right-click and choose “Cut”.
And then if we wanted to go above row 3, we’re going to choose the entire row 3, right-click, “Insert Cut Cells”.
And you see that row 3 moves down, and that cut row shows up above row 3.
So, you can’t really say that I want to move it after this row, it’s always going to go before.
The other way to go – and this is interesting, it’s definitely a mouse method – let’s say that we wanted to take row 2 and move row 2 down, after row 7.
Choose the entire row. Okay, so now we have this thick border.
And it’s very important that you right-click on the border, and then drag the border to the new spot, so, after row 7.
And then, say “Shift Down and Move” – oh, that’s just outside of your screen, hang on, let’s do it again.
Let’s take this row, right-click, I’ll drag down to here, “Shift Down and Move”.
“Shift Down and Move” is very important, so that moves row 9 up to where row 2 used to be, takes row 2 and moves it down below.
So, you can use those methods.
The right-click, you can get the hang of the whole right-click thing, so, choose the row with the left click, then right-click, move it to the right spot, “Shift Down and Move”.
And you can probably rearrange things relatively quickly there.
Why, hey.
I want to thank Charlie for sending that question in, I want to thank you for stopping by.
We’ll see you next time for another netcast of MrExcel.
Published by CFO, written by me.
Learn Excel from MrExcel podcast, episode 1512 – Move Entire Rows.
Hey. Welcome back to MrExcel netcast. I’m Bill Jelen.
Today’s question is sent in by Charlie.
Charlie admits he’s relatively new to Excel. He has a large population of data – it’s actually product data, but I obscured his data here – and he wants to know how to move an entire row.
He doesn’t want to sort, he doesn’t have any fields that he can sort by so he can just sort alphabetically; he wants to know how to move an entire row.
For example, he wants to move row 9 above row 3. Well, I have a couple of ways to do that.
Method 1: Choose the entire row.
And then, I’m a keyboard person, so I use Ctrl+x to cut, but if you’re a mouse person you could right-click and choose “Cut”.
And then if we wanted to go above row 3, we’re going to choose the entire row 3, right-click, “Insert Cut Cells”.
And you see that row 3 moves down, and that cut row shows up above row 3.
So, you can’t really say that I want to move it after this row, it’s always going to go before.
The other way to go – and this is interesting, it’s definitely a mouse method – let’s say that we wanted to take row 2 and move row 2 down, after row 7.
Choose the entire row. Okay, so now we have this thick border.
And it’s very important that you right-click on the border, and then drag the border to the new spot, so, after row 7.
And then, say “Shift Down and Move” – oh, that’s just outside of your screen, hang on, let’s do it again.
Let’s take this row, right-click, I’ll drag down to here, “Shift Down and Move”.
“Shift Down and Move” is very important, so that moves row 9 up to where row 2 used to be, takes row 2 and moves it down below.
So, you can use those methods.
The right-click, you can get the hang of the whole right-click thing, so, choose the row with the left click, then right-click, move it to the right spot, “Shift Down and Move”.
And you can probably rearrange things relatively quickly there.
Why, hey.
I want to thank Charlie for sending that question in, I want to thank you for stopping by.
We’ll see you next time for another netcast of MrExcel.
