how to insert or delete rows or columns in ms excel 2007?? Writes it's steps...
Answers
Answered by
1
select the row or column after which u want to insert row or column.
right click..
n then click on insert or delete...
right click..
n then click on insert or delete...
Answered by
1
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 button attached to the Insert command button in the Cells group of the Home tab.
@Click Insert Cells on the drop-down menu.
@The Insert dialog box opens with the following option buttons:
-Shift Cells Right: Select this option to shift existing cells to the right to make room for the blank cells you want to insert.
-Shift Cells Down: Use this default option to instruct the program to shift existing cells.
-Entire Row: Select this option to insert complete rows in the cell range. You canDeleting a row or column works in a similar way:
Select the row(s) or column(s) you want to delete.
Choose Home→Cells→Delete. also select the row number on the frame before you choose the Insert command.
-Entire Column: Select this option to insert complete columns in the cell range. You can also select the column letter on the frame before you choose the Insert command.
Deleting a row or column works in a similar way:
@Select the row(s) or column(s) you want to delete.
@Choose Home→Cells→Delete.
@Select the cells, rows, or columns where you want the new, blank cells to appear.
@Click the drop-down button attached to the Insert command button in the Cells group of the Home tab.
@Click Insert Cells on the drop-down menu.
@The Insert dialog box opens with the following option buttons:
-Shift Cells Right: Select this option to shift existing cells to the right to make room for the blank cells you want to insert.
-Shift Cells Down: Use this default option to instruct the program to shift existing cells.
-Entire Row: Select this option to insert complete rows in the cell range. You canDeleting a row or column works in a similar way:
Select the row(s) or column(s) you want to delete.
Choose Home→Cells→Delete. also select the row number on the frame before you choose the Insert command.
-Entire Column: Select this option to insert complete columns in the cell range. You can also select the column letter on the frame before you choose the Insert command.
Deleting a row or column works in a similar way:
@Select the row(s) or column(s) you want to delete.
@Choose Home→Cells→Delete.
SaharAn29:
plz mark as brainliest if it was helpful
Similar questions