When you look at an Excel worksheet, it appears that the cells, rows, and columns are fixed in place. However, you can insert, delete, and move pretty much any element of an Excel worksheet.
- [Instructor] When you look at an Excel worksheet, it appears that the cells, rows, and columns are fixed in place. In fact, you can insert, delete, and move pretty much any element of an Excel worksheet. In this movie, I'll show you techniques that will save you a lot of time by letting you fix mistakes with one or two clicks instead of several minutes of tedious cutting and pasting. My sample file is the Manage Cells workbook, and you can find it in the chapter four folder of your exercise files collection. This workbook contains monthly inquiries, and let's say that I want to create a second list for the next year.
I'll start by giving myself a little bit more space between the top of the worksheet and my header row in row two. If I want to insert a row, all I need to do is move the mouse pointer over one of the row headers, in this case I'll do row one, then control click and from the list that appears I will click Insert. And you can see that I inserted a new row. If I want to insert a new column, I can do that.
For example, if I wanted to insert a new column D, I could control click the header for column D, click Insert and I get a new column. And you can see that the labels that were in D and E have been moved over one to E and F. Now take a look at my data, and I see that I have a duplicate December label in B15 and a blank cell in C15. I can delete the value in B15 and move the values for January up if I want to.
But what's even quicker is you just delete the cells entirely. So I want to get rid of B15 and C15. I'll select them. And then on the Home tab of the ribbon, I'll go up to the Delete button. It's the Delete Cells button, but it says Delete on its face. So I'll click that. And the cells disappear. If I click the Delete button's down arrow, then I can delete cells, delete sheet rows, delete columns, or even delete the entire sheet. I didn't need to go that far, so I just deleted the cells.
Now let's say that I want to move the values from what is now B15 and C15 up to E4 and F4. Well I can cut and paste if I want to, but I can also just drag those cells' values and formats up to E4 and F4. With cells B15 and C15 selected, I'll move the mouse pointer over the edge of the selection, and you see that the mouse pointer changes from a white Greek cross cursor to a grasping hand.
Now all I need to do is click and drag and you see that I'm dragging the cells up to E4 and F3. And when I release the mouse button, those cells are there now. If I want to insert cells in a particular area then all I need to do is select the cells where I want to insert new ones and click the Insert button. Again this is on the Home tab. And they're inserted. And if I want to undo the action after I've done it, I can just press command Z.
For completeness, I'll show you how to delete rows and columns as well. It's exactly the same as inserting except that instead of clicking Insert from the menu you click Delete. So let's say I want to delete column D, I will control click its column header and click Delete. And the same thing for row one. If I want to delete that, I will control click its header, click Delete, and it's gone. The techniques that I've shown in this movie will save you a lot of time when you need to change things around in your worksheet.
And remember, as long as you don't delete a worksheet, which you can't undo, you can undo any of these actions and redo them until you get it right.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.