Line Chart in MS Excel with Conditional formating
Line Chart in MS Excel with Conditional formating Read More »
Cap percentage between 0 and 100! Sometimes, you need to limit values in Excel to a certain allowed range. For example, you might need to make sure that all percentages are between zero (0) and 100%. In other words, prevent negative values and values over 100%. The classic way to do this is with
Excellent in Excel – Cap percentage between 0 and 100! Read More »
There are no builtin formula in Micro Soft Excel for convert number into work however you can use Spellnumber() formula to convert numbers to words in excel which is an add-ins as below step Excel does not include this function in its functions library! But you can enable this function in Excel using VB Script
Do you use Paste Special every day? If not, you could be wasting a lot of time in Excel. Paste Special sounds boring, but it’s a gateway to many hidden and powerful features: Powerful features of Paste Special here! With paste special, we can easily: Convert formulas to static values Paste data without borders Paste
A gateway to hidden and powerful features ! Read More »