Unfortunately, it seems that these two options are mutually exclusive. When you change the original data, the information is automatically changed in the place where you did the Paste Link. It causes Excel to paste references to the original data instead of copied values. You do this by choosing Paste Link from the Paste Special dialog box. If you had previously copied five cells from a column, they are pasted as five cells in a row. This turns the orientation of your copied data ninety degrees. Two of the most popular pasting methods are transposing and linking. You can see these different methods when you choose the Paste Special option from the Edit menu. Excel offers many different ways to paste information that you have copied.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |