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 [...]
Office Tips
Hide Confidential Data in a Word 2007 Document
November 5th, 2010 by Aseem Kishore
Apply a Diagonal Border to a Cell in Excel 2007
November 3rd, 2010 by Aseem Kishore
Sum a Table Column in Word
November 1st, 2010 by Aseem Kishore
Customize the Word 2007 Ribbon
October 30th, 2010 by Aseem Kishore
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
October 29th, 2010 by Aseem Kishore
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
October 27th, 2010 by Aseem Kishore
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
October 20th, 2010 by Aseem Kishore
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
October 14th, 2010 by Aseem Kishore
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
October 13th, 2010 by Aseem Kishore
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 [...]
Always Paste Text into Word 2010 from an Outside Source without Formatting
October 8th, 2010 by Aseem Kishore