And you can do the same thing for row headers. 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. If I want to select multiple columns, I can do that in a number of ways. 'Cause copying and pasting can take a long time. But remember, there are over a million rows, so be sure you want to select them. 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. If you want to select an entire column, that is, all values in that worksheet column, you can click its header. Press Return, and that range is selected. 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. So if I select E4 through G4, and Command Shift down arrow, I select all of those columns as well. You can do it for multiple columns as well.
As soon as it encounters a blank cell, it stops at the previous. 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.
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. If you want to select all the cells in a column, you can do that using another keyboard shortcut. I'll click cell G5 or any other blank cell to release the selection. 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. And I am getting a little ahead of myself here, but you can't copy a multi-region selection like I have here. Cells that were previously selected are in light gray, and the most recent cell has a white background but a green outline. If I hold down the Command key again and click cell E12, then that's added as well. If I hold down the Command key, and click cell E10, that is also added to the selection. So I currently have cells B5 through D8 selected. If you want to select cells that are in different ranges, though, you can do what's called command clicking. Always note that your selection will be in a rectangle. 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. 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. If you want to select cells using the keyboard, there are a number of shortcuts you can do. To release the selection, click any individual cell, and you're done. If you want to include February and March, you can drag down to include cell G7.
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. So for example cell G6 contains the data for February of 2018. If I want to select an individual cell, all I need to do is click it. In this workbook I have a single worksheet that contains monthly revenue data for calendar years 2013 through 2018. My sample file is the Select workbook, and you can find it in the chapter three folder of your exercise files collection. In this movie, I will teach you some techniques to select cells in your worksheets. One of the most useful skills you can have when you work in Excel is selecting cells or groups of cells.
0 kommentar(er)
