You may have a worksheet that contains text that you want to use for names for adjacent cells or ranges. For example, you may want to use the text in column A to create names for the corresponding values in column B. Excel makes this task easy to do.

To create names by using adjacent text, start by selecting the name text and the cells that you want to name.

(These items can be individual cells or ranges of cells.) The names must be adjacent to the cells that you’re naming. (A multiple selection is allowed.) Then, choose Formulas?Defined Names?Create From Selection. Excel displays the Create Names From Selection dialog box, shown in Figure 14-22. The check marks in this dialog box are based on Excel’s analysis of the selected range. For example, if Excel finds text in the first row of the selection, it proposes that you create names based on the top row. If Excel didn’t guess correctly, you can change the check boxes. Click OK, and Excel creates the names.

FIGURE 14-22
Use the Create Names From Selection dialog box to name cells using labels that appear in the worksheet.

If the text contained in a cell would result in an invalid name, Excel modifies the name to make it valid. For example, if a cell contains the text Net Income (which is invalid for a name because it contains a space), Excel converts the space to an underscore character. If Excel encounters a value or a numeric formula where text should be, however, it doesn’t convert it to a valid name. It simply doesn’t create a name—and does not inform you of that fact.

• Buzzirk Mobile - Join The # 1 Team In Global Verge! - Top Sponsor And Best Team With Results - BUZZIRK MOBILE GLOBAL VERGE Buzzirk Mobile - Join the # 1 Team in Global Verge! Zer01 Mobile - Best Work From Home Opportunity -...
• Super Hit Incense Cones Box of 12 Boxes User Reviews Send this to a friend Super Hit Incense Cones Box of 12 Boxes Manufacturer: Shrinivas Sugandhalaya Customer Rating:...
• Excel How-to: Creating a Pivot Table A pivot table is a merely a summary of data in a format that you can manipulate to suit your...
• Google Squared – Matrix of Comparative Search Results More often than not, I would like to see comparative results. For example, let’s say I want to find out...
• Excel How-to: A Macro to Hide Blank Rows on a Spreadsheet Today, a coworker asked me how to hide a row on his Excel spreadsheet.  This was a fairly large spreadsheet,...