• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Analyzing Data with Lists > Converting a Range to a List

Converting a Range to a List

Excel has several commands that enable you to work efficiently with list data. To take advantage of these commands, you must convert your data from a normal range to a list. Here are the steps to follow:

1.
Click any cell within the range that you want to convert to a list.

2.
Choose Data, List, Create List (or press Ctrl+L). Excel displays the Create Listdialog box.

3.
The Where Is the Data for Your List? box should already show the correct range coordinates. If not, enter the range coordinates or select the range directly on the worksheet.

4.
If your range has column headers in the top row (as it should), make sure the My List Has Headers check box is activated.

5.
Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint