Create a form in Word and you will invariably be faced with the need to places fill-in-the-blank lines in the document. If you want those lines to remain as people fill in the form, there are a couple of ways you can format the document.
Want to maintain the formatting used in one cell when you use formulas to reference that text in another cell? The answer is not as straightforward as you might think. This tip explores how Excel handles lookup formulas.
Searching for text having (or not having) specific formatting is generally pretty easy. It is more difficult to search for text that is not a particular color. This tip explains how you can find just want you want by using a macro.
Some worksheets are better understood through the spoken word or with musical accompaniment. Sound files can be easily inserted into a worksheet, providing a multimedia experience for all who use it.
Remember your number line from your early years in school? Some numbers can be below zero (negative numbers) and others above (positive numbers). If you want to separate numbers based on there sign, there are few ways you can approach the task.
If you have a lot of records in a data table, you may want to create individual charts based on the information in those records. This can be done by applying the techniques described in this tip.
When entering data in a worksheet, Excel tries to figure out how your entry can best be shown on the screen. When it comes to interpreting percentages, however, you can configure the program to match your intent for the numbers you type. Here's how.
You can easily set up a formula to perform some calculation on a range of cells. When you copy that formula, the copied version may not reflect the update to the cell range in the way you need. Here's how to put together a formula that will increment properly when copied.
Displaying information using charts in Excel is easy and there are a variety of chart styles to choose from. Integrated into each chart is a legend that defines what the chart contains. What if you want to view the legend without the chart? This can be done, but requires manipulating Excel to some degree.