Using the Name box
A faster way to create a name is to use the Name box (to the left of the Formula bar). Select the cell or range to name, click the Name box, and type the name. Press Enter to create the name. (You must press Enter to actually record the name; if you type a name and then click in the worksheet, Excel doesn’t create the name.) If a name already exists, you can’t use the Name box to change the range to which that name refers. Attempting to do so simply selects the range.
The Name box is a drop-down list and shows all names in the workbook. To choose a named cell or range, click the Name box and choose the name. The name appears in the Name box, and Excel selects the named cell or range in the worksheet.
// Related Posted - GOOGLE!
Loading
Related Websites
- Adwords Key Phrase Research For Inexperienced Persons While you embark to your first PPC adventure, you wish to have to keep a small number of keywords at...
- How to Clean Up Outlook Contact Phone Numbers using VBA Introduction [/caption] I got a new phone and when synchronised with Microsoft Outlook, the phone numbers don't dial out properly...
- Hunter Laser Range Finder Scope 600 Yards Deer Bow NIB User Reviews Send this to a friend Hunter Laser Range Finder Scope 600 Yards Deer Bow NIB Manufacturer: GolferSam Customer...
- HOW TO DOWNLOAD YOUTUBE VIDEOS TO CELL PHONE, iPod, PSP!PC Really Easy! This article outlines the steps for HOW TO DOWNLOAD YOUTUBE VIDEOS TO CELL PHONE, iPod, PSP!PC Watch Videos anywhere!...
- How to Find IP Address on Computer [/caption]Each and every device that is connected to internet is associated with a unique number which is referred to as...
