Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have dragged website addresses from AOL Favourites over to Excel. However
their description (name) rather than their web address is showing. How can I display the website address also |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Kate,
Are they shown as Hyperlinks ? If so, you can edit it (right-click on the linkEdit) and change the text to display to match the address. If they are just text, you are probably out of luck, as how would Excel know what the address should be ? NickHK "Kate" wrote in message ... I have dragged website addresses from AOL Favourites over to Excel. However their description (name) rather than their web address is showing. How can I display the website address also |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Yes they are hyperlinks. However the text to display just shows as th name of
the hyperlink, not the address. If I click on screen tips that shows the web address. How do I get the web address to display? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"If so, you can edit it (right-click on the linkEdit) and change the text
to display to match the address." "Kate" wrote in message ... Yes they are hyperlinks. However the text to display just shows as th name of the hyperlink, not the address. If I click on screen tips that shows the web address. How do I get the web address to display? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mailing addresses from .doc or .txt to Excel | Excel Discussion (Misc queries) | |||
Hyperlinking e-mail addresses from a listing to show a subject lin | Excel Discussion (Misc queries) | |||
Excel IP addresses | Excel Discussion (Misc queries) | |||
How do I sort addresses in excel? | Excel Worksheet Functions | |||
Excel addresses | New Users to Excel |