Locked lesson.
About this lesson
Edit worksheet by adding and removing rows and columns.
Quick reference
Worksheet Management
Edit your worksheet by adding, removing or correcting data
When to use
Learn how to insert rows or columns on a worksheet with existing data. Learn how to hide and unhide rows and columns
Instructions
Insert a row or column
Method 1
- Select the column heading to the right of where you want the new column to appear. The entire column will be highlighted.
- Go to the Home tab and select “Insert” from the “Cells” command group.
Method 2
- Select the column heading to the right of where you want the new column to appear. The entire column will be highlighted.
- Right-click with your mouse, and click “Insert” from the menu
Delete a row or column
Method 1
- Select the column heading to the right of where you want the new column to appear. The entire column will be highlighted.
- Go to the Home tab and select “Delete” from the “Cells” command group.
Method 2
- Select the column heading to the right of where you want the new column to appear. The entire column will be highlighted.
- Right-click with your mouse, and click “Delete” from the menu
Hide a row or column
- Select the row or column you want to hide. The entire column will be highlighted.
- Right-click with your mouse, and click “Hide” from the menu
Unhide a row or column
- Select the rows or columns to the left and right of the one you want to unhide. Both columns, or both rows will be highlighted.
- Right-click with your mouse, and click “Unhide” from the menu
Unhide all rows or columns on a worksheet
- Click the triangle below the Name Box. The entire worksheet will be highlighted
- Right-click on a row and select "Unhide" to unhide all rows. Right-click on a column and select "Unhide" to unhide all columns.
- 00:04 In this lesson, we'll learn how to edit our workbook by adding, removing or
- 00:08 correcting data.
- 00:10 Let's say we have this sheet with our office expenses, and we want to insert
- 00:14 a column with the category of each expense after the name of the expense.
- 00:19 That category would then become column B.
- 00:22 There are two really simple ways to do this.
- 00:25 The first way is to select the column heading to the right
- 00:29 of where you want the new column to appear.
- 00:31 So in this example, if we want to insert a column between A and
- 00:35 B, we select column B.
- 00:38 On the Home tab, we look for the cells command group and click Insert.
- 00:45 The new column will appear to the left.
- 00:47 That was pretty easy.
- 00:49 Actually, there's an even easier way.
- 00:51 Let's Ctrl + Z.
- 00:55 We start out the same way by selecting column B, right click with our mouse, and
- 01:00 the Insert command shows up.
- 01:02 We click and it's done.
- 01:06 So let's say we've inserted our categories and filled in each one.
- 01:10 Inserting a row is pretty much the same thing.
- 01:13 We just select the row heading to the bottom of where we want the new row
- 01:16 to appear.
- 01:17 Right click, insert, and it's done.
- 01:21 Let's do that now.
- 01:22 We want to add an expense for stationery, and
- 01:25 we want it to show up between the salaries expense and the telephone expense.
- 01:30 We hover over the telephone row header.
- 01:33 That's row 11.
- 01:35 We make sure that we have the black arrow showing up,
- 01:40 right click, and insert.
- 01:42 There we go.
- 01:44 And let's type stationery.
- 01:47 When inserting rows and columns,
- 01:49 make sure that you select the entire row by clicking on the heading.
- 01:55 If you only selected a cell within the row or column,
- 01:58 then the Insert command will only insert one new cell like this.
- 02:03 And we don't want that.
- 02:05 So let's Ctrl + Z to undo.
- 02:08 And if you want to delete a row or a column,
- 02:10 just make sure that you select the row, or the column by getting that black arrow,
- 02:14 right click, and delete.
- 02:20 And it's gone.
- 02:23 If you have large sets of data, but you don't need them all to be visible right
- 02:27 now, you can hide entire rows or columns with a simple right click.
- 02:33 Let's hide our category column like this.
- 02:36 We get our black arrow by hovering over the column name, right click,
- 02:41 and select Hide.
- 02:45 We can tell that this row or column is hidden because that column name or
- 02:49 row number will be missing from the sequence.
- 02:52 There'll also be a double line indicating where the missing column or row is.
- 02:57 To unhide, you can highlight the columns in either side of the hidden column,
- 03:03 right click, and select Unhide.
- 03:09 Or you can hover over that double line, get your little black cross and
- 03:15 manually drag to expand the hidden column.
- 03:23 If you have multiple rows that are hidden, and
- 03:26 you want it to unhide them all at once, Then you could
- 03:31 just click on the little triangle just below the name box,
- 03:37 right click on any row and select Unhide.
- 03:43 Of course, the same would apply if you have hidden columns.
- 03:47 Mastering these tasks should make it easier for
- 03:50 you to manage large sets of data on a worksheet.
Lesson notes are only available for subscribers.