CategoryTips and Tricks

How To Separate Text In Excel

H

Learn how to separate text in excel in this article. There are many ways to do it, so know about it. While you work on Excel, sometimes you create files and sometimes you receive files that are created by others. Many times you would see that the data added is not properly formatted.  Sometimes all values would be in the same cell. It would be really a waste of time to separate each value...

How To Remove Blank Rows In Excel

H

Learn how to remove blank rows in Excel in very simple steps. Read on to know. Blank rows in Excel can come across as something of an eye sore for the users. They can make navigation difficult but Excel gives us several ways in which we can get rid of the blank rows in any worksheet.  How To Remove Blank Rows In Excel Let us know about the different ways it can be done. Delete Blank Rows...

How To Calculate Age In Excel

H

Learn how to calculate age in Excel in simple ways. read the article to know more. It is very easy to calculate dates with the help of date of birth and Excel functions. How To Calculate Age In Excel Let us learn how to: 1. The number of years elapsed till the specified date. 2. The number of Years, Months, and Days elapsed till the specified date. Calculate Age in Excel – Years Only Let’s...

How To Change Date Format In Excel

H

How to change date format in Excel? Well, it is an easy thing to do and is very helpful for all your future work. Here is how to do it. Often while using Excel, we also add dates in our workbooks for many reasons. You might have noticed that sometimes the date format gets changed automatically or we want it in a certain way but it does not appear in that way. MS Excel uses the same date format as...

How To Compare Two Columns In Excel

H

How to compare two columns in excel? or can we even do that? know all about it in this thorough article. While we work on Excel, one of the most common things that we do is that compare two columns. Microsoft Excel gives us the option to compare and match data. Now let us understand how this is done.  How to Compare Two Columns in Excel How to Compare Two Columns in Excel Row-by-Row Upon...

How To Protect Cells In Excel

H

Wondering how to protect cells in Excel? Read the article to learn all about it and more. A cell in Microsoft Excel is a rectangular box that appears in a spreadsheet at the junction of a vertical column and a horizontal row. We also know that we can add rows and columns as many as we wish along with any kind of data we require.While working on an Excel sheet...