Excel Guides

Pasting without Updating References in Excel

When you paste data into an Excel spreadsheet, by default the cell references will update to match the new location of the data. However, there are times when you may want to paste data without updating the cell references. To do this, you can use the "Paste Special" feature and select the "Paste Link" option.

To paste without updating references:

  1. Select the cell or range of cells that you want to copy.
  2. On the Home tab, in the Clipboard group, click Copy.
  3. Select the cell or range of cells where you want to paste the copied data.
  4. On the Home tab, in the Clipboard group, click Paste > Paste Special.
  5. In the Paste Special dialog box, select Paste Link and then click OK.

The data will be pasted into the new location but the cell references will remain unchanged. If you make any changes to the original data, those changes will be reflected in the pasted data as well.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.