Office Tips

Set OpenOffice.org to Save in Microsoft Office Format by Default

by File in: Office Tips

Whether you like or loathe it, Microsoft Office file formats are dominant, especially among businesses. OpenOffice.org can open and save .doc, .xls, and .ppt files; however it defaults to its own file format when saving new documents. If you want to work in OpenOffice.org rather than Microsoft Office, but need to share documents in Microsoft […]

Hide Confidential Data in a Word 2007 Document

by File in: Office Tips

When sharing a Word 2007 document, you may need to delete or hide confidential information. You can search for the data and remove it manually, but this can be error prone and time consuming. If you often need to hide confidential data in a Word 2007, there is a free add-in for Word 2007, called […]

Apply a Diagonal Border to a Cell in Excel 2007

by File in: Office Tips

You can add all kinds of borders to cells in a worksheet in Excel. You can place borders of different styles on the left, right, top, and bottom of a cell. If you select a range of cells, you can add borders to the left, right, top, bottom of the selected range, and in between […]

Sum a Table Column in Word

by File in: Office Tips

Word allows you to calculate the sum of a column in a table, just like you would in a spreadsheet program like Excel. This post will show you how to do this in Word 2003, 2007, and 2010. As an example, we will total a column of decimal numbers. Word 2003 Below is an example […]

Customize the Word 2007 Ribbon

by File in: Office Tips

Even though you cannot add, delete, or move commands on the Ribbon tabs in Word 2007 directly (see the post, Ribbon Customizer – Add-In for Office 2007 that allows full customization of the ribbon interface, for a third-party tool that allows you to do this), there are some ways you can customize the Ribbon bar. […]

Preserve Cell References when Copying a Formula in Excel 2007

by File in: Office Tips

When you copy a cell containing a formula, you will notice that the cell references in the formula also move a corresponding number of cells across and down. This type of cell reference is called a relative reference. When we copy (Ctrl + C) the formula in the image above, and paste (Ctrl + V) […]

Customize the Ribbon Bar in Word 2010

by File in: Office Tips

Word 2007 added the ribbon bar to the interface, but did not allow you to customize the tabs on the ribbon bar. You could not add, remove, or move buttons on the tabs without using a third-party tool (see our previous post, Ribbon Customizer – Add-In for Office 2007 that allows full customization of the […]

Repair Microsoft Office 2010

by File in: Office Tips

We have previously written about the Microsoft Office Diagnostics tool available in Microsoft Office 2007 (see our post, Use the Microsoft Office Diagnostics Tool to Diagnose Problems in Word 2007). Unfortunately, that tool has been removed in Microsoft Office 2010. However, you can repair Office 2010 using the Programs and Features tool in the Control […]

Convert Older Office Documents to Office 2007 or 2010 Format

by File in: Office Tips

Microsoft Office 2007 and  2010 can both open documents created in older versions of Microsoft Office. However, they are opened in “Compatibility Mode,” and not all the features of the new version of Office are available for the older document. To use the newer features of Office on an older document, you must first convert […]

Restrict Editing on Word 2007 and Word 2010 Documents

by File in: Office Tips

Word 2007 and 2010 both allow you to control the types of changes other people make to documents you distribute electronically. You can easily track the changes any changes made to the document. Any text that has been changed displays in red. The procedure for restricting editing on a Word document is slightly different for […]