Categories
PowerPoint 2007

Customize More than Fonts in PowerPoint 2007

Fonts are not the only customized or customizable items in MS PowerPoint 2007.

You can give shadows to pictures, new shapes, styles and effects as well! You can also crop your pictures as needed.

Follow the steps below to learn how:

  1. On the Insert tab, click Picture to add an image.
  2. Select the image and the Format tab will become available to you.

You can now experiment with Picture Styles or make up your own custom styles!

Categories
Excel 2007

Create Drop-Down Lists in Excel 2007

Sometimes you want someone to select only from a list that you offer in your worksheet. This is very easy to do in MS Excel 2007.

Follow the steps below to learn how:

  1. Select row or column cells you will not be using.
  2. Place one list item in each cell.
  3. Where you would like the drop-down list to appear, highlight the cells – they need not be contiguous.
  4. Click on Data | Validation.
  5. Under Allow, select List.
  6. Check In-cell dropdown.
  7. Left-Click the Source box and highlight the cells containing your list.
  8. Click OK.

Not difficult at all!

Categories
Word 2007

Hide and Restore the Ribbon in Office 2007

Sometimes you feel like a Ribbon and sometimes you don’t! Well guess what? You can have it your way someplace other than Burger King!

Follow the steps below to learn how to hide and restore the Ribbon in MS Office:

  1. Double-click the Tab, or
  2. Click CTRL + F, or
  3. Right-click and select Minimize the Ribbon.

The Ribbon will now be treated like a menu – it will remain hidden until you click the tab or use the ALT key to bring up keystrokes.

Categories
Word 2007

Translate in Word 2007

In MS Word 2007 you can translate words and even sentences into French, Arabic or Spanish, quickly and easily!

Follow the steps below to learn how:

  • Click on the Review tab.
  • Click on Translation Screen Tip to set up a language.
  • Hover your cursor over a word to translate it or select a full block of text and click on Translate.

Pretty nifty eh?

Categories
Word 2007

Disable Word 2007’s Mini Toolbar

When you select text in MS Word 2007 the Mini-toolbar appears. At first it is faint but when you hover your mouse over it, it becomes much clearer and prominent.

The Mini toolbar is designed to put common formatting commands close at hand for you. It is very convenient if you want to highlight a selection or change font characteristics, but the Mini toolbar can be cumbersome if you want to rearrange text by clicking and dragging. It can also be very distracting when you want to right-click to access the contextual menu.

If, for whatever reason, you find you do not like the Mini toolbar, follow the steps below to disable it:

  1. Click the Office button.
  2. Select Word Options.
  3. Click Popular in the left column.
  4. Deselect Show Mini Toolbar on selection.

Poof! It’s gone!

Categories
Word 2007

Disable Editing Languages in Word 2007

Quite a few people have written to me complaining about Word 2007’s spelling and grammar feature. Many times people complained about previous versions when they displayed the red and green squiggly lines under words but in this latest version, they are complaining about words that are correct being marked as misspelled.

This is not a problem within Word’s Spelling and Grammar utilities. The editing language has somehow been changed in the latest version.

If this happens to you, you can change your option so that it will not recur. Follow the steps below to find out how:

  1. Click the Office button.
  2. Select Word Options.
  3. Click Language Settings on the Popular tab.
  4. Make sure your preferred language is selected under Primary editing language.
  5. Select any unwanted languages under Enabled editing languages.
  6. Click Remove.
  7. Click OK twice.

MS Word will only check spelling and grammar for the language you have enabled. If you need to check spelling and grammar for a different language in the future, you will need to enable editing for that language.

Categories
Word 2007

Applying Styles in Word 2007

Styles will greatly improve the appearance and readability of your documents in MS Word. Employing the use of Styles will also make sure that your formatting is applied uniformly throughout your document.

This latest version of MS Word makes it easier than ever to apply styles to select parts of your documents. Follow the steps below to learn how:

  1. On the Home tab of the Ribbon, you will see a group called Styles.
  2. To preview a style, select a portion of your document and hover your mouse over one of the style buttons in the Style Group and you will be afforded a quick preview of that style in your document.
  3. If you like the style, simply click the Style button to apply it to your document.

Once you have decided on the styles for your document, you no longer need to use the buttons on the Ribbon. You can now simply press CTRL + Shift + S to open the Apply Styles menu.

The Apply Styles menu can be moved to any area of your Word screen. You can apply styles directly from the menu by selecting the text and then using the drop-down list in the Apply Styles menu to apply a style.

Categories
Word 2007

Compare Documents the Better Way in Word 2007

In past versions of MS Word there was no way to compare documents except to have two windows open and switch back and forth which can be very tedious and lead to many errors.

Thankfully, in MS Word’s latest version it is very easy to compare two different documents.

Follow the steps below to learn how:

  1. Click on Review | Compare.
  2. Click Compare again.
  3. Enter two document names.
  4. Click OK.

Now you will see just how easily you can compare your documents!

Categories
PowerPoint 2007

Save Time with Universal Fonts in PowerPoint 2007

Not all older versions of MS Office will always have the PowerPoint 2007 default fonts such as Calibri, Corbel and others, so why not save yourself some hassle by not using them for presentations that will be widely distributed?

  • When you have a PowerPoint presentation that will be making the rounds to many different people and computers, you may want to use fonts like Verdana, Times New Roman or Arial so that those fonts will be available to all viewers of your presentation.

Lots of folks will be thankful of your courtesy!

Categories
Outlook 2007

Create a Personal Folder in Outlook 2007

This is a really simple task and it will help to keep you organized in MS Outlook. A personal folder resides on your local drive and not the server, meaning in your office where you have a server, the personal folder will reside on your computer that sits in front of you on its hard drive.

Follow the steps below to create a personal folder:

  1. Click on File | New | Outlook Data File.
  2. Select Personal Folders File.
  3. Click OK.

Your personal folder will now appear in your Outlook Folder list.