USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select the row, go to the Home tab and click the drop-down arrow on the Insert command in the Cells group
|
|
|
Select the first cell to the last cell in the row, go to the Insert tab and select Insert row
|
|
|
select a row, copy it to the clipboard, paste the row and delete the data in the new row
|
|
|
Go to the Page Layout tab and in the Arrange group select Insert Rows
|
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: -One way is to insert blank rows manually by right-clicking on the row above where you want the blank row and selecting “Insert.” Another way is to use the “Insert” function on the Home tab of the ribbon.
Detailed explanation-3: -Example #3–Insert a Row Using “ALT+I+R” Working on the data of example #1, we want to insert a new row 6 with the shortcut “Alt+I+R.” The steps to insert a row with the shortcut “Alt+I+R” are listed as follows: Step 1: Select any cell of row 6. We have selected cell A6, as shown in the following image.