USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Right click on a cell and choose insert
|
|
|
Click on Insert Row/Column in the Home Tab/Cells group
|
|
|
Highlight a row or column, right click and choose insert.
|
|
|
Both B & C are correct.
|
Detailed explanation-1: -To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones. Right-click the selection, and then select Insert Rows.
Detailed explanation-2: -To insert a row, pick a cell or row that’s not the header row, and right-click. To insert a column, pick any cell in the table and right-click. Point to Insert, and pick Table Rows Above to insert a new row, or Table Columns to the Left to insert a new column.
Detailed explanation-3: -In this example, we’ve selected cell B3 because we want to insert a new column between column A and column B. Right-click and select “Insert” from the popup menu. When the Insert window appears, select the “Entire column” option and click on the OK button. A new column should now be inserted in the spreadsheet.