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. |
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. |
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 |
All times are GMT +1. The time now is 02:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com