When the Track Changes feature is turned on, Word, by default, displays the edits made by each document editor in different colors. If you aren't seeing different colors for each editor on your system, it could be related to a configuration setting in the Options dialog box. This tip explains the setting and walks you through changing it.
Using Find and Replace is something quite routine in Excel, as it easily allows you to find and replace information in your worksheets. What if you want to find and replace information in headers or footers, however? That isn't quite as easy.
When entering data into a range of cells, the cell in which you are working appears in a different color than the other cells in the selection. You can change these colors within Windows (not Excel) and this tip explains how.
Lots of people prefer to enter information directly into Excel, but there is another way that may be helpful: Using data forms. This tip introduces data forms, explains how to display them, and shows how easy it is to use them for editing your data.
Open up a workbook, and Excel normally runs the macros associated with that workbook. You can disable the automatic running of macros by holding down the Shift key while the workbook opens. If you want to defeat this ability, you may be out of luck.
It's easy to create and include links in your documents to other sources, in and out of Word. There are some limitations you should keep in mind when using these links. This tips explains what they are (at least when it comes to Word and Excel) and how to avoid potential problems.
When you first create a worksheet, all the cells in that worksheet are formatted as locked. As you unlock various cells on the worksheet, you can easily lose track of which cells are locked and unlocked. Here's some ideas on how you can easily check the lock status of individual cells.
If you don't have Excel installed on your system, Microsoft Graph is a handy way to create simple charts for your documents. If you want to change what Microsoft Graph uses as its default chart type, you'll love the information in this tip.
When working in Word's dialog boxes, most people understand that you should enter measurements using inches. If you don't like inches, you can change the default unit of measurement to something more to your liking.