View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default How do I name a group of cells?


"barronka" wrote in message
...
I am trying to set up a hyperlink on one worksheet in a workbook that will
point to and highlight a group of cells in another worksheet in that same
workbook. I am using Excel 2003.


To name cells, highlight them, and do either of two things:

Click Insert, Name, Define, and enter a name.

or:

Click the mouse in the name box at the top left, where you normally see the
address of the current cell. Type a name there for either a single cell, or
whatever range you have selected.