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 |