MS Excel is a most frequently used spreadsheet developed by Microsoft. One can use Excel spreadsheets in many purposes like data management, pivot table generation, report filtering, graphical presentation and many more things that make our life easier. This article will try to tell you some secrets of MS Excel which may give you relief in your difficult times.
Copying spreadsheet from one Excel file to another
Copying spreadsheet from one Excel file to another is a very simple task. Just open both of the Excel files. Open the spreadsheet that you want to copy into another Excel file. Click right mouse on the spreadsheet name below. Click on move or copy. You will see the move or copy window. Select the Excel file from the drop-down menu of To book option to which you want to copy the spreadsheet. Select the spreadsheet from the Before sheet option to choose exact location where you want to copy the spreadsheet. Don’t forget to check the Create a copy option below. Then click on OK. You have just copied your desired spreadsheet from one Excel file to another.
Combining two spreadsheets
Suppose you have two spreadsheets, one containing a part of a data set and another containing the remaining part of the same data set. You want to merge these two spreadsheets to generate the complete data set. This is also a simple task to do. Open both of the spreadsheets. Click on the spreadsheet containing first portion of the data set. Go to the next row of the row where last case exists. This is the row where data from another spreadsheet will be copied. Select the first cell of this row where we usually put ID. Now, type “=” on this cell. Open the second spreadsheet. Select the first cell of the row where the first case of this spreadsheet exists.
Now, click on Enter. You will see the first cell data of first case of the second spreadsheet on the first cell below the last case row of the first spreadsheet. Your task is almost done. Just copy this cell and paste it row-wise until the first case of the second spreadsheet is fully copied here. Then copy this case and paste it column-wise until all cases from the second spreadsheet is being copied here completely.