Excel’s method of converting measurements is good but could be so much better. Once you start looking into the CONVERT function in Excel, you realize that it’s really an incomplete function. Excel has been around for a long time and yet this important feature has lapses that would make it
There is a possibility of getting a replacement Product Key from Microsoft. A Knowledge Base article from Microsoft suggests they can help recover a lost Office Product Key. If you’re trying to install Microsoft Office, perhaps on a replacement computer, you need installation disk and also the Product Key. That’s
Why can’t you get the right key from a pre-installed copy of Office? Buying a pre-installed copy of Microsoft Office has some pitfalls and one of them is trouble recovering the Product Key. If you’ve lost your copy of the Office Product Key (essential for installing Office) then usually you
Finding a true Print Preview in Word 2010. Hank S. writes: “Is there any way to remove the approximately left half of the screen (File/Options display) so a print preview may be seen at full size? The new print pane is really handy, but there are times when I want
When you buy Office there are several languages you can use with your documents. Office has two levels of language support. There’s the language used on the menus, ribbon and dialog (called ‘Language Interface’) and then there are the languages supported in documents by the spell checker, grammar analysis and
A tool for syncing your Outlook data with online services. gSyncit is an option for pushing your Outlook data, calendar, contacts, tasks and notes to online services. This is important because it lets you access that Outlook info on other devices like the iPhone or Android smartphones with updates copied
How to get table or other information from the net into Excel (or Word). Ever seen some data on the Internet and want to copy it for yourself? From small tables to large data chunks, there’s several ways to do it. Simple copying Almost any table or grid on a
An iCloud link with Outlook sounds great, a pity it doesn’t work in the real world. Lots of iPhone and iPad users got excited when they learned about iCloud and its ability to sync mail, calendar, contacts and tasks with Outlook via the Internet. Hold the applause, if you actually
How to sync Outlook to your Apple devices with iCloud and why it sucks. Apple’s iCloud service provides a way to synchronize some parts of Outlook with your Apple iPhone, iTouch or iPad but it doesn’t work as most people would like. Before iCloud, you could synchronize your Outlook Contacts,
How to use Apple’s iCloud with your Office documents. iCloud is the new Apple service which lets you easily synchronize files between IPad / iPhone and desktop computers, here’s how it works. Did we say ‘easily’? More correct to say ‘a bit easier’. iCloud is a slightly better way to
Word’s spell check has a serious bug when it comes to symbols. Some time back we looked at the ‘Word ampersand mystery’, that’s where the spell-checker behaves strangely when there’s an ampersand in the text. It turns out to be a bigger problem involving many symbol characters. An ampersand at
What is there for Office users in the new Kindle Touch and Kindle Fire? Because there has been no mention of Office document compatibility on the new Kindles, we decided to take a look. There’s a little good news but things mostly stay the same. Document compatibility is important. Devices
Can you have a vertical ribbon in Microsoft Office? Is it possible to make the ribbon go vertically down the side of a document instead of horizontally? Back in Office 2003, it was possible to move the toolbar from the top row to any side of the Office window –
How you can protect yourself against mail being intercepted by a fake domain The Godai Group have made a big splash with their report on ‘doppleganger domains’ that can spy on emails to and from an organization, but what can Outlook users do about it? What is a Doppleganger domain?
The Nook Color tablet/ereader supports an impressive list of Microsoft Office documents. Office Watch reader, Dale M writes: ” for the NookColor …. it reads natively, office documents in Office 2003 and in Office 2007 format. Works for Word, Excel and PowerPoint and maybe others. Also, PDFs display quite nicely
Word 2007/2010 Text Box is also in Excel and PowerPoint. We’ve talked a lot about the Text Box feature in Word 2007 and Word 2010. Both Excel 2007 / 2010 and PowerPoint 2007/2010 have Text Box features similar to Word. There’s no gallery to choose from, so you have to click
The full list of Word 2010 Text Box Gallery items Here’s the full list from the Text Box built-in gallery in Word 2010 and Word 2007. Insert Tab | Text | Text Box. Some people find it easier to see the entire list on a single page rather than scrolling up and
More tips and details about putting one Word document inside another. Following our article on Word linking and embedding in Office for Mere Mortals, here’s some additional tips and help to do things not allowing in the Word dialog boxes. Making it permanent For future reference you’ll want the main
Microsoft’s promotional videos for Office 2010 continue with a video showing how Apollo 11 could have been made. Following Microsoft’s remaking of the US Declaration of Independence we now have a marketing video showing how NASA could have made the moon shots with Excel 2010. It shows how weight was
How to make one Word document appear in another document by linking or embedding. A Word document can be placed inside another so it appears in the second document. This can be done as a ‘one-off’ insertion or a linking where changes to the source document automatically appear elsewhere. For
If you get Office 365, should you subscribe or buy. An in-depth look at whether the Office 365 software subscription is worth considering. Office 365 comes with the option to rent Office 2010 software – is that a good choice? For the most part, Office 365 is a collection of
Three options for tracking the life and times of your laptop battery., Over time, your laptop battery gets tired and less able to keep a charge – but how to know when it’s time to replace it? There are some nifty utilities to track your battery status in great detail
Office 2010 Service Pack 1 (SP1) is now available for download, if you want to be a guinea pig for Microsoft. Office 2010 Service Pack 1 (SP1) is now available for download, if you want to be a guinea pig for Microsoft. The major update to Office 2010 can be
Where is the Select All command and why you don’t need to find it. “As software changes so do the tool bars. A simple change for the location of the “select all” button is frustrating’ – Anthony C. We assume Anthony is asking about the ribbon in Office 2007 and