Monday, July 19th, 2010

Format Hyperlinks in PowerPoint 2010

If you’ve added an email link or a website URL to a PowerPoint slide, you’ll know that PowerPoint 2007 and PowerPoint 2010 automatically format the hyperlinks for you.

Because PowerPoint doesn’t use styles, it’s not obvious exactly how the formatting gets applied and how you control it.

The first thing to know is that you simply can’t control the underlining, it’s there and it’s there to stay. You can, however, change the colors used.

Click the Design tab > Colors > Create New Theme Colors, locate the Hyperlink color and change it to something different if desired. To control the Followed Hyperlink color, select that option and change it.

You now need to save your changes as a custom color scheme, so type a name for your color scheme and click Save.

Now the chosen hyperlink color and followed hyperlink color will be used to format the hyperlinks in your PowerPoint presentation.

Helen Bradley

Thursday, July 1st, 2010

Don’t spell check this – Word 2010

do not spell check this text

I write a lot of code in Word documents, Excel spreadsheets and in PowerPoint slide shows. I’m not totally unusual in including macros in my files as well as detailing the macro code within the various documents.

However, as you can imagine, Office applications spit the dummy when they see code and everything gets squiggly lines under it. Which makes your documents look horrible when anyone who has Spell Check as you type enabled opens one of these documents.

In Word 2003, 2007 & 2010 I can stop proofing by selecting the code, double click on the proofing language in the program Status bar and reselect the language to use and click Do not check spelling or grammar. For some reason if you don’t reselect your language in Word 2007 and 2010 the Do not check spelling or grammar option isn’t applied – go figure. It took me a while to work this one out.

In PowerPoint 2010 and 2007 just choose Do  not check spelling and it works fine. In PowerPoint 2003 where I spent this morning, there’s actually a language entry for No Proofing.. so select that and your text won’t be spell checked.

Helen Bradley

Thursday, December 4th, 2008

Yes Master…


I love it when folks call me or email to pose questions. It’s hard when you work with apps every day to remember there are folk out there for whom Word and Excel are a daily challenge and not necessarily in a good way.

Today’s came from my partner, a PowerPoint file with a serious case of bloat. Now, if it were a cow, you’d do something rather disgusting with a knife between the ribs – no it doesn’t kill them, it cures them – lets all the nasty gasses out. In PowerPoint, the solutions are different. One cause in this file was the lack of use of a Slide Master. You see the person (not my partner, she’s better at PP than that) put a wonderful but very large image on all the slides – each one had its own version of the image – instant bloat.

The solution, next time would be to build the file properly and put that image on the background layer of the Slide Master – when you do this it automatically gets added to all slides – if you have 100 slides you still have only one image – instant slimming for your file.

If you need a plain slide – no image, you create two masters – one with an image and one without – use the master you need for the slide you’re creating. Pretty easy stuff and makes a presentation much easier to email – that was the problem here – at 7Mb it was too big for most folk’s email inbox so it bounced right back and something that big doesn’t bounce so much as go splat!

The solution I used on this file was different. I didn’t want to go rebuild someone else’s file at no charge – so I grabbed a great app called PowerPoint Minimizer – it shrinks PP files really really small so folks like me can look good by solving a problem that everyone else has spent hours on in a matter of minutes.

Find PowerPoint Minimizer here for download. Best thing is you can trial it and see how it works.

Helen Bradley

Friday, March 21st, 2008

What’s in a name? Auto_Open or AutoOpen

Sometimes you wonder if the folks up at Redmond are laughing at us behind our backs. Really, do they deliberately set out to confuse us or are they just that plain disorganised?

Today my quandary involves Auto_Open and AutoOpen. These are two special macro names. The first, Auto_Open is Excel’s special named macro that runs automatically when the workbook containing it is opened. AutoOpen is the Word equivalent. It makes no sense that one has an underscore and the other doesn’t – it just makes life for us VBA folk a little more confusing than it should be.

The other macros Auto_Close and AutoClose work the same way, Auto_Close is the Excel macro name – call a macro by this name and save it in your workbook and it will run whenever you close the workbook. In Word, the name is AutoClose.

