Monday, July 19th, 2010

Format Hyperlinks in PowerPoint 2010

PowerPoint format hyperlinks Format Hyperlinks in PowerPoint 2010If 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.

Labels: , , , ,

Categories:Uncategorized

posted by Helen Bradley @ 1:30 pm5 Comments links to this post

Wednesday, January 14th, 2009

Custom formats in Excel

formatting 707950 Custom formats in Excel
Ok, so here’s the scenario, you want to enter a value like 20Kg (or 44 lb) into an Excel cell. All goes well until you try to multiply the value. Instant disaster. Your number isn’t a number it’s a piece of text and you can’t multiply or add text. You can’t divide or minus text or find the 4th power of it either – you get the idea.. it’s basically a useless entry – pretty but useless.

SO, how do you format a cell so it displays the Kg after the number but so it still treats the entry as a number? I’m so glad you asked!

The answer is to create a custom number format. Click the cell or a range of cells and choose Format > Cells > Number tab. Select the Custom entry and type something like 00.00 “kg” in the text box and click Ok. Now, enter the numbers again as 20 or 40 etc and the kg will appear automatically after the number courtesy of the format – and the number, well it’s still a number so you can add, multiply, divide and do all sorts of other wonderful things to it as you like.

You can also add the text before a number. So, for all those lovely Canada dollars I get paid by the folk at Hub Digital Living where I write a monthly Office column, I type a Custom format like “CAN” 00.00 in my sheet where I record my payments. It’s all so easly when you know how.. and now – you do too..

For more tips and tricks and helpful Office columns, visit Projectwoman.com

Labels: , ,

Categories:Uncategorized

posted by Helen Bradley @ 11:47 pmNo Comments links to this post

Wednesday, September 19th, 2007

Formatting table cells in Word

tableformat 757769 Formatting table cells in Word

Since Microsoft Word 2002, it has been possible to format a series of cells in a table all at the one time, even if they are not contiguous (a lovely word that means not side-by-side).

To do this, select the first cell then Control + click on the other cells that you want to share the same formatting. Once all the cells are selected you can apply a formatting such as a shading to those cells. Note, that the Shading button on the Tables and Borders toolbar in Word 2002/2003 is the one to use, the one on the Drawing toolbar is the Fill button – it looks the same but doesn’t work the same!

Selecting and formatting non contiguous cells all at ones makes it a quicker process to format a table than it would be if you selected and formatted each cell individually.

However, of course, the F4 key still works in cells in a table so you can, for example, fill a cell with a shading color or a format option and then click in another cell and press the F4 key and have that format applied to this cell too. The F4 key is a repeat key which repeats the previous command and it’s a great key to learn to use anytime you’re working with Word.

For more tips and tricks and helpful Office columns, visit Projectwoman.com

Labels: , , ,

Categories:Uncategorized

posted by Helen Bradley @ 4:01 pmNo Comments links to this post