Cell in MS Excel is the intersection between a row and a column on spreadsheet. Cell is denoted by its Column and Row number on the spread sheet.
Look at the picture below, the bordered (selected) cell is denoted by A1 (A is the column and 1 is the row). Same applies to other cell as well.
To quickly know what cell you are on, simply look at the top-left side just above the spreadsheet. In picture below, the cursor is on column D and row number 17 so 'D17' is being displayed. By default that cell is active and ready to be edited with keyboard or mouse.
To select a specific column in MS Excel, simply click on the column header (top of the sheet). Look at the picture below for an example. To select D column, move cursor to D column header (the mouse cursor would change to downward black arrow) and click, the entire D column should get selected.
To select a specific row, go to the header of the row (in the left side) and click the row number. To select 6th row, click on 6th row header as shown in the picture below.
With mouse - To select range of cells (eg. B2 to C6), click on B2 first and then drag the mouse to C6 (by holding the mouse key).
With keyboard - Instead of dragging with mouse, we can also select range of cells using Keyboard. Simply use arrow keys to move to the starting cell and while holding the shift key, use arrow keys to move left and right to select desired range of cells.
To select multiple individual cells, click on first cell and then hold CTRL key and then click on each cell to select.
To fill a particular value in range of cells, write down the value (in this case 8) in the cell and then hold the bottom-right corner of the cell (the mouse cursor becomes '+') and drag to rows or column you want to fill with this value.
The result would be like below.
Play more ...
Can you try following
To move range of cells in the Excel, select the cell by clicking and dragging. Selection of cells can be achived using Keyboard also (use Shift+Arrow keys).
Now click the border of the selection as shown in the picture below and drag to the new location.
The result will be like this.
To copy the range of cells values to new location, follow move approach as above & hold the CTRL key while dragging to new location. This will keep the original values as it is and copy those to the new location.
The same can be achived using typical Copy-Paste appraoch also.
Select the range of cells to copy and press CTRL+C (or right click and select Copy) and then go to the target location and Press CTRL+V (or right click and select Paste) as shown in the picture below.
How to insert rows and columns in Excel?
To insert a row in between, select a row after which we want to insert a row (click on row header to select the row) and right click and then select Insert from context menu.
The result will be like this.
To insert multiple rows in between, select multiple rows (by selecting a row and dragging mouse over other rows) and then Insert.
To insert a column, first select a column by clicking on the column header and right click. Select Insert from the context menu.
The result would be like this.
To insert multiple columns, select Multiple columns (by selecting a column and dragging mouse over other columns) and then Insert.Views: 732 | Post Order: 2