How to Use the Custom Format Cell in Excel

In this article, we will learn about how to use the Custom format cell option in Excel. Custom format option let’s you change the format of the n...

How to Compare Text in Microsoft Excel

In this article, we will focus on how to compare strings of two cells in excel to find out the unique entries out of both the columns. There are many...

What is Format Cells in Excel?

We use Format Cells to change the formatting of cell number without changing the number itself. We can use Format cells to change the number, alignmen...

Conditional Formatting in Pivot table

Original Question:- How to replace blanks in Pivot Table with alternative text? I can use a custom conditional format to remove (blank) from a P...

Format Painter to Copy Column Width & Row Height in Microsoft Excel

In this article, we will learn how to use the format painter to copy column widths and row heights in Microsoft Excel. Format Painter is a basic fe...

Hiding the Display of Zero Values in Excel

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 ...

Changing the Default Style in Microsoft Excel 2010

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...

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube