How can I insert desired number of row's/column's in Excel Worksheet?

Question

How can I insert desired number of row's/column's in Excel Worksheet?

Answer 1

Sql Question And Answer-http://sqlqa.blogspot.com/

Answer 2

to insert rows click on the row heading to highlight the entire row, the right-click and choose insert.  You can also insert multiple rows by clicking/dragging down the row heading to highlight multiple rows, then rightclick and insert.

columns work the same way...click on the heading (A, B, C), etc to highlight, rightclick, the insert.

you also just put your cursor on some cell and press <ALT> I

then R to insert rows or C to insert columns

inserting a row, will insert it above your selection.  inserting a column will insert it to the left of your selection

Answer 3

Open the excel sheet go to insert tab and add rows either above or below

Answer 4

Open the excel sheet go to insert tab  and add rows either above or below