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.
Read this WordTip: Colors for Tracking Changes not Acting Properly
Microsoft Word Tips -
Learn Word Faster!
Is your worksheet information destined for a Web page? Here's how you can specify the fonts that should be used when Excel generates the HTML code for those Web pages.
Read this ExcelTip: Setting Web Fonts
Microsoft Excel Tips -
Learn Excel Faster!
What do you do when Word's spelling check marks some common, everyday words as wrong? Here are some ideas of places you can check.
Read this WordTip: Normal Words Flagged by Spell Check
Microsoft Word Tips -
Learn Word Faster!
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.
Read this ExcelTip: Find and Replace in Headers
Microsoft Excel Tips -
Learn Excel Faster!
Need to combine several files into a single document? You can do it by inserting one file into another, as outlined in this tip.
Read this WordTip: Inserting a File
Microsoft Word Tips -
Learn Word Faster!
If you don't like the font that Excel uses, by default, in a workbook, you can change it. Here's how.
Read this ExcelTip: Changing the Default Font
Microsoft Excel Tips -
Learn Excel Faster!
When you need to make changes to the header or footer of a document, the Header and Footer toolbar is invaluable. What if you can't get it to display, however?
Read this WordTip: Missing Header and Footer Toolbar
Microsoft Word Tips -
Learn Word Faster!
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.
Read this ExcelTip: Changing the Color Used to Denote Selected Cells
Microsoft Excel Tips -
Learn Excel Faster!
What is the difference between frames and text boxes? Why use one over the other? Find out here.
Read this WordTip: Understanding Frames and Text Boxes
Microsoft Word Tips -
Learn Word Faster!
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.
Read this ExcelTip: Using Data Forms
Microsoft Excel Tips -
Learn Excel Faster!
One of the common things done in macros is to somehow "process" documents, which often means moving the insertion point in some manner. This tip explains how this is most easily done.
Read this WordTip: Moving the Insertion Point in a Macro
Microsoft Word Tips -
Learn Word Faster!
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.
Read this ExcelTip: Disabling Shift Key Use when Opening a Workbook
Microsoft Excel Tips -
Learn Excel Faster!
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.
Read this WordTip: Word Link to Create a New Excel Workbook
Microsoft Word Tips -
Learn Word Faster!
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.
Read this ExcelTip: Checking Lock Status of Cells
Microsoft Excel Tips -
Learn Excel Faster!
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.
Read this WordTip: Changing the Default Chart Type
Microsoft Word Tips -
Learn Word Faster!
If you open workbooks in two instances of Excel, you can use drag-and-drop techniques to create hyperlinks from one workbook to another. This is a quick and easy way to link your data together.
Read this ExcelTip: Using Drag-and-Drop to Create a Hyperlink
Microsoft Excel Tips -
Learn Excel Faster!
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.
Read this WordTip: Changing Measurement Units
Microsoft Word Tips -
Learn Word Faster!
Freezing the top rows in a worksheet so that they are always visible is easy to do. Freezing the bottom rows is not so easy. Here's a workaround you can use.
Read this ExcelTip: Freezing Top Rows and Bottom Rows
Microsoft Excel Tips -
Learn Excel Faster!
Word can do some simple calculations for you, if you add a little-known tool to your toolbar. Here's how to add and use this handy tool.
Read this WordTip: Calculating Expressions
Microsoft Word Tips -
Learn Word Faster!
