With this new copied data selected, Press Control + H (or go to Home –> Editing –> Find & Select –> Replace).This will give you the same data set, but here the cells are linked to the original data set (for example G1 is linked to A1, and G2 is linked to A2, and so on). In the Paste Special dialog box, click on the Paste Link button.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |