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.

• 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: 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,...
• Chart takes attentions Chart has been used to explain matters more easily.  Adding charts in documents, reports or even website could attract more...
• 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...
• Should you write your own tax software? Lazy Man and Money posted a reader's question over in the MBN Forums asking for help: Do you have an...