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?
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?
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.
All times are GMT -7. The time now is 12:42 PM. |