6] Shift the Excel cell down with Insert Copied Cells Select a range of cell, right-click and select Copy . Click the location that you want the data to go, then click the Home tab.