Tabs for Microsoft Office

If you use tabbed browsing while working online to shift quickly between webpages, it can be frustrating to work in Microsoft Office products and have to open one document at a time, and use the taskbar or Alt+Tab to move between documents.


ExtendOffice (http://www.extendoffice.com/download/office-tab.html) is a free add-in for Microsoft Office that adds tab functions to Word, PowerPoint and Excel (the paid version also adds them to Publisher, Access and Visio).  This allows you to move quickly between documents, particularly useful if you are comparing documents or copy-and-pasting sections of content from one document to the other.  The screenshot at the upper right shows the tabs of two presentations pulled up in PowerPoint 2010, so the two presentations can be accessed more quickly, simply by clicking the tab.

The tabs are very customizable, and different settings can be used for different Microsoft programs (tab options for Word are shown at left).  It is compatible with Office 2003, 2007, 2010, and 2013.

Converting docx, pptx and xlsx Files

As most of you probably know, when Microsoft released Office 2007, the file formats of the documents it created changed: .doc (Word documents) became .docx, .ppt (PowerPoint documents) became .pptx, and .xls (Excel documents) became .xlsx. What this meant is that people with earlier versions of Microsoft Office were unable to open the new file formats.

There are many file format converters out there, but Microsoft probably created the easiest, most seamless one, with the Microsoft Office Compatibility Pack, available for free download at: http://www.microsoft.com/download/en/details.aspx?id=3.

I like this converter (and use it on my personal laptop) because it converts the document all by itself. All you need to do is open the document in whatever version of MS Office you have, and the converter automatically recognizes the format as incompatible and converts and displays the document in a read-only version. You don't have to do a thing. The converted document can then be saved in an older file format (e.g. - .doc)

Some caveats: the compatability pack only converts Word, PowerPoint and Excel documents. And formatting choices that are not available in the older version of Office will be discarded. Overall, though, it is the easiest and cheapest way to convert Microsoft Office 07 and 2010 documents.

Office 2010 Beta

Late yesterday Windows unveiled the beta version of Office 2010. It's free, and it's available here: http://www.microsoft.com/office/2010/en/default.aspx. The beta version will expire in October 2010.

Overall, it doesn't look too much different than Office 07. The ribbon is still there (though the Office button has been replaced with a File tab). There are some enhanced image editing features, such as color saturation and artistic effects. You can edit videos embedded in PowerPoint directly from the program.

The big difference is that you can save documents to the Web and share them with others on Microsoft's "Skydrive." Clearly, this is an attempt to compete with Google Docs and other Web 2.0 cloud computing options available out there. It allows you to save your documents to the web directly from the File tab, and you can invite others to view or collaborate with you on documents, as well as access them from any computer.

Yes, you can already do all of that on Google Docs. And yes, this free version expires in October, after which you have to buy it. But it's worth a look, if only to see how Microsoft will compete in the Web 2.0 arena in the future.

More information is available at the the Microsoft Office 2010 FAQ page.

Excel 07 Page Layout View

Microsoft Excel 07 - the latest version of Excel - offers a solution to one of the most vexing aspects of Excel: print formatting. In older versions of Excel, to format the printed version of a spreasdsheet, you needed to go to File, then Page Setup, then Print Preview, and then sort of hop back and forth between Page Setup and Print Preview and tweak the layout to get the correct printed page. Getting the rows and columns to break at just the right spot was a cumbersome and time-consuming process.

Excel 07 has a Page Layout view as the center icon at the lower righthand corner of the page (it's circled in the illustration to the right). It changes the view on the document screen (below) to how it will look when printed so that you can tweak it and see your changes enacted immediately. The row and column heading bars are moved to just outside the document, so you can resize rows and columns, hide columns, etc., just by working with the row and column bar options. You can also use the Ribbon commands to change font size and styles, hide or show gridlines, add border styles, all on the document pane, until you get the exact printed document you want. You can even add headers and footer by clicking directly on the page and typing. Page breaks, both horizontal and vertical, automatically readjust as you make changes to the document.