How to insert and delete rows and columns in worksheet?
Answers
Answered by
6
Insert or delete a row
1.) To insert a row, select the row, select Home > Insert > Insert Sheet Rows.
2.) To delete a row, select the row, select Home > Insert > Delete Sheet Rows.
Or, right-click the selected row, and then select Insert or Delete.
1.) To insert a row, select the row, select Home > Insert > Insert Sheet Rows.
2.) To delete a row, select the row, select Home > Insert > Delete Sheet Rows.
Or, right-click the selected row, and then select Insert or Delete.
Answered by
2
Answer:
- insert blank rows we have two options
method 1:-
- right click on the row header, where you want to insert the next row
- from the context menu, select the insert option...
method 2:-
- to insert a single row,select the row on the cell where you want to insert the new row..
- click on insert dropdown button in the cells group on the home tab and choose insert sheet row option..
- to delete row from a worksheet
- right click on the road which you want to delete and select the delete option...aur select the row and click on the delete option in the cell group on the home tab and choose the delete sheet row option..
- in both the cases the selected row will be deleted and the contents below this row will shift up by one row
hope this helps u
mark me as brainlist
Similar questions
Math,
7 months ago
India Languages,
7 months ago
Math,
7 months ago
Physics,
1 year ago
Physics,
1 year ago
Environmental Sciences,
1 year ago