PDA

View Full Version : How to connect cells in excel in sequence


mmurrey
Jun 22, 2010, 06:32 PM
How do you link cells from one sheet to another in a workbook if the cells are in a sequence? I use the formula ='Sheet1'!C2, etc. but entering the formula for each cell is tedious. Is there a faster way if the cells are in sequence?

Scleros
Jun 24, 2010, 09:10 AM
If the layout of the cells matches in both sheets, such as vertically in a column, enter the formula in the first cell and then copy and paste it (CTRL-INSERT, SHIFT-INSERT) via the Windows clipboard to all the other cells. Excel will index the cell reference in the pasted formula. This is a basic core Excel feature for all formula.

Alternatively, you can also select the source range(s), navigate to the destination sheet, and choose Paste > Paste Link. This is handy for situations where the source range is not contiguous but the destination range is.