Latest stories

How To Remove Scroll Lock In Excel

H

Learn how to remove scroll lock in excel in a simple way. read the article to know more. Has this ever happened to you that you are working on an Excel sheet and you realize that you are not able to jump from one cell to another? This usually happens because of the scroll lock in Excel. How To Remove Scroll Lock In Excel Don’t worry about it as it is easy to correct. Let us know all about scroll...

How To Filter In Excel

H

Know how to filter in excel and make your work more simple and absolutely hassle-free. If you are working on a big file with a lot of data and content, finding something can be very difficult. It will become a big task for you to find out a number or figure from this huge worksheet. But with the help of filters, one can narrow down the research and find exactly what they are looking for. Let us...

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 Apply Round Off Formula In Excel

H

The Round Off Formula in Microsoft Excel is a simple and sophisticated method that is used to minimize all kinds of complications in the decimal values in your data. It is also used to round off the lengthy decimal values to the nearest whole. Let us now know how to round off in Excel. Round-off Formula in Excel – Round-Up The round-off formula in Excel for roundup will help the user round...

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