Automatically Defining Names for Ranges in Lists in Microsoft Excel 2010

In this article, we will learn how we can automatically define the names for ranges in lists in Microsoft Excel 2010.

Let’s take an example to understand how we can define the names for ranges automatically.

We have a workbook in which we have 3 lists in 3 columns. Column A contains month name, column B contains Week name and column C contains Serial number.

img1

Follow below given steps to automatically define the names for ranges in lists:-

  • Select any cell in the data area and select the Current Region by pressing Ctrl+Shift+* on your keyboard.

img2

  • Press Ctrl+Shift+F3.
  • ‘Create Names from Selection’ dialog box will appear.
  • Check to Top Row and Left Column.

img3

  • Click on OK.
  • Each row and column range now defines its own range name.
  • To see the automatically defined name, Press Ctrl+F3 on your keyboard.
  • Name Manager dialog box will appear.
  • Now you can see the every defined names.

img4

In this way we can create many define name through excel Name Manager.

Users are saying about us...

  1. “Thanks in advance.
    When I open any file the column headings are reversed (instead of A-Z they are Z-A. The scroll tabs and bar are on the left side. The row numbers are ok. “

  2. “Thanks in advance.
    When I open any file the column headings are reversed
    (instead of A-Z they are Z-A. The scroll tabs and bar
    are on the left side. The row numbers are ok. “

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube