Word: Match bullets and numbers to the rest of the text
When working with bulleted or numbered text, you might find that the numeral or bullet font format doesn't match the format of the rest of the text.
For example, in a document that contains numbered text, you might find that when you change the format of a page or section within the document, the numbers retain the old format although the text assumes the new one.
If this happens in your document, follow these steps to make the numbers or bullets match the text format:
Your numbers and bullets should now match the surrounding text.
Excel: Point to value thresholds in a cell
You can use conditional formatting to alert you to significant changes in cell values. For example, in a worksheet that tracks students' grades, conditional formatting can draw attention to quiz averages that have fallen below a passing grade of 60 percent.
To apply conditional formatting so average values below 60 percent are displayed in red, follow these steps:
When you return to the spreadsheet, all averages below 60 percent will be displayed in red. As future grades are entered, the format of the cells with the students' average grade will change accordingly. You can apply other conditional formatting rules by clicking Add in the Conditional Formatting dialog box.
Access: Hide the database window from a form user
While it may be necessary for users to have access to a database form, it may not be necessary—or even desirable—for them to have access to the entire database.
Follow these steps to hide the rest of the database from form users:
The next time the database is opened, only the selected form is displayed. However, users can still access the database Window by either pressing [F11] or selecting the database from the most recently accessed databases listed in the File menu.
To prevent users from accessing the database via [F11], deselect the Use Access Special Keys check box in the Startup dialog box. Create a custom menu to prevent user access to the database from the File menu.