Windows/Mac/Linux: The latest version of OpenOffice.org, the free and open-source office suite, improves startup times by over 40 per cent (by some tests), improves importing and support for password-protected and 2007 office files, and improves many areas of the Calc spreadsheet.
A US Court of Appeals has upheld a patent infringement suit brought by a Canadian software company against Microsoft, and Microsoft now has until January 11 to either issue new versions or stop settling Office 2007, and Word 2007 specifically.
Rather than spend money on a commercial tool for designing floor plans, interior design, or laying out your landscaping, you can tweak Microsoft Excel to make an adequate replacement.
If you spend a large part of your day dealing with boring, TPS-like reports, you've probably noticed that Excel 2007 won't let you put spreadsheets side-by-side on your multi-monitor desktop. Luckily, there's a fix for that.
What's the most commonly encountered issue with PowerPoint? Turns out it's not designing poor presentations or objects not lining up properly.
Microsoft's Ribbon interface represents a radical change from standard menu-based applications, but if you're a regular user of Office 2007, you need to come to grips with it. Here's some handy strategies to make the transition easier.
Need to repeat the same task in Office, like typing a block of text or deleting a lot of rows? You don't have to go burrowing through the menus -- simply use the F4 key to repeat your last action.
Windows: There are a lot of great add-ons for Microsoft's premier productivity product, but there's no central spot to turn them on or off. TopAlt EnableDisable controls Microsoft Office add-ons with simple check-boxes.
Windows only: Microsoft is pushing out Service Pack 2 for Office 2007, promising significant performance improvements and support for the OpenDocument format, among other things.
Windows only: Microsoft has a new add-on for Office 2003 and 2007 that sets Microsoft Translator—used in the Live Search service—as a more robust and multi-language translator than the WorldLingo default.
Confused by Office 2007's Ribbon? Some free spreadsheet guides might help you untangle the mess.
The concept of freezing the header row or leftmost column is pretty familiar to Excel users, but it turns out there's also a parallel feature in Word that lets you work on long documents while drawing on information from two sections.
Windows only: Office 2007's Ribbon interface remains a love-it-or-hate-it affair for money, and for those of you who miss the Microsoft Office 2003 menu that's entrenched in your muscle memory, UBitMenu can help. This plug-in adds a new Menu entry to the Office 2007 ribbon (specifically in Word, Excel, and PowerPoint). When clicked, your ribbon displays the classic Office 2003 menu, complete with the buttons and file menus you're used to from your old Office 2003 install. As Samer from FreewareGenius points out, not every single bit of functionality remains in the UBitMenu toolbar as is available in Office 2003—due mostly to changes in Office—but most of the features you're used to remain in all their glory. Even if you're keen on the Office 2007 ribbon, UBitMenu is a nice tool to ease the transition from 2003 to 2007 while you're polishing your new Office mojo.
Word 2007 includes a built-in comparison feature for working out what has changed between two documents, but the menu option for invoking the comparison includes so many options you can quickly get confused. The Word blog includes a comprehensive rundown on how the options work. While the default is to compare everything, unless you're proofing a document for formatting it makes sense to de-select some options: who cares about white space if what you're worried about is if text is changed or removed? For a cloud-centric way of comparing documents, check out how to compare documents in Google Docs.
Advanced Comparison of Word Documents
The Microsoft Office Word Team blog runs down how you can see inside the contests of a Word 2007 file (essentially, renaming it to a .zip extension and then looking inside at the collection of XML files; the details are in the Appendix). The same technique can be used on any Office 2007 file, and could prove useful if a file gets corrupted and you're trying to extract some key data. It also provides an insight into how Office files are structured, though casually parsing XML is not for the faint of heart.
Microsoft Office Word Team Blog
In Office 2007, Word automatically defaults to full print preview mode, which is fine if you're a design obsessive but a big waste of screen real estate if you just want to get some words written. Fortunately, you can make Word default to draft view, though it's a very obscure option. (Proving the point: while Microsoft notes how to fix this in its online support site, somewhat remarkably this information isn't included in Word 2007's own online help.)To make Draft the default view, select Word Options from the main Office menu (or just type Alt-T then O), and scroll down to the General section. Tick 'Allow opening a document in Draft view' (despite the confusing phrasing, this actually affects new documents as well). In my experience, you need to exit and relaunch Word to make the setting stick. To really maximise your available screen real estate, you can also minimise the Ribbon (an option under the nearly invisible 'Customize Quick Access Toolbar' downward arrow button to the right of the Office button).
Microsoft Australia is currently running one of those "visit our site and we'll give money to charity" promotions, promising to donate $1 to the Smith Family for every viewer (up to a $100,000 ceiling) of a site which promotes Office 2007 (and is also a sneaky way to get people to install Silverlight, Microsoft's Flash wannabe). I can't help thinking Microsoft would convince more people to use 2007 if the cursed Ribbon got dumped, but still, why not direct some more of Bill's money towards a worthy cause? (Handy tip: don't try this on a slow connection, on my Next G link it was beyond painful.)Microsoft Smith Family Office Charity
One year ago, you toured the then-new Microsoft Office 2007 interface. Windows users: have you made the switch yet?
Whether you love or hate Microsoft Office 2007's new ribbon interface, everyone can see that it's pretty dang big. To maximise your workspace, you can minimise the ribbon—and the How-To Geek has the details. Just right-click on the ribbon and choose "Minimize the Ribbon." Then to get to a button you need, hover over one of the ribbon tab names.
Maximize Space by "Auto-Hiding" the Ribbon in Office 2007
