More Tips for Office 2007 Users

Share Share

There are always those “little things” that become “big things” when you can’t figure them out that drive you crazy. Like: creating a registered trademark symbol; inserting an entire file into the middle of a document; indenting the content in an Excel cell…and so on.

For Word 2007

Creating a Correct Registered Trademark Symbol

  1. Position your cursor where you want the trademark
  2. Type (r) – this will create a trademark symbol but it is not superscripted
  3. Highlight the registered trademark symbol
  4. Press [Ctrl] + [Shift] + [+]. This will superscript the mark

Using a Non-Breaking Hyphen

  1. Press [Ctrl] + [Shift] + [-] instead of just the hyphen
  2. This hyphen will not break over a line

Inserting an Entire File into a Word Document

  1. Position the cursor where you want the other file to be inserted.
  2. Insert > Text > Object
     
    file-1
     
  3. Choose Text from File
  4. Select the file you want to insert
  5. Click OK

For Excel 2007

Indenting the content of a cell or group of cells

  1. Select the cells you want to format
  2. Home > Alignment
     
    alignment-1
     
  3. In the horizontal drop-down list select Left (Indent) or Right (Indent)

Viewing Multiple Worksheets at the Same Time

  1. Open a single workbook
  2. View > Window > New Window
  3. Excel will open the same workbook in another new window
  4. View > Arrange All
     
    excel-4
     
  5. Select a different worksheet in each window to view them together

Changing the “Enter” Behavior

Normally, pressing “Enter” moves the cursor down. You can change it to move horizontally.

  1. Click on the Office button and choose Excel Options
  2. Select Advanced > Editing Options
     
    enter-2
     
  3. Select the appropriate direction in the drop-down menu of  “After Pressing Enter Move”

For PowerPoint 2007

Resizing Multiple Objects Proportionately

If you need to make a group of objects smaller or larger, you can do so to all of them at once, maintaining relative sizes and proportions.

  1. Select multiple objects by [Shift] + Clicking on them
  2. Resize all using your mouse to drag the corners
    Keep [Shift] pressed in order to make sure that individual aspect ratios are maintained
  3. Works with both text and pictures

Fine-Tuning the Zoom Feature

  1. Using [CTRL]+ mouse scroll zooms in and out in increments of 10%
  2.  If you want to be more exact in your zooming, (7% for example) use the Zoom Slider at the bottom right of your screen
     
    zoom
     
  3. This applies to all Office Applications
Share Share