Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

www and excel

Thread Tools
 
Search this Thread
 
Old 29 June 2005, 08:07 AM
  #1  
velohead66
Scooby Regular
Thread Starter
 
velohead66's Avatar
 
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like on 1 Post
Question www and excel

I have some url listed in excel, but the curser does NOT change as it hovers over the link.

This means I have to cut n paste to get to the web site.
A tad tedious.

How can I change the way the curser behaves.
It stays as a thick white cross.
IIRC it should be a 'hand' to work.

Excel 2000, btw.

Thx.
Old 29 June 2005, 10:06 AM
  #2  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Default

Can you give an example of the current cell content ?

Try =HYPERLINK("http://bbs.scoobynet.co.uk","ScoobyNet")
Old 01 July 2005, 07:11 AM
  #3  
velohead66
Scooby Regular
Thread Starter
 
velohead66's Avatar
 
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like on 1 Post
Post

here's what's in a typical cell.....

http://bbs.scoobynet.co.uk/showthread.php?t=437973

.....and appears (in excel of course) as blue and underlined.

I thought there was an Excel flag that you tick/untick that allows a direct click, ie one mouse click and InternetExplorer opens.
A bit like when you click on an e-mail address in IE and Outlook opens.
Old 01 July 2005, 07:17 AM
  #4  
velohead66
Scooby Regular
Thread Starter
 
velohead66's Avatar
 
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like on 1 Post
Post

Ooooh.

I see that the black url (was black when I was writing the post) has now turned blue underlined, as soon as it is posted.

And that the cursor changes to a 'right hand with pointed index finger' as the cursor moves over the url.

That's what I want in excel.
Old 01 July 2005, 12:40 PM
  #5  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Default

1) On the Tools menu, click Autocorrect Options.
2) On the Autoformat As You Type tab, click to check the Internet and network paths with hyperlinks check box.

Cheers,
Dunk
Old 02 July 2005, 04:56 AM
  #6  
velohead66
Scooby Regular
Thread Starter
 
velohead66's Avatar
 
Join Date: Oct 2002
Location: ex UK [SE], now Sunshine State [QLD,AUS]
Posts: 565
Likes: 0
Received 1 Like on 1 Post
Thumbs up

Sorted. I thought there was a flag like that 'somewhere' in excel.

Thanks.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Scott@ScoobySpares
Full Cars Breaking For Spares
61
11 January 2021 03:08 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
33
29 August 2017 07:18 PM
Scott@ScoobySpares
Full Cars Breaking For Spares
7
14 December 2015 08:16 AM
Mattybr5@MB Developments
Full Cars Breaking For Spares
20
22 October 2015 06:12 AM



Quick Reply: www and excel



All times are GMT +1. The time now is 04:22 PM.