A & Q Collection aqcollection.com

Question
I currently have an Excel spreadsheet.
Column "A" has URLs, but only about 20% of them are "live URLs" (working).
Is there a way to format cell A to make ALL URLs "live" or do I have to edit each and every one?
SIMPLE instructions needed if it's a "can do".
And thanks in advance for any assistance!


Answer

1. Tools
2. autocorrect options
3. Auto format as you type
4. check the box

If you already have them typed, double click in them should make them hyperlinks.

Answer
You just saved me about an hour's worth of work.