Question

Write the steps to insert a row and column in spreadsheet

Answer 1

Answer:

Here is your answer:-

• INSERT A COLUMN:-

Select any cell within the column, then go to Home > Insert > Insert Sheet Columns .

Alternatively, right-click the top of the column, and then select Insert.

INSERT A ROW:-

Select any cell within the row, then go to Home > Insert > Insert Sheet Rows.

Alternatively, right-click the row number, and then select Insert.

Explanation:

Inserting a row or column

To insert a row or column:

Select the row above or the column to the right of where the insertion should occur. Or click in any cell in that row or column.

Choose Home→Cells and click the arrow to the right of the Insert button to open the drop-down list for the Insert button.

From the menu, choose Insert Sheet Rows or Insert Sheet Columns.

To insert multiple rows or columns at once, select a corresponding number of contiguous rows or columns. For example, if you select three columns, you get three new blank columns when you choose Insert.

I hope it helps.

Thank you.

Answer 2

Explanation:

Select the row above or the column to the right of where the insertion should occur. Or click in any cell in that row or column.

Choose Home→Cells and click the arrow to the right of the Insert button to open the drop-down list for the Insert button.

image0.jpg

From the menu, choose Insert Sheet Rows or Insert Sheet Columns.

Here’s another way to insert: from the right-click (contextual) menu: