Question

How will you enter (i) cells (ii) rows (iii) columns in a worksheet ?​

Answer 1

To insert a row or column:

• Select the row above or the column to the right of where the insertion should occur.

• 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.

Ⓜ︎Ⓐ︎Ⓡ︎Ⓚ︎ Ⓐ︎Ⓢ︎ Ⓑ︎Ⓡ︎Ⓐ︎Ⓘ︎Ⓝ︎Ⓛ︎Ⓘ︎Ⓔ︎Ⓢ︎Ⓣ︎ ♥︎♥︎♥︎

Answer 2

Answer:

To enter/insert a cell, row, Columns in a worksheet, Right Click a cell > select > insert > select option (for cell – ‘shift cells right /down’, for rows – ‘Entire row’, for the column – ‘Entire column’). Or you can simply use ‘CTRL SHIFT +’.

Explanation:

In an MS Excel workbook, we can create more number of worksheets. A worksheet is said to be the collection of cells where the data has to be kept and manipulated. Here, the data has to be fed into each and every cell.

To insert a cell or row, one can select a cell/row/ column, and then right-click it and then select ‘insert’ option. Or a keyboard shortcut can be used ‘CTRL SHIFT +’