You can move the contents of a selected range down or to
the right when cells are inserted.
- Select a cell or cell range.
- Click
- Select how to move the content.
- To move selected content down, click Shift
cells down and then click OK.
- To move selected content to the right, click Shift
cells right and then click OK.
- To move the row containing your selected content down,
click Entire row and then click OK.
- To move the column containing your selected content
right, click Entire column and
then click OK.