Question

which option is used to add row/ column when you click on any cell

Answer 1

Hi. Right click on the cell and then choose option insert above or below or right or left. Hope it helps...

Answer 2

Answer:

In Microsoft excel, for inserting a row or a column in the worksheet space.

The cell we select has a particular column and a row in which it is lying. For adding a row above the selected cell's row.

• Right click on the cell.
• Select the option 'Insert Row above' option.
• Row will be inserted above the selected cell's row.

Similarly, to insert a row below the cell select 'Insert Row below' option from the menu.

Also,

To add a column to the right or to the left of a certain cell's specified column.

• Right click on the cell.
• Select the option 'Insert Column left/right' option.
• Column will be inserted.