Range, Row, Column and cell in excel

Range

In excel range is defined as a collection of two or more cell. This article gives you a concept of range, cell column, rows and how to work with a selection, fill a range with data. 

This tutorial is for the starter who wants to learn excel. don't escape this step.

Cell: Cell is rectangle shape or box in the pic cell is the dark rectangle shape box 
Range, Row, Column and cell in excel

Column: Column is a collection of cell in verticle in the sheet you can see a name like A, B, C, D which is the column. let's go by selecting all column by clicking the column name: Remember that you have to click on the column when your cursor change to down arrow shape to select all column
Range, Row, Column and cell in excel
Row: Row is in horizontal line there is number 1,2,3,4,5 like you can select row same as the column by clicking on the rows number 
Range, Row, Column and cell in excel
Range:
Range example: the dark selected area is the range of the selected cell.
Range, Row, Column and cell in excel
If you want to select the different range of cell in the different area you can select using ctrl key of the keyboard.
press ctrl key and click on the cell.
Range, Row, Column and cell in excel
Fill range with same data:
type something in any cell
now move the cursor into left down corner of the cell, you see that the pointer of the cursor will change and drag it 
Range, Row, Column and cell in excel
Move the range of data to another range :
now select the range and drag it from the mouse. Remember the cursor pointer.
Range, Row, Column and cell in excel
Insert row and column
TO insert row or column in existing working sheet
you have to right click on row or column and click on insert
Range, Row, Column and cell in excel
Range, Row, Column and cell in excel
.

0 Comments