One of the most useful skills you can have when you use Excel is selecting cells or groups of cells. In this video, learn some techniques to select cells in your worksheets.
- [Instructor] One of the most useful skills you can have when you work in Excel is selecting cells or groups of cells. In this movie, I will teach you some techniques to select cells in your worksheets. My sample file is the Select workbook, and you can find it in the chapter three folder of your exercise files collection. In this workbook I have a single worksheet that contains monthly revenue data for calendar years 2013 through 2018. If I want to select an individual cell, all I need to do is click it.
So for example cell G6 contains the data for February of 2018. If I want to select multiple cells, for example, all the February values, and I'll include A6 which has the word "February" in it, you can click the first cell, and then drag to the side, and you see that I'm selecting all the cells from A6 to G6. If you want to include February and March, you can drag down to include cell G7.
To release the selection, click any individual cell, and you're done. If you want to select cells using the keyboard, there are a number of shortcuts you can do. The first, let's say I'll click cell B5 for January 2013, is to press the Shift key, and then use the arrow keys to expand your selection. So if I held down the Shift key and pressed the down arrow, you'll see that I'm going down for each press of the down arrow, and if I go to the right, then I include one more column.
Always note that your selection will be in a rectangle. If you want to select cells that are in different ranges, though, you can do what's called command clicking. So I currently have cells B5 through D8 selected. If I hold down the Command key, and click cell E10, that is also added to the selection. If I hold down the Command key again and click cell E12, then that's added as well. Cells that were previously selected are in light gray, and the most recent cell has a white background but a green outline.
And I am getting a little ahead of myself here, but you can't copy a multi-region selection like I have here. So I have these cells selected, if I were to press Command C, I would get an error saying that I can't do it. So I'll click OK. I'll click cell G5 or any other blank cell to release the selection. If you want to select all the cells in a column, you can do that using another keyboard shortcut. Let's say that I want to select all the values from G4 down to G17, so all of calendar year 2018, including the total.
I click cell G4, and I press Command Shift down arrow, and you can see that Excel selects everything down to the last value in that column. As soon as it encounters a blank cell, it stops at the previous. You can do it for multiple columns as well. So if I select E4 through G4, and Command Shift down arrow, I select all of those columns as well. If you want to select a range of cells for which you know the address, you can go up to the Name box at the top left corner of the workbook window, and then let's say I want to do B5 colon D9.
Press Return, and that range is selected. Couple of last things to show you. If you want to select an entire column, that is, all values in that worksheet column, you can click its header. So if I want to select all the values for column F, move the mouse pointer over that column header, you can see that it is now green, and I have a downward pointing black arrow. When I select, I get all the rows. But remember, there are over a million rows, so be sure you want to select them. 'Cause copying and pasting can take a long time.
If I want to select multiple columns, I can do that in a number of ways. So the first is I can click and drag to select, or if I want to do the equivalent of Command clicking, or Command selecting, like I did for individual cells, I can select one or more columns, and click another row header or column header that isn't connected, and click that as well. And you can do the same thing for row headers. So if I do row headers 5 and 6, and then Command click row 10, those are all selected as well.
And as always, you can click any unselected cell to remove your selection, and continue work.
- 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