By right-clicking a row number, you can select the Insert command to get a new row above the current one. If you right-click a column letter, you can select Insert to get a new column to the left of the current column.
- [Instructor] It's not uncommon that you need to add a new row, or rows, within a worksheet, and also the same thing with columns. In this list on a worksheet called Insert-Delete in the workbook 05 - Layout, we need to make some room for a new record that we're gonna put in in column A. I'm gonna put it above row 5. Now, as we work with columns and rows, much of the time we do not need to go through the standard menu. The shortcut menu technique, the right mouse button, is going to be very helpful. If I want a new row above row 5, I can simply right-click row 5, and Insert, and a new row's inserted.
Now, what if I had not been paying attention to this particular worksheet, and I scroll to the right here, I've disrupted the data off to the right. So that wasn't a great idea. I'll undo that with ctrl + z. But what can we do in a case like this? If we simply highlight the cells from A5 over to I5 in this example here, if we right-click within the highlighted area, and choose Insert, notice now we see three dots behind it, it's going to bring out a dialog box. And what do we want to do here? Shift the cells down without disrupting anything to the right of column I.
And as we scroll over to the right, we see there's been no interruption there. I'll put in the new data later. Maybe I'd find out a bit later that I don't need information here in row 5. If I delete row 5, I'd have the same problem in reverse, but perhaps worse, again forgetting there's other information out there. Right-click row 5 and delete, no warning. If I scroll over to the right, I have disrupted this, and if I don't know the data well I wouldn't even necessarily recognize that, but I did get rid of some of the information over here.
So here, too, I'll press ctrl + z to undo. In a similar way this time, we will highlight just these cells if we don't want to put in new information there, right-click and Delete. And in this example here, Shift cells up. All the cells from row 6 downward will move up a row. There we are. And we have not disrupted any information off to the right. Now, similarly, we can insert new columns. If I want a new column between columns C and D, I'll right-click column D and Insert.
I don't really need that, I'll press ctrl + z. You can also highlight multiple columns; maybe I need two columns between columns C and D. Drag across both, right-click and Insert, we'll get two columns. Here it's much less likely that you will want to insert cells, but the same basic rules apply, as we showed you in inserting cells in rows. Here, too, undo, ctrl + z. There will be times, and imagine if you were making a presentation of this data, does your audience really need to see those social security numbers? Probably not.
Let's right-click column D and hide column D. When you hide a column, there's an indicator there and I'll click on column B for the moment, but notice the separator between columns C and E, and that's a reminder that we got a hidden column. Now, I jokingly say sometimes, "As long as you know "your alphabet, you'll know that columns are hidden." But it's easy to overlook, and, over the years, I've run into situations I just wasn't attentive enough and I forgot to look, and there are hidden columns that turn up a lot. And people hide them for different reasons.
Another reason could be, you're ready to print this, you really don't need that column there, a quick print preview, by the way, ctrl + p, does reveal that there's no gaping hole where that hidden column is, so we don't worry about it. Esc, we're back here. You might have multiple hidden columns. I'm going to right-click column H and hide it. Now at a later time, if I want to bring back all the hidden columns, there are two ways to do this. We could simply drag across columns C through I, right-click and Unhide.
Those hidden columns return. I'm gonna undo that with ctrl + z. Another way to do it: after highlighting these, simply double-click a column boundary. Any of these columns boundaries, double-click; that brings them back, too. And there's a third way. Undo; ctrl + z. If you got hidden columns all over the place, and maybe some more off to the right, just click in the upper-left corner. That selects the entire worksheet. And here, we can either right-click a column and choose Unhide, or double-click one of those boundaries, all those hidden columns re-emerge. So it's easy to control these, it's easy to hide columns.
I didn't hide rows but it's the same general approach. Maybe, as we print out this list, there's a certain group here that we don't to see in the list, I'll drag across these rows, right-click, and Hide. And here, too, remind yourself that, at different times when you open workbooks, everything might look just fine on this worksheet. Are they any hidden rows, any hidden columns? If we don't scroll through the list, that's one way, of course, and not the best way to find those, but why not click in the upper-left corner, we can right-click any row and Unhide.
So any hidden rows will re-emerge. So a variety of techniques here, none of them using the standard ribbon menu system, but all using that right mouse button to get to these features. We've shown you how, at different times, you want to insert rows or insert cells, insert columns, hide columns, hide rows. Vital features as you work with Excel.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros