2] Shift the Excel cell down by clicking and dragging Move the cursor on the edge of the cell that you want to move down until you see a double arrow. Now, drag the cell down.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Click and drag to select the range of cells you want to contain date information. Click on a column header to select the entire column. Use the Shift key to add more cell ranges to your selection.

How to Copy Data From One Spreadsheet to Another in Excel 2010 By Ruri Ranbe , Contributor Functions you enter into a cell are included whenever you paste links.

To Copy Paste columns and rows in Excel spreadsheet, follow these steps: Open an Excel spreadsheet on your computer. Select a row or column you want to copy or cut.