Office Tips

Hide Confidential Data in a Word 2007 Document

November 5th, 2010 by Aseem Kishore

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 [...]

1 There are 1 comments, care to add yours?

Apply a Diagonal Border to a Cell in Excel 2007

November 3rd, 2010 by Aseem Kishore

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 [...]

0 There are 0 comments, care to add yours?

Sum a Table Column in Word

November 1st, 2010 by Aseem Kishore

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 [...]

1 There are 1 comments, care to add yours?

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. [...]

0 There are 0 comments, care to add yours?

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) [...]

0 There are 0 comments, care to add yours?

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 [...]

1 There are 1 comments, care to add yours?

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 [...]

9 There are 9 comments, care to add yours?

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 [...]

1 There are 1 comments, care to add yours?

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 [...]

0 There are 0 comments, care to add yours?

By default, Microsoft Word 2010 tries to preserve the styles of text copied from a source outside of Word. If you don’t want to have to manually remove the style information once you have pasted the text into Word, there is a way to make Word 2010 paste text from an outside source with no [...]

1 There are 1 comments, care to add yours?