Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I name a group of cells?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I name a group of cells?
1 Define the group of cells by: InsertNameDefine 2 Create a name for the group of cells, in the refers to box, indicate location of your group of cells. 3 Select cell where you want to put the hyperlink 4 InsertHyperlink 5 Select Place in this document 6 Select the named range under Defined Names Hope this helps barronka Wrote: 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. -- kwiklearner ------------------------------------------------------------------------ kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909 View this thread: http://www.excelforum.com/showthread...hreadid=520600 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete a group of alternate cells | New Users to Excel | |||
Formatting a group of cells for text | Excel Discussion (Misc queries) | |||
Have VBA delete a group of cells, move information over, then add | Excel Discussion (Misc queries) | |||
How can i copy a group of cells in a row to a column? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) |