Hello All,
I am attaching Power Utilities Software for empowering excel.
Few Functions of Powerutilities
|
|
| SRL | Descripttion | MenuHead |
| 1 | Count number of Columns in Selected Range | Rows & Columns |
| 2 | Convert Formulas appearing as text to real Formulas | Range |
| 3 | Delete Range Names in File | Range |
| 4 | Format in India Rs lakhs format | Range |
| 5 | Copy Multple instances of a sheet within a file. | Sheet |
| 6 | Put Serial Number in Non consecutive rows with data. | Fill |
| 7 | Break 1st Name & Last Name | Misc |
| 8 | Covert String Date to Real Date | Date |
| 9 | Unhide all Sheets in WkBook | Sheet |
| 10 | Give data for a Range Criteria (Made in separate file) | Mathematics |
| 11 | Copy Values to empty Cells above | Fill |
| 12 | Put Bullets in Front of items like in Word with various items as shown below | Range |
| 13 | Add blank Spaces at end of Text to Make it Specific size | Add |
| 14 | Create Index Clickable Sheet with all Range names | Sheet |
| 15 | Refresh Pivot table in all sheet in current workbook | Miscellaneous |
| 16 | Put External Links in New sheet | Audit |
| 17 | Find All Errors in worksheet & put in a separate Sheet | Audit |
| 18 | Fifter Data in a Column based on Backgroud Color | Column and Rows |
| 19 | Fifter Data in a Column based on Font Color | Column and Rows |
| 20 | Move or Copy Rows based on background or font Color | Column and Rows |
Hope it will be usefull for all of you.
Regards
CAclubindia
