Excel shrink to fit text in cell

In this article, we will learn how to use shrink to fit option to adjust text in cells in Excel. Scenario: Whenever working with data, we al...

How to Merge Data Tables in Excel

A good database is always structured. It means different entities have different tables. Although, Excel is not a database tool but is often used ...

How To Apply Borders In Excel

The borders make any picture a stand out of the crowd. They are also great tool for grouping same kind of object and area. In shorts, Borders are very...

How To Switch Rows and Columns in Excel

While working on excel many times you would want to flip table rows and columns. In that case, excel provides two methods. First is the TRANSPOSE func...

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 lets you change the format of the numb...

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

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.