MS Office FAQ

Submit Interview FAQ
Home » Interview FAQ » MS OfficeRSS Feeds

What is a range? How can you name ranges?

  Shared By: Shruti Sharma    Date: Jan 20    Category: MS Office    Views: 1114


Range is the group of two or more adjacent or non adjacent cell in a worksheet.
When you define a name that refers to a cell or range of cells in another workbook, you create a link known as an external reference. When you do this procedure, make sure the workbook you want to refer to is open and that it has been saved.

a. In the workbook in which you want to create the external reference, point to Name on the Insert menu, and then click Define.
b. In the Names in workbook box, enter the name for the external reference.
c. If the Refers to box contains a reference, select the equal sign (=) and the reference and press BACKSPACE.
d. Activate the workbook that contains the cell you want to refer to by clicking the name of the workbook on the Window menu.
e. Select the cell or range of cells you want to refer to.
f. In the Define Name dialog box, click Add.


Didn't find what you were looking for? Find more on What is a range? How can you name ranges? Or get search suggestion and latest updates.

Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].