To add to the confusion, PowerPoint doesn’t support either of the naming conventions, in fact, you can’t create auto running macros in PowerPoint the same way you do in Word and Excel. The workaround is cumbersome, you need to create a PowerPoint add-in that includes the Auto_Open subroutine. Load the Add-in and PowerPoint will run the code in Auto_Open it loads and ditto for subroutine called Auto_close – it runs when the add-in is unloaded – which happens automatically when you exit PowerPoint. Learn more about how to do this in this KnowledgeBase article.

Thanks Redmond, we are now officially confused!

Helen Bradley

Wednesday, March 12th, 2008

PowerPoint to Go – on your mobile or iPod

You can put a PowerPoint presentation on almost any mobile device including your iPod.

Provided your mobile device supports JPEG format images – most will – open your presentation in PowerPoint and choose File, Save As and select the JPEG format, choose All Slides and PowerPoint will save the slides as JPEG format files that you can now upload to your mobile device as you do any other photos.

If your mobile lets you play images as a slideshow – voila! PowerPoint to go!

Helen Bradley

Saturday, March 8th, 2008

No new line in PowerPoint

When you are entering text on a PowerPoint slide if you want to create a new line but not apply a bullet to it press Shift + Enter at the end of the preceding line.

This creates a new line but does not start a new paragraph which is the trigger for the bullet to be created.

This also works in Word – you can create a new line in a numbered paragraph but without adding a new number by pressing Shift + Enter.

Helen Bradley

Monday, April 30th, 2007

PowerPoint – to fit or not – it’s your choice

PowerPoint has a handy tool (or a very annoying one – depending on your perspective) for adjusting text on a slide.

In PowerPoint 2003 and earlier choose Tools > AutoCorrect Options > Autoformat as you Type and you will see that there is an option called Autofit body text to placeholder. Enabled this and all the text that you type on a slide is automatically sized to fit the slide – you can type gobs of text and it just keeps getting made smaller and smaller as PowerPoint shoehorns it in so it fits.

If you disable this option, you get to control the slide’s text size yourself – a rough rule of thumb is that if it goes over the edge – it’s too much text for one slide so make another one or edit your text.

Autofit is a tool you can disable or enable as you like – once you know it’s there – it’s your choice what you do with it.

Helen Bradley

Thursday, April 26th, 2007

PowerPoint Master shortcut

If you’re like me and you use the PowerPoint master view a lot—and you really should because it allows you to control the formatting of all the slides in your presentation from one place—you will know that there’s no quick way to open into master view.

That is unless you read this tip.

To quickly access the slide master view hold Shift and click the Slide View button in the bottom left corner of the PowerPoint screen. This automatically opens master view allowing you to work on the slide master then close it and return to your PowerPoint presentation. Simple, when you know how?

Helen Bradley

Thursday, March 29th, 2007

Getting alignment right (or left), in PowerPoint

Let’s face it, it’s easy to dump pictures, text and charts on a PowerPoint slide but it can end up looking like the dog’s breakfast – at least what I imagine a dog might eat for breakfast.

When you want your slide to look good, you need to have everything aligned neatly on it. To do this, click on the first object to align and Control + click on the second. From the Drawing toolbar choose Draw, Align or Distribute and then an option such as Align left to align both objects so they’re lined up along the left edge of the object that is further to the left on the screen.

In a few simple clicks you can restore order to an unruly slide.

Helen Bradley

Wednesday, March 14th, 2007

PowerPoint Guides

If you’re a perfectionist like I am (on a good day, anyway), you will want everthing lined up neatly on your PowerPoint slides. To do this, use Drawing Guides. To do this, choose View, Grid and Guides and enable the Display Drawing Guides on Screen checkbox.

You’ll see two cross hatch grid lines. To move them simply hold your mouse over them and move one. To create a new guide, hold the Control key as you drag on an existing guide. To remove a guide drag it off the slide.

You can now neatly line everything up that needs to be lined up.

Helen Bradley

Page 2 of 3123