In this article, we will learn how to hide or display all zero values in a worksheet in Microsoft Excel. While preparing reports, you do not want ...
In this article, we will learn how to change the default style in Excel. You can customize excel the way you want to use on a daily basis. If you fin...
In this article, we will learn how to change color numbers based on the value result in Microsoft Excel 2010. In Microsoft Excel, we can use Condit...
In this article, we will learn how to extract characters from text without using formulas. We use the “Text to Column” wizard to extract character...
In this article, we will learn how we can display the format cells dialog box in Microsoft Excel 2010. We can find this option by right clicking with ...
In this article, we will learn how we can reduce the used area in a sheet in Microsoft Excel. The vertical scroll bar gets shorter as the used area of...
In this article, we will learn how to color unique record in a range. We use the Conditional Formatting option along with COUNTIF function in Microsof...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.