Professor Excel

Copy Exact Formulas: 4 Ways of Preserving the Cell Links in Excel

thumbnail, copy, paste, exact, ranges, exact ranges, persist, preserveThis problem occurs quite often: Excel always adapts the cell ranges in formulas when copying cells. An example: Cell A1 links to A2. When you copy A1 to B1, the link will change to B2. This example is comparatively simple but there are more complex situations. In this article, we’ll take a look at four methods for copying and pasting the exact formulas in Excel: Two manual ways by using the $-sign or copying the cell contents, the third method by using a simple replace trick and the fourth: the automatic method.


excel, paste, tranpose, link, cells

Transpose and Link Data to Source in Excel

When you copy and paste cells in Excel, you can either paste them as links or transpose them. Excel doesn’t allow doing both at the same time. Unfortunately, you often need to link and transpose. But there are three ways for accomplishing this: Doing it manually, using the array formula {=TRANSPOSE()} or Professor Excel Tools.