Wednesday, July 11th, 2007

Configuring Themes in Word 2007

While themes are a gimme for working in PowerPoint, they don’t appear to be as useful in Word as they don’t seem to do much to format the document if you’re not using diagrams or shapes. However the problem isn’t quite this simple. Themes in Word won’t apply to the text in the document if you don’t have a style in place. Use the Home tab to view the Styles option and click Change Styles and select a Style Set. Now, when you choose the Theme, the styles available change.

All of a sudden, themes make a little more sense in Word 2007.

Helen Bradley

Tuesday, July 10th, 2007

My Places in Office 2007

I use the My Places option all the time to add folders to the left hand side of the File Open and File Close dialogs. If you do this too and if you use Office 2007 you’ll find very quickly that the Add to My Places option isn’t where you expect it to be. Instead of being accessible from the Tools menu, you simply right click the icons on the left of the dialog and you can add the current folder to the list.

In all fairness, it makes more sense to be here than having the option where it was -it’s just if that’s where you expected it to be, it ain’t there no more.

Helen Bradley

Saturday, July 7th, 2007

Close everything NOW! Excel 2007 and PowerPoint 2007

Yum, it’s like a boss key for Excel and PowerPoint. Double click the Office button in either application and it’s like a Close All tool – everything closes quickly and automatically.

Doesn’t work in Word, wonder why not?

Helen Bradley

Thursday, July 5th, 2007

Multipage tables in Word

When you make really big tables in Word that span multiple pages you get into trouble when you try to read the text on the second and subsequent pages of the document because there are no table headings displayed.

Your gut reaction migth be to edit the table and to insert rows for the headings on each of the pages – good idea but there is a better one.

Select the rows at the top of the table that contain the headings – this might be one row or it could be a couple. Now choose Table, Heading Rows Repeat. Voila! Word does all the work for you – it puts the duplicate headings anywhere they need to be – if you add more text to the table or remove text – the headings are always in just the right place – much less effort and a much better end result.

Helen Bradley

Wednesday, July 4th, 2007

Boy was this annoying! HP Vista computers…

Ok, I just bought a new Vista tablet from HP. Let me start by saying it’s a great machine… but, here’s the rub, there is this very annoying popup that keeps appearing asking if you want to set up HP internet services. Well I would say yes if I hadn’t already done it so I click no and don’t ask me again and I get back to watching my Netflix Watch Now movie. Only a few minutes later, there it is again and again and again and again.. ad nauseum, every day every few minutes when I’m surfing the web already – talk about annoying and very stupid to boot.

Eventually I can see that saying Don’t ask me again is not going to work so I go looking for a solution. The solution is that this popup is running via a scheduled task. To stop it, log in as administrator if you aren’t already, open Control Panel and locate and find the Administrative Tools option. Locate Scheduled tasks and you’ll find the InternetServiceOffers option in the running tasks list which is what is causing the issues. Right click this option and disable it and, voila! no more stupid prompt and I can get back to my movie.

Happy 4th!

Helen Bradley

Wednesday, July 4th, 2007

Excel – highlight cells containing formulas

There’s no shortcut way to color code cells in Excel which contain formulas but this workaround is simple and fast.

Choose Edit, GoTo, Special button and click Formulas and then Ok. Now fill the cells with a color using the Fill Color tool.

It’s now clear which cells contain formulas and those that do not.

Helen Bradley

Monday, July 2nd, 2007

No new file when you launch Excel

When you open Excel you will, by default see a new blank workbook. If you’d prefer to see nothing at all you can do so by altering the Excel startup icon.

Right click it and choose Properties and then in the Command area add the text /e at the end after the double quotes. Now Excel will launch without the splash screen and with no new workbook.

Helen Bradley

Page 2 of 212