Without adding 50 empty rows first, the 50 new rows will overwrite existing data in Sheet A. This works, but it is time-consuming and nerves-eating. ![]() You want to copy all the 50 rows from Sheet B to Sheet A so that the new rows are on top (!!!) of Sheet A, but without overwriting existing data in Sheet A.įor doing this, you have first to add 50 rows on top of Sheet A (including a double-check to make sure you have really 50 and not 49), and then copy-paste your 50 rows from Sheet B into Sheet A (pointing at Row 1). ![]() Imagine you have two Excel worksheets, Sheet A with 1000 rows, Sheet B with 50 rows or so. ![]() This one seems to be trivial, but I cannot find a solution, and it is a major workflow obstacle for me when working with Excel 2010:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |