Prantick Bala

In dynamic data validation, when you add a new entry to the source list, the entry is automatically added to the data validation list. It is a very efficient ...

Actually, Excel doesn’t have infinite columns. Excel 2007 and all the newer versions have 16384 columns in total. The number is so huge for most of the uses of ...

In Excel, you may have duplicate data in the same columns. These data may be a part of a unique set when you consider all the data along a row. To be ...

If you want to copy your Excel worksheet to another workbook or to a new workbook with Microsoft Visual Basic Application, this is the right place for you. In ...

If you cut or copy any text or image, it will be saved in the clipboard first. After that, you can paste the text or image anywhere such as in Word files and ...

Copying data, based on criteria, from one sheet to another is one of the frequently done tasks in Excel. If you have a lot of rows and want to copy them on ...

With the CONCATENATE function, you can join two or more texts altogether. Unfortunately, there is no way to bold text in the Concatenate formula directly. But ...

If you want to know how to calculate the duration of time in Excel, you will find this article helpful. In this article, I’ve discussed 7 different ways to ...

To find out your company's growth per year or to forecast the sales for next year, forecast the sales for next year you may need to calculate the average ...

While working with a large Excel worksheet, you may need to freeze different numbers of rows. It will allow you to navigate through your entire worksheet ...

While working with a large Excel worksheet, you may need to freeze the top row and first column. It will allow you to navigate through your entire worksheet ...

Rank average is one of the methods of ranking data where the same values get an average rank. In Excel, there is an inbuilt statistical function- to rank data ...

When you print an Excel sheet, you may want to print the sheet with page numbers. In this article, I’ll introduce you to 5 easy ways to print the page number ...

Print area specifies a range of cells from an Excel worksheet which will be printed instead of the total sheet when you give the command to print. It is a ...

Sometimes you need to link one Excel workbook with other workbooks to import data or to use in a formula. In this article, I’ll show you 4 effective methods to ...