Save all open files in Word 2007 at the same time [Tip] December 8, 2009

I have been trying out the Office 2010 beta. I like it but it’s not so different from Office 2007 that I’d consider forking out for an upgrade.

So, instead I’m honing my 2007 skills as it looks like I’m going to need them for a while longer…

Although it is not possible to save all open documents in Word 2007 the ‘old way’ (ie by pressing Shift and selecting ‘Save all’ from the menu bar), you can add that command to the Quick Access Toolbar.

1. Click the Office button (top left)
2. Click ‘Word Options’ bottom right
3. Click Customize (about 6th option down in the left hand panel)
4. Click the small arrow next to the’ Choose Commands From’ box (it will probably be on its default of ‘Popular Commands’) and choose ‘Commands Not In Ribbon’
5. Scroll down and click on ‘Save All’
6. Click the Add button (in between the two main boxes, in the middle of the window)
7. Click the up arrow (far right)  if you want to change the position of the command on the Quick Access Toolbar
8. Click OK.

And you’re done. Now just click the icon to Save All open documents.

How to stream media to your PlayStation 3 November 23, 2009

I have been away for a couple of weeks, but couldn’t wait to get back to play on my shiny new PlayStation 3.

The main reason I bought it was not for the games but to stream movies from my MacBook and Windows 7 PC to the TV. I had been using an old laptop with its screen removed for this, but it looked pretty ugly and didn’t play nice with the wifi in the house.

So, if you’re looking for a way to do this on your Mac try PS3 Media Server, which is also available for Windows. However, for Windows I prefer TVersity which does so much more than simply stream your own media, it also gives you the ability, for example, to stream podcasts.

Both are free (there’s a pro version of TVersity for ‘premium internet content’).

What do you use for streaming your media?

How to switch between documents in Word 2008 [Mac] November 11, 2009

Quick tip.

Command + ` (tilde/accent key) allows you to switch between open documents in Microsoft Office Word 2008.

DisplayFusion rocks your dual monitor set up November 2, 2009

If you have dual monitors, there’s probably a couple of things you wish you could do. Like set one picture as your background to span both monitors. Or drag a window to the other screen without minimising it first.

DisplayFusion lets you do this and more. My favourite feature is that it lets you add a button to your taskbar to automatically maximise the current window and move it to the other monitor, with just one click. My productivity just shot up!

There’s a free version that does all I need it to do, but for more functionality, like adding more buttons to the task bar, there’s also a pro version (currently CAD$ 25), which you can try for free for a month.

DisplayFusion

Take a screenshot with a keyboard shortcut on a Mac October 22, 2009

Easy tip:

To take a screenshot of a specific area of your screen hit Command-Shift-4 then select your desired area. This automatically saves it as a file on your Mac’s desktop.

If you prefer to save to the clipboard hit Command-Control-Shift-4.

Get Excel to read your data back to you July 16, 2008

It’s always such a nightmare entering loads of figures into an excel spreadsheet and then having to try and check the figures are right, isn’t it?

Did you know Excel can READ the data (numbers and words) back to you so you can manually check the original data? Nor did I until I read the latest tip from tech-recipes.

Here’s what they say to do:

1. Open Excel 2007 and go to the Quick Access Toolbar at the top of the window.
2. Click the downward point arrow to the right of the toolbar and select More Commands.
3. From the dropdown menu, select Commands Not in the Ribbon.
4. Scroll down the list and find Speak Cells, Speak Cells — Stop Speaking Cells, Speak Cells by Columns, Speak Cells by Rows, and Speak Cells on Enter. Add each of these by selecting them one-by-one and clicking the Add button. Click OK after all 5 commands have been added.
5. Now go to your spreadsheet and select the cells you want Excel to read by performing a simple click and drag. Once the data is selected, go to the Quick Access toolbar and select either Speak Cells by Columns or Speak Cells by Rows. When you are ready for Excel to begin reading off the data contained in the selected cells, select Speak Cells and Excel will begin reading out the data to you.
6. If you need Excel to stop reading, simply select Speak Cells – Stop Speaking Cells.

Admittedly having all those items on your quick access toolbar is a bit clunky, but you can always remove them, I suppose?

Remove the URL from printed web pages July 11, 2008

I’ve been wanting to know how to do this for ages. And now the How-to Geek has told me how. Who knew it could be so simple?

I use Firefox, but he also deals with IE7. What a guy!

Check out his post here.

Now if he could only tell me how to open a bookmark in a new tab in Firefox 3 without having to right click, open in new tab…. or get that new tab to open on the page of my choice rather than a blank one…. Boy, do I miss TabMix Plus

'Search commands' for Office 2007 July 10, 2008

I have been using the Microsoft Office Labs ‘search commands’ for a while now and it’s a pretty useful tool when you just don’t know how the heck to do something in Word, Excel or PowerPoint 2007.

You can download an additional tab for your ‘ribbon’ that gives you a search box to type in your query and it magically tells you how to do what you need to do. Just click on the result you want and it does what you need it to do.

Problem is, it doesn’t tell you HOW it did it, so you don’t get to learn anything. Can’t have everything, I suppose.

Simply go to the Office Labs search command page and download the .msi file, run it and next time you open Word, Excel or PowerPoint the last tab on your ribbon will be the ‘Search commands’ tab.

Search command from Microsoft Office Labs

How to… change a 'tag' name in Google Reader July 8, 2008

I thought I was going crazy. There seemed to be no obvious way to change a tag’s name in Google Reader.

And I was not wrong. You need to follow 6 steps, according to Googlified‘s post on how exactly to do just this.

To reiterate the 6 steps:

1. Go to your Google Reader Settings page and click the ‘Subscriptions’ tab at the top
2. Find the input box called: “Filter by name, tag, or URL”, top right, and enter the tag name you want to change
3. Click “Select: All {number} subscriptions” (left side of the page)
4. Under any one of the feeds in the “Change folders” drop down box, find “New folder…”, and enter the new name for your tag
5. Go to the “More actions…” drop down box and choose the tag you just created under “Add tag…”
6. Go to “More actions…” again and click the old tag that you don’t want, under “Remove tag…” to remove the tag

Settings page

There’s even a handy video in Googlified’s post showing you how to do it.

Matters are not helped by the fact that Google calls the same thing a tag and a folder. A rose by any other name….

If anyone has a quicker method, just let me know.

Change your keyboard language July 1, 2008

Now, I found this out quite by accident.

I was changing my batteries on my cordless keyboard and I must have pressed some random keys because when it started working again my ‘@’ button was giving me speech marks and Shift+3 produced a ‘£’ instead of the ‘#’ symbol. I was most confused.

I guessed it was the keyboard language that had somehow switched to UK, rather than US English, as I had both set up. So how did I change it back?

Press the left Alt key and Shift.