Hello everyone,

I'm relatively new to Excel, although I'm using an older version - 2004 for Mac, version 11.6.6. I've found that working with hyperlinks (or rather, trying to work without them) can be frustrating. I have two questions:

1) Can I change a default setting somewhere so that I don't automatically get a hyperlink whenever I type a web address in a cell?

2) If I do end up with a hyperlink in a cell and I want to remove it, is there a way to do so without losing the formatting I've chosen for the cell? Currently the hyperlink goes away, but so do any colors and alignment I've chosen. I end up doing lots of tedious corrections. There must be a better way!

Thanks in advance for your help!

Andy