Lifetime License

Email Us :- info@technocomsolutions.com

Banner
Banner

Help & Support

Interactive Tour - Video Tour
How to remove extra spaces in multiple excel files?

Q 1 . How to Register, Buy and Activate the software?
  • Register : To register the "Excel Fast Utilities" click on the "Enter Activation Key" Button and fill the Registration Detail with the Activation Code.

  • Buy : You have to Buy "Excel Fast Utilities" to get Activation Code. You Can Buy it From our Site by Clicking on "Buy Activation Key" button.

  • Try Demo: You can use demo version of "Excel Fast Utilities" by clicking on "Continue in Demo Version" Button.

Excel Fast Utilities
Excel Fast Utilities

Q 2 . How to Add Files and Folders to the list?

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 Fast Utilities
Excel Fast Utilities
Q.3. How to Remove Extra Spaces from listed files ?
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 Fast Utilities
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 Fast Utilities
Q.4. How to Remove Duplicates from listed files?

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 Fast Utilities
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 Fast Utilities
Q.5. How to Remove Empty rows from listed excel files?

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 Fast Utilities
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 Fast Utilities
Q.6. How to Remove Empty Columns from listed excel files?

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 Fast Utilities
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 Fast Utilities
Q.7. How to Remove Empty Sheets from the listed files?

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 Fast Utilities
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 Fast Utilities
Q.8. How to Unhide Hidden Sheets from the excel files?

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 Fast Utilities
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 Fast Utilities
Q.9. How to Remove objects from listed excel files?

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 Fast Utilities
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 Fast Utilities
Q.10. How to Remove Images from listed excel files?

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 Fast Utilities
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 Fast Utilities
Q.11. How to Split sheets into separate workbooks?

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 Fast Utilities
Q.12. How to merge workbooks into single workbook

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 Fast Utilities
Q.13. How to set folder option?
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 Fast Utilities
Q.14. How to start processing?
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’.
Excel Fast Utilities
Q.15. How to Deactivate Software to transfer to other PC?
Go to Help Menu. Now click on Deactivate option.
Step 1 : Deactivate from current PC.
Step 2 : Install the software on new PC and Register it with same Activation Key.
Excel Fast Utilities Excel Fast Utilities
Excel Fast Utilities