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.

• 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!...
• HOLLAND - Stem cells to create intestinal epithelium Image by RiffRaff via Flickr Artificial intestines could be created thanks to stem cells. Intestinal stem cells grown in the...
• 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...
• Useful shortcuts for data analysis in Excel Excel provides shortcuts of various command, from formatting to printing. Find your favorite shortcuts of excel when dealing with data...
• Grocery Shopping for Better Health pt 3 This is part 3 in a 4 part series about knowing how to read labels and excel at grocery shopping...