Step 1 : Add Files - In this step you can add MS Excel (.xls, .xlsx, .xlsm, .xlt) files, just click on ""Add Files" button to open file dialog box select files you want to add, you can select multiple files. You can also add all files of a selected folder by clicking on "Add Folder" button, it automatically search the selected folder and add all the MS Excel Files.
Remove Selected : You can remove the selected files from the file list, to select multiple files in file list use Ctrl or Shift key. You can also remove files by pressing DEL key from Keyboard.
Clear File List : You can remove all files from the file list, it will alert you before removing all files. You can also remove files by pressing DEL key from Keyboard.
Add Words : Press "Add Words" button to go to next Step.
Add Words - In this step you can add words or phrase for Find What and Replace With List Set by Set or from a Comma/Line Separated Text file. You can type word and press enter or click "Add to List" button to add the same on Word List below. To add Words from TXT file just check the Find What or Replace With radio button and click "Load List" to Add Words.
Find What: Enter word in this text box to Find. You can also find special characters like Paragraph Marks, Tab Characters, Manual Line Breaks and all special characters available in MS-EXCEL FILE which is not listed here. You can also use Wildcard Characters (*).
Replace With: Enter word in this text box to Replace. You can also replace special characters like Paragraph Marks, Tab Characters, Manual Line Breaks etc. as you do in MS-EXCEL FILE.
Find Options: Before adding word set select your desired find options.
Match Case: Check this option if you want your search to be case sensitive.
Match entire cell content:Check this option if you want your search to be cell specific.
Replace in All Sheets: Check this option if you want to search and replace in entire workbook.
Replace in First Sheet: Check this option if you want to search and replace only in first sheet of workbook.
Remove Selected : Remove all selected words from the List.
Clear File List : Remove all words from the List and Empty the Word List.
Clear Formatting : Clear all applied formatting from the list.
Start: To open the "File Folder Options".
Open Target Folder: To open Separate Folder which will be selected to save the processed files.
Show Log File: To open log File.