Inserting, moving, and deleting cells and cell ranges

When you look in an Excel worksheet, it appears that the cells, rows, and…columns are fixed, that you can't add, move, or delete them.…In fact, you can do all those things.…In this movie, I'll show you some techniques that will save you a lot of time by…letting you fix mistakes with one or two clicks of your mouse, instead of tedious…cutting and pasting.…As an example, let's take a look at the data list I have here on the left.…I have Month and Customers, but I have no entry for February.…So if I wanted to move the data to make room for February, I would have to…select all this data, copy it, and then past it exactly one row below.…

But there is an easier way.…What I need to do is insert cells in the space where there are B4 and C4 right now.…In other words, I want February to go over March is, but I don't want to…delete the March data.…So what I do is I select these cells and then, on the Home tab of the Ribbon, in…the cells group, click the Insert button's down arrow and click Insert Cells.…