» Defining a Range Name

CATEGORY - Excel Range Name VERSION - All Microsoft Excel Versions

To define a range Name, use one of the following two techniques:

Type the text directly in the Name box
1. Select cell A1.
2. In the Name box, type the text, and then press Enter.

Define a Name using the Define Name dialog box
1. Select cell B1.
2. Press Ctrl+F3.
OR
From the Insert menu, select Name and then Define.
3. Type the text in the Names in workbook box, and then click OK.
Screenshot // Defining a Range Name

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 2.90 Views: 67438

Naming columns

T Posted on: 31-12-1969

How can i re-name rows (1,2,3,..) and columns (a,b,c,..) to a custom setting

delete duplicate record

alok bhardwaj Posted on: 31-12-1969

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