Features of Open Excel

Main Menu
1. Copy Multiple Selection: By default, Excel don't allow copy-paste of discontinuous range of data, use this Open XL utility to copy and paste the discontinuous set of data.


Text Utilities Menu

2. Insert Text:
3. Reverse Text:
4. Extract Digits
5. Extract Alphabets
6. Change Case
>>  7. Upper Case:
>>  8. Lower Case
>>  9. Proper Case
>>  10. Sentence Case
>>  11. Toggle Case
12. Trim Spaces
>>  13. Left
>>  14. Right
>>  15. Both
>>  16. Excessive
17. Delete Text
>>  18. Left
>>  19. Right
>>  20. Custom Delete
21. Apply Rainbow Color
>>  22. Dark
>>  23. Light
24. Super/Sub Script
>>  25. SuperScript First Character:
>>  26. SubScript First Character
>>  27. SuperScript Last Character
>>  28. SubScript Last Character


Insert Text Dialog Box



Number Utilities Menu
29. Convert Formula to Values
30. Convert Text to Values
31. Convert Numbers to Text
32. Change Sign
33. Spell Numbers


Row/Column Utilities Menu

34. Remove Empty Rows
35. Remove Empty Columns
36. Insert Empty Rows
37. Select Odd Rows
38. Select Even Rows
39. Select Odd Columns
40. Select Even Columns

Select Utilities Menu

41. Invert the selection
42. Select Entire Row
43. Select Entire Column
44. Select Active Cell Value
45. Based on Type

>>  46. Empty Cells
>>  47. Non-empty Cells
>>  48. Protected Cells
>>  49. Non-protected Cells
>>  50. Hidden Cells
>>  51. Formula Cells
>>  52. Non-numeric Cells
>>  53. Numeric Cells
>>  54. Errorneous Cells
55. Based on Value
>>  56. Odd Numbers
>>  57. Even Numbers
>>  58. Duplicate Values
>>  59. Unique Values
>>  60. Hyperlinked Cells
>>  61. Commented Cells
62. Based on Format
>>  63. Active Cell's Font Color
>>  64. Active Cell's Interior Color
>>  65. Bold Cells
>>  66. Italic Cells
>>  67. Underlined Cells
>>  68. Limited Length Cells


Date Utilities Menu

69. Calculate Business Days
70. Calculate Total Days
71. Calculate Week Differences
72. Calculate Total Months
73. Calculate Total Quarters
74. Select Current Year Dates
75. Select Current FY Dates

Sheet Utilities Menu

76. Insert Empty Sheets
77. Remove Empty Sheets
78. Color Sheet Tabs
79. Remove color from tabs
80. Unhide all sheets
81. SuperHide ActiveSheet
82. Sort Worksheets
83. Export Active Sheet as workbook
84. Export All sheets as Individual Workbooks
85. Merge Worksheets
86. Protect All Worksheets
87. Unprotect All worksheets
88. Save selected sheets

Information Utilities Menu
89. Count Duplicates
>>  90. in Selection
>>  91. of Active Cell
92. Count Selected Cells
93. Count Colored Cells


System Utilities Menu

94. Save Selection as Image
95. Remove Macros
96. Remove External Links
97. Remove Hyperlinks
98. Close Saved Files
99. Force Save
100. Copy all Worksheets to MSWord


Pivot Utilities Menu
101. Remove all Pivot Tables
102. Count Pivot Tables



Chart Utilities Menu
103. Count Charts
104. Run Charts Slideshow
105. Remove all charts



Launch Utilities Menu
106. Launch Camera
107. Launch Calculator
108. Launch Spell Checker



Speak Utilities Menu
109. Speak Cells
110. Stop Speaking
111. By Rows
112. By Columns
113. On Enter


Web Utilities Menu
114. Search on Microsoft Windows Live
115. Search on Google
116. Search on Yahoo
117. Search on ww.ExcelItems.com
118. Search on E-Bay
119. Excel Forum
120. VBA Codes
121. VSTO Codes
122. Excel Downloads
123. Contact a Trainer
124. Donate Us
125. About Us

5 comments: