MS Excel is a most frequently used spreadsheet developed by Microsoft. One can use Excel spreadsheets for 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 (Microsoft Excel tips & tricks) which may give you relief in your difficult times. Let’s learn two vital Microsoft Excel tips & tricks – one is copying a spreadsheet and the other is combining two spreadsheets.
Microsoft Excel tips & tricks on copying a spreadsheet
Copying spreadsheet, particularly from one Excel file to another is a very simple task. Let’s learn the Microsoft Excel tips & tricks on this. 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.
Microsoft Excel tips & tricks on 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 dataset. You want to merge these two spreadsheets to generate the complete data set. This is also a simple task to do. Here are another interesting tips on this. Open both of the spreadsheets. Click on the spreadsheet containing the first portion of the dataset. Go to the next row of the row where the 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 “=”in 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 the 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 are being copied here completely.