Insert Row x Column in Excel

Let's have some example on how to insert row and column to an existing worksheet with data. Specially for beginners inserting a row or column in an existing worksheet sometimes inserted it in a wrong position, deleting existing data. To avoid this little accident, we will discuss how to do it and what should we clicked properly.

Note:
I used Microsoft Excel 2003, but below steps can also be done with Excel of higher version.
Author suggests that the application MSExcel is running before going thru series of steps.

1. Identify where will the data be inserted. (i.e. as an example we will be inserting row information between Row 7 and Row 8).

2. Left-click row number 8 to select it. (notice that whole row number 8 is highlighted)

3. After row number 8 was selected, press right-click on mouse and a menu will be displayed as shown below. Select Insert to insert a row on top of H and below F.

4. After left-clicking Insert, a new row has been created and data can now be pasted/type-in.

NOTE:
To create a column instead of left-clicking row number select column letter and follow procedure 3-4 to insert a column.