Hi

Welcome to my tips newsletter for March - how to get rid of hyperlinks in Excel. By default, Excel turns any email and website address into blue and underlined hyperlinks, so that when you mouse-over them, the cursor turns into a hand and if you click it or highlight several cells with an address in them, new emails annoyingly open up for however many email addresses were highlighted, so that you spend the next half hour or more closing them all down! Here's how to turn hyperlinks back into normal text and also, how to prevent them turning into hyperlinks in the first place.

Office 2007 - Heaven or Hell? Have you experienced the new Office 2007 yet? Got the hang of the new "ribbon"? There's certainly been a lot of debate as to whether Microsoft should have so drastically changed something that didn't need "fixing", but like it or not, we will all have to upgrade to Office 2007 at some stage. I'd like to hear your views on Office 2007. Join the debate and let me know what you think of it by answering my quick survey below.

I hope you find the tips useful.

In the meantime, have a magnificent March!

Vee Smith

My Super VA
VA and Business Services

'helping busy professionals make effective use of their time'
020 8421 6842 (tel)
0771 240 0861 (mob)
0871 528 9390 (fax)
vs@mysuperva.co.uk (email)
www.mysuperva.com (web)
www.workingmumpreneur.typepad.com (blog)
40 Birkdale Gardens, Watford WD19 7AW, UK

How to Remove Hyperlinks in Excel

By default, Excel turns any email and website address into blue and underlined hyperlinks, so that when you mouse-over them, the cursor turns into a hand and if you click it or highlight several cells with addresses in them, several new emails annoyingly pop up for however many email addresses were highlighted, resulting in the next half hour or more closing them all down! Here's how to turn hyperlinks back into normal text and also, how to prevent them turning into hyperlinks in the first place.

There are essentially 3 ways to remove them easily, manual removal one by one (suitable if there are only one or two); manual removal of a batch of adjacent cells in one operation and thirdly; prevent them from turning into hyperlinks to start with.

How to Remove a Single Hyperlink:

Right click on the hyperlink (email address that has been blued and underlined and cursor turns into hand when moused-over)
Select "remove hyperlink"

How to Remove Multiple Hyperlinks in One Operation:

In an empty cell enter the number "1"
Hit enter on keyboard
Right click this cell and select "copy"
Highlight all the cells with hyperlinks (note they must all be adjacent)
Right click and select "paste special"
Select "multiply"
Hit "OK"

How to Prevent Hyperlinks Occurring in the First Place:

In Excel 95 - 2003:

On menu bar, select "Tools",
Select "Autocorrect Options"
Select the tab "Autoformat as you type"
Check or tick the box for "internet and network paths with hyperlinks"
Ok

In Excel 2007:

Click the Office button (the round Office icon on top left hand corner)
Click "Excel Options"
Click "Proofing" from side menu
Click "Autocorrect Options"
Select the tab "Autoformat as you type"
Check the box for "internet and network paths with hyperlinks"
Ok,
OK

Office 2007 - Heaven or Hell?

Have you experienced the new Office 2007 yet? Got the hang of the new "ribbon"? There's certainly been a lot of debate as to whether Microsoft should have so drastically changed something that didn't need "fixing", but like it or not, we will all have to upgrade to Office 2007 at some stage. I'd like to hear your views on Office 2007. Please answer the short survey below by replying to this email and putting in your answers:

Have you made the upgrade to 2007?
If no, what's holding you back?
If yes, what features do you love?
Which features do you hate?
How easy did you find it to get used to?
What would you have liked to have had to help make the transition easier?

All answers will be treated confidentially, but I will publish a general opinion in my next newsletter.

How to be a Word Whiz Workshop

How to save time using MS Word
Tips and Tricks you won’t find in the Help Files

Did you know that there are tools in Word that can help you streamline the time it takes to create professional looking documents with a consistent look and feel?

In conjunction with The Athena Network, I shall be sharing the secrets on how to use 3 tools that will save hours of searching through other documents to use text you've used before, avoid loosing and overwriting old documents and creating an effortless and consistent way to present professional looking documents in the "How to be a Word Whiz" workshop.

Date: Friday 25th April 2008
Time: 10am to 1pm
Venue: The Ethorpe Hotel
Address: Packhorse Road, Gerrards Cross, Bucks SL9 8HX
Cost: £75 including refreshments and workbook

To book a place or to find out more information, reply to this email or call me on 020 8421 6842.

Until next month....

Vee

www.mysuperva.co.uk

Please feel free to forward to your friends and colleagues who might find this useful.

If you have received this from a friend, why not subscribe at http://www.mysuperva.co.uk/newsletter_signup.aspx

You have received this email because you have expressed an interest in My Super VA and/or we have met at an event where our details have been exchanged.

If you have received this in error, or do not wish to be included in future communication regarding events, newsletters and tips from My Super VA, please use the Unsubscribe link below. My preference is, of course, that you remain subscribed so that we can keep in regular communication.

Hi