Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started.
So now let's talk about moving CELLS around inside of the WORKSHEET. I can do it in a number of ways. I can use the mouse to select the CELLS I want and as soon as I hover over the edge of the selected CELLS, I get four diff, four directional arrows. If I click and drag that - I'm physically moving all of those. I tend to stay away from that. I am just hitting undo to go back which is CTRL+Z. I like to do instead a CTRL+X which is a CUT and then click where I want to move it to and hit CTRL+V to paste. This CUT and PASTE will always work and that's why I recommend using it for all moving needs.
You can also INSERT new CELLS in between current data. So if I want to move everything down and move some stuff around that way - I click on the CELL that I want, I right click and then I do INSERT. It then asks me in this little window - do I want to shift the CELLS to the right or down? I want to try shifting them down. I can do this all at once across these five by doing, by selecting all five, right clicking on it, hitting INSERT and shifting the CELLS down.
I can do the same thing with vertical CELLS. I select all these, I right click on it, I hit INSERT and I shift them to the right. And now I have new CELLS over here.
The best method to move CELLS around is to select what you want, hit CTRL+X to CUT, click where you want to PASTE it, and then hit CTRL+V to PASTE. Another important reason to do that is to maintain the CELL references. We'll go over that later but that's a very important concept. And that's how you move CELLS around in Microsoft EXCEL.