Inserting and deleting cells


show more Inserting and deleting cells provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Inserting and deleting cells

To see how you can add and delete cells, let's go up to the Office button again and open up our EatCake Sales Forecast. We see here that we already have a table of information available to us. But let's say that we now have some information that we'd like to start adding in for 2007. And we want to insert up here at the top of our table. So to insert a row of information, I simply select the row where I would like the information to be added in, and I right-click and click Select Insert.

And see how that pushes the information down? Now you'll notice that I've selected row 10 and that's put a gap between my information or the year 2005, which is really not what I want to do. So I've got two things I can do. I can go up to the top where my Quick Access toolbar is, and say Undo Insert Cells, which removes it. Or, if re-add those --insert those cells again--I can delete the information by right clicking on the row, and selecting Delete. So it's very, very simple...

Inserting and deleting cells
Video duration: 6m 53s 5h 13m Beginner

Viewers:

Inserting and deleting cells provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...