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.

• Creating and Hosting Blog Carnivals When it is done properly, creating and organizing your own Blog Carnival is a practice that can be truly rewarding....
• 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,...
• 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...
• Create your own backlinks As I mentioned in my Why are backlinks important? post, I'm about to share a way to create your own...
• 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...