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.



2 thoughts on “Automatically Defining Names for Ranges in Lists in Microsoft Excel 2010

  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>