DATABASE FUNDAMENTALS
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: -Select the cells where the empty rows need to appear and press Shift + Space. When you pick the correct number of rows, right-click within the selection and choose the Insert option from the menu list. Tip.
Detailed explanation-3: -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.