Posts Tagged ‘2007’

« Older Entries

Change Cell Patterns in MS Excel

Thursday, February 2nd, 2012

MS Excel will allow you to change the background patterns used in your cells.  There could be any number of reasons why you may want to do this, but luckily it is very easy to accomplish.

Follow the steps below to learn how:

version 2003:

  1. Select the cells whose patterns you would like to change.
  2. Select Cells from the Format menu to discplay the dialog box.
  3. Be certain the Patterns tab has been selected.

  1. Use the Pattern drop-down list to select one of the patterns available to you.
  2. Click on OK.

Versions 2007, 2010:

  1. Select the cells whose patterns you would like to change.
  2. Click on the Home tab of your Ribbon.
  3. In the Cells group, click the Format tool and then click Format Cells to display the dialog box.

  1. Be certain the Fill tab has been selected.
  2. Use the Pattern Color drop-down list to select the color of your choice for your background.
  3. Use the Pattern Style drop-down list to select the pattern of your choice.
  4. Click on OK.

Cool stuff:  Because any pattern you select appears in the background of your cell, that means that it appears behind any information in that cell. So, if you combine patterns and pattern colors along with other formatting options, you can be very creative with special effects!

Tags: , , , , , , , , , ,
Posted in Excel 2003, Excel 2007, Excel 2010, Microsoft Office Excel | No Comments »

Select Words Automatically in MS Word

Thursday, July 7th, 2011

I have received many inquiries regarding MS Word’s behavior when trying to select text from the middle of one word to the middle of the next word while editing a document.

When you are trying to select text in the manner above, MS Word tries to figure out what you are trying to accomplish and then complete your task for you.  This can be very frustrating because whenever you click inside a word and start to drag your mouse over it, Word assumes that you want to select the entire word that you clicked.

To disable that assumption on MS Word’s part, follow the steps below:

Versions 2007 – 2010:

  1. In version 2007, click Office Button | Word Options, and in version 2010, display the File tab of your Ribbon and click Options to display the Word Options dialog box.
  2. Click Advanced at the left-hand side of your screen.
  3. In the Editing Options area, be certain the When Selecting, Automatically Select Entire Word check box is cleared.
  4. Click on OK.

Versions 97, 2000, 2002, 2003:

  1. Click on Tools | Options to display the Options dialog box.
  2. Be certain the Edit tab is displayed.
  3. Make certain the When Selecting, Automatically Select Entire Word check box is cleared.
  4. Click on OK.

Tags: , , , , , ,
Posted in Microsoft Office, Microsoft Office Word, MS Word 2000, MS Word 2002, MS Word 97, Word 2003, Word 2007, Word 2010 | No Comments »

Print Hidden Text in MS Word

Wednesday, July 6th, 2011

Regardless of whether you can view hidden text in your MS Word documents, Word allows you to control the printing or hidden text.

Follow the steps below to learn how:

Versions 2007 – 2010:

  1. In version 2007, click the Office Button | Word Options, and in version 2010, display the File tab of your Ribbon, to display the Word Options dialog box.
  2. Be certain the Display option is selected at the left-hand side.
  3. Click the Print Hidden Text box in the Printing Options area.
  4. Click OK.

In versions 97, 2000, 2002,  and 2003:

  1. Click on Tools | Options to display the Options dialog box.
  2. Be certain the Print tab is displayed.
  3. Click on the Hidden Text check box.
  4. Click on OK.

Hidden text will now be printed when you print your document.

Tags: , , , , , ,
Posted in Microsoft Office, MS Word 2000, MS Word 2002, Word 2003, Word 2007, Word 2010 | No Comments »

« Older Entries