Software

Tech Tip: Keep Word from spell checking specific text/Add a picture to a worksheet's header/Use the Top Values combo box

Learn how to prevent Word's spelling checker from checking text altogether, create a header in Excel that features your company name and logo, and create top 10 lists in Access using the Top Values combo box.

Keep Word from spell checking specific text

Just as you can use Word's spelling checker to check only selected text, you can also turn off spell checking for selected text. For example, if you're typing a block of VB code or a price list complete with parts numbers, the spelling checker will probably go ahead and mark the entire text as misspelled.

However, you can prevent the spelling checker from checking this text altogether. Follow these steps:

  1. Select the text you don't want Word to check.
  2. Go to Tools | Language | Set Language.
  3. Select the Do Not Check Spelling Or Grammar check box, and click OK.

Keep in mind that this procedure not only excludes the selected text from spell checking but also from grammar checking and AutoSummarize processes.

Add a picture to a worksheet's header

Excel 2002 lets you add a picture to a worksheet's header or footer. For example, suppose you want to create a header that features your company name and logo.

Follow these steps:

  1. Open the worksheet, and go to File | Page Setup.
  2. On the Header/Footer tab, click the Custom Header button.
  3. Put your cursor in the section you want the company logo to appear, and click the Insert Picture button.
  4. Navigate to the picture you want to insert, select it, and click Insert.
  5. To make any desired changes, click the Format Picture button.
  6. Enter your company's name in the section where you want it to appear.
  7. To make any desired changes, click the Font button.
  8. Click OK twice.

Create top 10 lists with the Top Values combo box

Have you ever wanted to compile a ranked list from data in your Access database? For example, let's say you just created a query that lists each employee's total sales for the quarter. But what you really need to know is the top 10 performers.

Depending on the number of employees, you could more than likely compile this list manually. However, there's an easier way.

Follow these steps:

  1. Open the query in Design View.
  2. In the Sort cell under the Total Sales field, select Descending.
  3. Enter 10 in the Top Values combo box in the Query Design toolbar, and press [Enter].

The query results will include only those employees who have achieved the top 10 values.

To compile a list of employees who had the five lowest sales figures, follow these steps:

  1. In the Sort cell under the Total Sales field, select Ascending.
  2. Enter 5 in the Top Values combo box, and press [Enter].

Selecting All from the Top Values combo box will return all records in the query results, ranked in ascending or descending order.

Editor's Picks

Free Newsletters, In your Inbox