Highlight or select the range of cells. Ctrl+Shift+F3 Select the top, left, bottom, right most column, or row to use to Name your selected range. This does not work on one cell. You can however, right click from your active cell, select "Name a range", and type in the name. This works for a single or range of cells.