In this article, we will learn how we can define a range name in Microsoft Excel 2010 and 2013.
There are two techniques to define a range name.
Let’s take an example to understand how we can define a range name in Microsoft Excel.
We have month name list in column. Now, we want to define the name.
First technique to define the range name
Follow below given steps:-
Second technique to define the range name
This is all about how one can define a named range in Microsoft Excel.
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.
"hi dear sir,
i just want to know that is it any formula which can we delete duplicate record in selected range of cell's and restrict a cell does not take duplicate records.
thanks "
How can i re-name rows (1,2,3,..) and columns (a,b,c,..) to a custom setting