Customize the Word 2007 Ribbon with these quick tips
Thursday, August 30, 2007 01:25 PM
If the Word 2007 Ribbon is taking up too much space on your desktop and youÂ’d rather have one toolbar displaying only the most frequently used commands, you can set up Word 2007 to do just that.
Microsoft Word
Customize the Word 2007 Ribbon with these quick tips
If the Word 2007 Ribbon is taking up too much space on your desktop and you’d rather have one toolbar displaying only the most frequently used commands, you can set up Word 2007 to do just that.
First, to hide the Ribbon, when you open Word, press [Ctrl][F1] or double-click the Home tab. The Ribbon will disappear from view, leaving only the Ribbon tabs and the Quick Access toolbar visible on the screen. When you need to use a command on the Ribbon, click the appropriate tab to display the Ribbon group where the command is located. When you finish with the command, click the tab to hide the Ribbon again.
If there are certain commands on the Ribbon that you frequently use, you can add the commands to the Quick Access toolbar. For example, follow these steps to see how simple it is to add Date & Time to the Quick Access toolbar:
1. Click the Customize Quick Access Toolbar button found to the right of the Office button.
2. Click More Commands.
3. In the Choose Commands From box, click the drop-down arrow and then click All Commands.
4. Click Date & Time.
5. Click the Add button and click OK.
If you repeatedly display the Ribbon to format selected text, use the Mini toolbar rather than the Ribbon. The Mini toolbar displays automatically when you point to the selected text. You can also format without the Ribbon by right-clicking any part of your document. This will display a shortcut menu of formatting commands that relate to the part of the document you clicked. For example, right-clicking the footer will display the Edit Footers shortcut menu.
Microsoft Excel
Monitor performance with Excel 2007’s conditional formatting
Excel 2007's conditional formatting can help you track performance against your organizational goals. For example, let's say your goal is to maintain a 10% or less product defect rate. You want to alert management when the defect rate is greater than 10% or trending up toward 10%. So you create a worksheet that tracks the defect rate on a daily basis, with the date of manufacture in Column A and the defect rate (e.g., 10) in Column B. Follow these steps to set up conditional formatting:
1. Select Column B.
2. Click the Home tab.
3. In the Styles group, click the Conditional Formatting drop-down arrow.
4. Point to Icon Sets.
5. Click More Rules.
6. Select Format All Cells Based On Their Values.
7. Click the drop-down arrow of the Icon Style box and select 3 Traffic Lights (Rimmed).
8. Click the Reverse Icon Order check box.
9. Select Number from the Type value box.
10. Enter 10 in the Red value box.
11. Select Number from the Type value box.
12. Enter 5 in the Yellow value box.
13. Click OK.
All cells containing 10 or above will be marked with a red traffic light, those containing 9 through 5 will be marked with a yellow traffic light, while those under 5 will be green. Now managers can scan the data for yellow or red traffic lights and take corrective action in a timely manner.
Microsoft Access
Linking multiple list boxes in Access
List boxes make it easier to find specific records in Access. For example, you can add a Client Name list box to your Client Records form that lets your salespersons search for their Clients Records by name. If you have hundreds of clients, however, this list can get unwieldy. To limit the search list, you can link the Client Name list box to a Salesperson list box, so the salespersons only need to search through a listing of his or her clients. Follow these steps to link the list boxes:
- Open the Client Records form.
- Click the List Box tool in the Toolbox and click and drag to create the Salespersons list box in the Forms Header. Click Next.
- Click Table:Salespersons and then click Next.
- Click Salesperson ID and then click the > button.
- Click FirstName and then click the > button.
- Click LastName and then click the > button. Click Next.
- Click Next twice again.
- Enter Assigned Salesperson: in the Label text box and click Finish.
- Click the List Box tool in the Toolbox and click and drag to create the Client list box in the Forms Header.
- Click Next.
- Select Table:Client Records and then click Next.
- Select Client Number from the Field list and click the > button.
- Select Name from the Field list and click the > button.
- Select Salesperson ID from the field list and click the > button.
- Click Next twice.
- Enter Client: in the Label text box and click Finish.
- Right-click the Assigned Salesperson: list box and select Properties.
- Click the All tab.
- Click the Name box and enter cboSalesperson.
- Right-click the Client list box and select Properties.
- Click the All tab.
- Click the Name box and enter cboClient.
- Click the Build button in the Row source property and enter the following in the Criterion cell of the Salesperson ID field:
Forms!ClientRecords![cboSalesperson] - Click the Build button in the AfterUpdate event property and then select Code Builder.
- Enter the following code at the prompt:
DIM strSearch As String
strSearch="[ClientID]=" & Chr$(39) &Me![cboclient] &Chr$(39)
'Find the record that matches the control
Me.Requery
Me.RecordsetClone.FindFirst strSearch
Me.Bookmark = Me.RecordsetClone.Bookmark - Press [Alt]Q.
- Right-click the Salesperson list box and select Properties.
- Click the Event tab.
- Click the Build button in the AfterUpdate event property and then select Code Builder.
- Enter the following code at the prompt:
Me![cboClient] = Null
Me![cboClient].Requery - Press [Alt]Q.
- Close and save the form.
There are currently no comments for this post.