In excel, as with all other windows program, you have to know how to target large data groups in excel if you want to modify it.
So, lets learn a few techniques on this section of the course, the techniques we will be looking at in this section are pretty straight forward. Put your mouse pointer in the cell (A5) containing the word product.
Select the cell and drag down on the worksheet holding the left click button of your mouse, as long as you do not release the left click button of the mouse, you can select larger area of the worksheet and also reduce the selection area.
That’s great, that is the easiest way on how to target large data groups in excel. But, what if you want to select all the cells containing values at a go, that’s pretty easy and simple, here we go;
- Select the cell (A5), place your mouse pointer on the last cell (I30), just before you click, hold the Shift key down and click, boom, the, you should have the whole area selected as below;
Did you know the combination of Shift + Enter also works perfectly well is selecting larger areas of cell, if you know number of the last cell in the worksheet?
In our case the last cell on the worksheet is I30, select the first cell (A5), below the ribbon bar, on the left-hand side is the name box, type in I30 then, Shift + Enter key, the whole area is selected as above.
Random cell selection is also possible, either selecting from the headers on the columns, the numbers across the rows or individual cells within a worksheet.
- Hold Control (Ctrl)+Click of the mouse: add to selection
Why would you want to select cells randomly? Maybe you want the contents of the cell to be bold and you might want to change the fonts or italic it, even change color of the contents or some other formatting.
All are possible when you know how to target large data group in Excel and modify it. You can also drag on the headers of the columns and rows to select large data groups.
- Control (Ctrl)+space bar: select entire column
- Shift + space bar: select entire row
Current region in excel terminology is an area of cells containing values, either text, numbers or formulas, to select all the cells in a current region, click a cell in that region, then
- Control (Ctrl)+A: select all cells in a current region, if you repeat the shortcut key again, the entire worksheet is selected.
As long as you know how to target large data groups in excel combined with the auto fill handle and how to move around in a worksheet, you are going to find out you are doing excel much faster and easier.
You can watch the video below for visual explanation. Thanks, sharing is caring.