How to Insert a Name in Excel 2007

1. Launch Excel 2007, and click on the cell for which you want to insert a name.
2. Click the 'Formulas' tab in the menu bar at the top of the window. In the 'Define Names' section, click the 'Define Name' button. Thereafter, a box titled 'New Name' will pop-up on your screen.
3. Enter the name you want to assign for the cell in the field displayed beside where it says 'Name.' If you choose a name that has two or more words, you'll need to separate each word with an underscore. Select the scope for the cell by clicking the 'Scope' drop-down menu and choosing to set the name for either the workbook or specific sheet of your Excel workbook.
4. Type any comments you may need to use as reference in the text field located beside where it says 'Comment.' You can use the comment area to remember the new name of the cell or how the cell is being used on your spreadsheet.
5. Click the 'OK' tab to finish inserting the name. Now you will see the name you inserted displayed on the upper-left region of the Excel spreadsheet whenever you click on the cell. For instance, if the cell you inserted a name for was cell F7, now instead of seeing F7 when you click on this cell you'll see the name you inserted. Now you can use this name when creating new formulas for your spreadsheet.