To insert new cells, rows, or columns in an Excel worksheet, follow these steps:
Select the cells, rows, or columns where you want the new, blank cells to appear.
Click the drop-down arrow attached to the Insert button in the Cells
group of the Home
Click Insert Cells on the drop-down menu.
box opens with the following options:
Shift Cells Right
shifts existing cells to the right to make room for the blank cells you want to insert.
Shift Cells Down
instructs Excel to shift existing cells down. This is the default option.
inserts complete rows in the cell range. You can also select the row number on the frame before you choose the Insert command.
inserts complete columns in the cell range. You can also select the column letter on the frame before you choose the Insert command.
For detail, you can refer to the following link:
Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy
of this information.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?