How to Link Columns

Function outputs in Excel spreadsheets update automatically -- and silently -- whenever you change a cell mentioned in the function's formula, so every referenced cell needs current information. When you have two columns that share duplicate data, linking them, rather than merely copying and pasting their contents, ensures that the info in both locations stays up to date. Excel allows you to link columns on the same spreadsheet, between sheets in the same workbook or between two separate workbook files.

10, 100 Yen bill in front of computer screen displaying financial spreadsheet
You can safely reference linked cells inside other functions.
credit: GYRO PHOTOGRAPHY/amanaimagesRF/amana images/Getty Images

Step

Select the lettered header of the source column -- the column that contains your data -- to highlight the entire column. If you already filled out the same data in two columns, it doesn't matter which you pick as the source.

Step

Press "Control-C" or right-click the header and pick "Copy."

Step

Right-click the header for the target column where you want to create the link. It's okay if the target column already has the same data in it; the link overwrites any existing content.

Step

Click "Paste Link" in the Paste Options section of the context menu. Its icon looks like a chain link. The entire column will fill with data linked from the source column, with the side-effect of displaying a "0" in every cell after the end of your data.

Step

Select the first extraneous "0" and press "Control-Shift-Down" to highlight the remainder of the column. Press "Delete" to remove the unnecessary links and get rid of the zeros. If you plan to use more rows of data in the future, you can start a few cells lower and leave some of the zeros in place. Do not leave the entire remainder of the column filled with zeros, however, as this dramatically increases the file size and slows down operations.