Excel Power Tool

How to remove duplicate records from multiple excel files?
  • Register: To register the "Excel Power Tool" click on the "Enter Activation Key" Button and fill the Registeration Detail with the Activation Code.
  • Buy: You have to Buy "Excel Power Tool" to get Activation Code. You Can Buy it by Clicking on "Buy Activation Key" button.
  • Try It: You can use demo version of "Excel Power Tool" by clicking on "Continue in Demo Version" Button.
registration registration

Step 1: Add Files (.xls, .xlsx, .xlsm). Add Files - To choose files click on Add Folder option on the menu. Or if you have a folder full of excel files then you need to click in Add Folder. When you will click on Add File a window will appear on the screen asking you to choose the excel files. After you choose the files they will be dumped in the tool as shown below. .

Excel Power Tool Excel Power Tool

To begin, first click on "Add Files" option and choose the excel file where you want to make changes or you can choose "Add Folder" option to dump a whole folder full of files.

Excel Power Tool

As soon as you will click on that option a small box will come on your screen. You can choose any of these three options according to your need, like- Choose Remove All Excessive Spaces to eliminate extra spaces from excel files Choose Remove All Leading Spaces to eliminate leading spaces from excel files Choose Remove All Trailing Spaces to eliminate trailing spaces from excel files After choosing the needed option you have to click on OK to proceed

Excel Power Tool

For this purpose you have to again choose the files or folder following the same process. Then again you need to go to "Select Command Type" and click on it. From the listed options you have to select "Remove Duplicates".

Excel Power Tool

After you have chosen the option a box appears on your screen. You have to choose one of the four options according to your need. Choose Remove All Duplicate Rows to eliminate all the duplicate rows present in the file. Choose Remove All Duplicate Rows (Keep First) to remove duplicate rows leaving the first one. After choosing the required option click on OK to proceed .

Excel Power Tool

To remove empty rows, first of all select choose files by clicking on Add Files and drop them. Then go to "Select Command Type" option click. The list of options will scroll down on the screen. Click on Remove Empty Rows from the list. .

Excel Power Tool

Soon after clicking Remove Empty Rows a box will pop on the screen in which you have to choose Remove All Empty Rows to clear all empty rows currently in the file. Then click on OK to proceed.

Excel Power Tool

To remove empty columns from files first you have to choose and drop those excel files. To get them click on Add Files and choose those files from which you want to remove empty columns. Then go to "Select Command Type" option and click on it. Choose the option "Remove Empty Columns".

Excel Power Tool

When you will click on Remove Empty Columns a box will come on the screen. Here you need to choose Remove All Empty Columns to clear all empty columns currently in the file. After choosing that option click on OK to begin the process.

Excel Power Tool

First of all choose the file by clicking on Add Files options from which you want to remove empty sheets. Then dump those files and go to option "Select Command Type". From the lists choose "Remove Empty Sheets".

Excel Power Tool

Now you will see a new box on the screen. In that box you have to select the option Remove All Empty Sheets and then click on OK to start the process.

Excel Power Tool

To unhide the hidden sheets in excel files first choose those file where you have to unhide the sheets. Then click on "Select Command Type" and choose the option "Unhide Hidden Sheets".

Excel Power Tool

When you will click on that option a box will show on the screen. From this box you will have to click on the option "Unhide Sheets". Then click on OK to start the process.

Excel Power Tool

The first foremost thing you need to do is choose the file by clicking on "Add Files". Now select the files and dump them in the software. Then click on "Select Command Type" from the software bar above. A list of options will appear from which you need to click on "Remove Objects"

Excel Power Tool

Now when you will click on that option a box will emerge on the screen with few sub-options in it. You need to choose a sub-option from the enlisted ones according to your need. Then after choosing the option click on OK to begin the process.

Excel Power Tool

The first step is to click on Add Files and choose the files from which you wish to remove images. Then go to option "Select Command Type". From the list that has scrolled down click on "Remove Images" option.

Excel Power Tool

Now after you have chosen the option a box will appear on the screen where you will see four to five options. In this list the bottom will be "Images" option. You have to choose that option and click on it. Then click on OK to start the processing.

Excel Power Tool

To Split the sheets first of all go to option "Select Command Type" and then click on it. Select an option from the list named as "Split sheets into Separate Workbooks". After you have clicked on that option the sheets of the files dumped will be changed into a separate workbook.

Excel Power Tool

Now to merge files you have to follow the same process. Choose the option "Select Command Type" and click on the option "Merge Workbooks into single Workbook". All the files you have dropped will be merged.

Excel Power Tool

To save the files you need to give a path to it. Through this path you have to select a place where the folder will be saved. For that you will have to go to the menu above an click on "Folder Options" .

Excel Power Tool

To initiate processing you have to click on start. After you click on that the software will begin the treatment. You can halt the processing in between by just clicking on "Stop".

Gujarati Excel Billing Software
Offer

We are experiencing some issues with our website & database due to migration of server Please be patient as it will be restored soon Also existing users please don’t sign up again and wait for the full restoration