Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Very often you'll find the need to insert cells into an existing worksheet. So let me show you how you can do that with rows and columns and even cells right in the middle of a row and column. Well, for example, let's say we wanted a blank column between June and Total. Well let's go up here to the header for Column H and notice the mouse pointer is this down arrow. And just click with the right mouse button and from the pop-up, choose Insert and it inserts a brand-new column right before the column that you clicked.
And that's just kind of a Windows standard is new items generally go before the current item, whatever that item is. Could be row or column and so forth. And I am just going to press Ctrl+Z to undo that. Well, what if I select more than one column? Let's go over here and let's select Column B and C. And I have a few techniques to do that. Once you have both Column B and C selected, again, make sure it's this down pointing arrow on the header, right-click, choose Insert, and now it inserts two columns. So you now have a new Column B and a new Column C. And I'll just press Ctrl+Z to undo that.
Rows work the same way. Let's say we want a row above Row 5, put your mouse pointer here on the header for Row 5 so it's that right pointing arrow, click the right mouse button and choose Insert, and it inserts a new row. Notice also that it picked up the formatting of the row above it, because that's where you inserted the row. Now, of course you can always get rid of that color. But we'll talk about that in another movie. Again, I'll just press Ctrl+Z to undo. What if we select a few rows? Maybe this time I'll select three rows here. So I am just putting my mouse pointer on this first row so it's that right pointing arrow and I am just clicking and dragging down.
And then when I right-click and choose Insert, you see it inserts three rows, because I have three rows selected. Again, let's just undo. Well let's say you wanted to insert cells in the middle of a worksheet. Let's select from this January down to the Total, right-click in the highlighted area, and choose Insert. Now, because you're inserting cells in the middle of the worksheet, Excel has to figure, all right, if we are going to do that, we have got to push the stuff aside and which way are we going to push it? Up, down, left or right? Well, Excel is pretty good at guessing and here if we choose Shift cells right and click OK, now you see everything is pushed up.
Look what's happened here. This area has been pushed out to Column I, so it's not quite a new column that's been inserted. It's new cells being put in, in the middle. I'll just Ctrl+Z to undo. And the same thing if you go across a row. If we select across a row here, right-click and Insert. And this says okay, again, which way do you want to go? Because we selected across the row, Excel correctly guesses that we want to shift the cells down. Click OK. Now it has picked up the formatting, but you see it's shifted everything down and now we have this empty row.
And you can just again Ctrl+Z to undo. So most of the time, you want to insert an entire new column or an entire new row, not cells in the middle of the worksheet. But now you see the technique is the same so you could do it either way.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 97800 Viewers
80 Video lessons · 141159 Viewers
59 Video lessons · 59513 Viewers
52 Video lessons · 72811 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.