How to Link Columns

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
You can safely reference linked cells inside other functions.
Image Credit: GYRO PHOTOGRAPHY/amanaimagesRF/amana images/Getty Images

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.

Advertisement

Step 1

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.

Video of the Day

Step 2

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

Advertisement

Step 3

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 4

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.

Advertisement

Advertisement

Step 5

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.

Video of the Day

Advertisement

Advertisement

references & resources