| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking text
How can I link text to a cell reference?
Depreciation Asset - Cell D4 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking text
On Insert Menu, go to NameDefine
You can type in the name and then in the "Refers To" box, enter the cell reference. HTH, JP On Jan 10, 2:37*pm, krc547 wrote: How can I link text to a cell reference? Depreciation Asset - Cell D4 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking text
I have several cells, I didn't want to have to name each one.
"JP" wrote: On Insert Menu, go to NameDefine You can type in the name and then in the "Refers To" box, enter the cell reference. HTH, JP On Jan 10, 2:37 pm, krc547 wrote: How can I link text to a cell reference? Depreciation Asset - Cell D4 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking text
Can you post some more examples, there is a VBA solution that would be
less tedious. --JP On Jan 10, 2:53*pm, krc547 wrote: I have several cells, I didn't want to have to name each one. "JP" wrote: On Insert Menu, go to NameDefine You can type in the name and then in the "Refers To" box, enter the cell reference. HTH, JP On Jan 10, 2:37 pm, krc547 wrote: How can I link text to a cell reference? Depreciation Asset - Cell D4- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells with text | Excel Discussion (Misc queries) | |||
| Linking Text Box to Cell | Excel Discussion (Misc queries) | |||
| Linking cells with text to each other | Excel Worksheet Functions | |||
| linking text cells | Excel Worksheet Functions | |||
| linking text from excel to word | Links and Linking in Excel | |||
Hybrid Mode
