Control where Word hyphenates a word

Follow this tip to determine where Word hyphenates your content.

Microsoft Word

Control where Word hyphenates a word Word doesn't hyphenate content unless you tell it to: From the Tools menu, choose Language, select Hyphenation, check the Automatically Hyphenate Document option, and click OK.
Furthermore, setting the Hyphenation Zone option lets you control, a bit, where Word hyphenates a word. The default setting of 25 percent is adequate for most uses.
But even at its best, Word won't always insert the hyphen where you want--you are somewhat at its mercy. When this happens, insert an optional hyphen by holding down the [Ctrl] key as you press the hyphen character key (-).
If the word falls at the end of the line, Word will use the optional hyphen. If the word doesn't fall at the end of the line, Word won't display the hyphen character at all.
To display optional hyphens on screen, choose Options from the Tools menu and then click the View tab. Select the Optional Hyphens check box in the Formatting Marks section and click OK. In Word 2007, click the Office button and then click the Word Options button. Click Display in the left pane, select the Optional Hyphens check box, and click OK.

Microsoft Access

Add a button to an Access form that tells you which version is running If you support more than one version of Access, you may often need to ask users which version is running before you can help them with a problem. Don't have them guess!
Create a button somewhere on their application form that, when clicked, will tell them exactly what version is running on their PC. Follow these steps:
  1. Open the form in Design view.
  2. Click the command button tool in the Form Controls toolbox. In Access 2007, click the Button form control in the Controls Group on the Forms Design tab.
  3. Click Cancel to close the Forms Control Wizard.
  4. Change the button caption to Which Version? (Figure A).
Figure A

  1. Right-click the button.
  2. Choose Build Event.
  3. Type the following code at the prompt (Figure B):
Private Sub Command6_Click()
Select Case SysCmd(acSysCmdAccessVer)
Case 7
MsgBox "This is Access 95", vbOKOnly
Case 8
MsgBox "This is Access 97", vbOKOnly
Case 9
MsgBox "This is Access 2000", vbOKOnly
Case 10
MsgBox "This is Access 2002", vbOKOnly
Case 11
MsgBox "This is Access 2003", vbOKOnly
Case 12
MsgBox "This is Access 2007", vbOKOnly
End Select
End Sub
Press [Alt] +[ Q].
Figure B

Now, users simply have to click the Which Version? button to let you know what version they are using (Figure C).
Figure C

Microsoft Excel

Move a pivot table to another workbook in Excel 2007 You've just created a pivot table in a workbook and would like to publish it to your Web site. However, you don't want to publish the workbook, just the pivot table.
Excel 2007's Move Pivot Table command lets you move the pivot table to any workbook on your network. To move a pivot table to a new blank workbook, follow these steps:
  1. Open the workbook containing the pivot table.
  2. Open the new workbook.
  3. Click Arrange All on the View tab, choose Vertical, and then click OK (Figure A).
Figure A

  1. Click the PivotTable report.
  2. Click the Option tab on the Ribbon under PivotTable Tools.
  3. In the Actions group, click Move PivotTable (Figure B).
Figure B

  1. In the Move PivotTable dialog box, click Existing Worksheet and then click the window shade button (Figure C).
Figure C

  1. Click A1 in the new workbook.
  2. Click the window shade button in the Move PivotTable Dialog box (Figure D).
Figure D

  1. Click OK (Figure E).
Figure E