|
|||
Add many tools to MS Excel
Actually, this is a general Excel add-in that I have written a few years ago... it adds an extra menu to the Excel menu bar.
You can edit text like combining, change case, add/remove characters, remove hyperlinks in all selected cells, save selected range as HTML (and many other tools to mention here) Hopefully you can use it to make your tasks easier, like managing your users, data etc. It's not exactly a specific tool for webmasters but it may come in handy. Get it from http://www.excel-extools.com (i've released it as freeware) __________________ http://www.jobcity.com.my Last edited by yonghs; 08-04-2007 at 07:56 PM. |
|
|||
I use VBA (visual basic for applications) .................. the tools are actually a collection of macros that i wrote and packaged as an add-in.
__________________ http://www.jobcity.com.my |
|
|||
Most of the tools are for general everyday users but I think webmasters may find some of it useful. I use it everyday to help in the organisation and research for my web projects.
Here is the list I copied from the user guide... ... the complete list of the tools/utilities WITH explanation is at http://www.excel-extools.com/extools_user_guide.php : 1. Introduction 2. Favorite Files 3. Favorite Text Clips 4. Delete Empty Cells in Columns 5. Transpose 6. Reverse Order 7. Check for Duplicates 8. Multiple Selection Copy 9. Save Selection as File 10. Save Selection as HTML 11. Save Selection as Picture 12. View 13. Compare Worksheets 14. Create Worksheet Map 15. Sort Sheets 16. Delete Empty Sheets 17. Hide Blank Rows/Columns at End of Sheet 18. Unhide all Hidden Rows/Columns 19. Unhide all Hidden Sheets 20. Remove Hyperlinks on Worksheet 21. Reset Last Cell 22. Save and Backup 23. Close all Saved Workbooks 24. Close and Delete Current Workbook 25. Close all Workbooks Without Saving 26. List all Fonts 27. Clear Recently Used Files List 28. Conditional Select Cells by Value 29. Conditional Select Cells by Format 30. Conditional Select Rows by Value 31. Select Cell with Max Value 32. Select Cell with Min Value 33. Select Last Cell 34. Select Cells with Error 35. Select Used Area 36. Select to Right 37. Select to Bottom 38. Select all Sheets 39. Select all Empty Sheets 40. Text - Case 41. Text - Insert 42. Text - Trim 43. Text - Remove 44. Text - Combine 45. Copy Cell Formula as is 46. Convert Formula to Constant Value 47. Convert Between Absolute and Relative Reference 48. Perform Math Calculation on Selection 49. Unit Converter 50. Round Numbers 51. Convert Percents to Numbers 52. Convert Numbers to Ordinals 53. Convert Numbers to Text 54. Convert Between Roman and Arabic Numbers 55. Insert Random Numbers to Selection 56. Set Subscript/Superscript 57. Word Wrap On/Off 58. Center Vertically 59. Print Multiple Sheets 60. Set File Path as Header/Footer 61. Number of Days Between Two Dates 62. Add Days to a Date |
![]() |
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| mcmana nak export excel ke mysql | poshberry | Website Programming | 15 | 04-06-2004 04:29 PM |
| can excel VBA 97 be converted to XML? | ymhy_80 | Website Design | 1 | 26-02-2004 01:15 PM |
| convert excel vba to webpage | ymhy_80 | Websites Review and Suggestion | 1 | 20-02-2004 11:50 AM |
| Excel ke MySQL | baddai | Website Programming | 2 | 01-11-2003 10:18 AM |
| transfer excel filr to powerpoint | khairudin | Mamak Stall | 1 | 21-07-2003 01:16 PM |
All times are GMT +8. The time now is 01:31 AM.
Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0 vBulletin skin by ForumMonkeys.com.
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0 vBulletin skin by ForumMonkeys.com.









Cool! Thanks for sharing. There are also testimonials.

Linear Mode

