Range in MS excel is called the collection of two or more selected cell in a row or in a column.
Insert Row, Column
To insert the rown select the entire row by clicking on desired number from left numbering linst as shown in the following Picture that number 3 (third row) has been selected.
now right click to display the menu and then select INSERT
You will find the following result
Your can do the same to insert column by selecting from top Alphabets head.
All these operations of Range you can watch in the following Video