To help readers follow the instructions in this article, we use two different typefaces.

Boldface type is used to identify the names of icons, agendas and URLs.

Sans serif type indicates commands and instructions that users should type into the computer and the names of files.

In the meantime, there is a way to see if an e-mail sender is requesting a receipt. To set that up, open your Outlook Inbox and the View menu. Point to Toolbars, click on Advanced and then on the Advanced toolbar, click on Field Chooser.

When a drop-down menu appears, select All Mail fields.

Then scroll down until you see Receipt Requested, click on it and drag it onto the column heading in your Inbox.

When finished, close the Field Chooser box.

Now, whenever you receive a message that contains a receipt requested, you’ll be alerted by the note under the Receipt Requested column, as shown in the screen shot below.

That was easier said than done. When my efforts to remove all traces of it failed, I went to Norton’s Web site and after a long, frustrating search discovered that I needed a special tool for the job. Why Norton didn’t warn me ahead of time is beyond me. In any case, the tool seemed to work—that is, it did apparently remove the old Norton. But that did not solve my problem—it left hidden files that can’t be removed in my operating system and that stops me from installing the new version. Norton tech support couldn’t help except to say I’ll probably have to do a clean install of XP. I’d like to avoid doing that. Any ideas?

Norton’s tech support people told me they are working on a solution. Until that happens, sad to say, if you want Norton on your computer, in all likelihood you probably will have to completely reformat your hard disk and go through the agony of a clean install of XP.

WORD
Q. Every now and then I make a temporary change in Word’s default—adding a new icon to my toolbar, for example. When I close Word and then open it the next time, I discover that my intended temporary change has become permanent and I have to go back and remove it. Is there a way to get Word to stop second-guessing me?

A. There is. But I should add that Word is not second-guessing you. You just failed to give it the right instructions.

Let me explain: Anytime you make a configuration change in Word—adding an icon to your toolbar or changing the default font or tab stops—those changes are stored in a template called Normal.dot. This template governs the format of all new documents.

Word is automatically defaulted to save any changes in Normal.dot—unless you tell it otherwise. And by “otherwise” I mean you can change the automatic Word default so it will ask you when you’re closing Word after making a change whether to save the revised Normal.dot. Obviously, you have not yet set that default to where Word asks you that question.

To do that, take these steps: Open Tools, Options and click on the Save tab. Be sure there is a check in the box next to Prompt to save Normal template and click on OK.

As you can see, I’ve surrounded the target cell with cells that contain crosshatching and I’ve colored the intended cell a bright yellow. That should direct them right to the cell in which data should be added.

A fast way to perform this formatting arrangement is to hold down the Ctrl key and highlight the three cells you want to add the crosshatching to, select Format cells and click on the Patterns tab. Select the pattern you like and click on OK. Then highlight the target cell and follow the same steps, except choose a bright color instead.

A. Yes, you can eliminate the sheet tabs from the screen. If your goal is to provide more vertical space, however, there is something else you can do in addition. But first, here’s how to remove the sheet tabs from view—recognize, however, that the underlying sheet tabs are still there; they’re just hidden. Click on Tools, Options and go to the View tag. Under Window options, uncheck the Sheet tabs box and click on OK and the tabs will be hidden.

To bring them back, go through the same process and check the Sheet tabs box.

The other thing you can do to increase the work space is to convert to a full screen view, a step that will hide the toolbars. To do that click on View and then Full Screen, and the top of the screen will look like this:

To reverse the process click on Full Screen again and the toolbars will return to this:

Just follow the screen instructions. When finished, label the disk Startup Disk, add the date and put it in a safe place—but not so safe that you’ll forget where you put it.

Now if ever your computer fails to fire up, just slip in the disk and hit the power button. The disk contains all the essential files for getting the computer under way.

EXCEL
Q. I have a spreadsheet file that contains a bunch of worksheets. The problem is they are out of order. Is there some easy way to change the lineup of the tabs without going through the hassle of creating new tabs and then copying the contents?

A. There’s no need to create new tabs or copy anything. Here’s how to customize their order: Say you want to move the February tab to come after January, which, of course, is where it belongs. Just grab the February tab with the mouse and drag it to between January and March.

A. You can. In fact, it works the same way and you’ll find it in the same place in Excel—under Tools.

When you edit a cell in the Track Changes mode, Excel outlines the cell in blue and puts a blue triangle in the upper-left corner. And when you position the mouse pointer over the edited cell, Excel displays a comment indicating what change was made.

To launch Track Changes, click on Tools and then Track Changes. That brings up this menu:

When you’re ready to determine which changes to finally accept, click on Track Changes and on Accept or Reject Changes and you will be offered this menu:

After you’re done Excel still shows edited cells with the blue border and tracking changes indicator. The only way to get rid of them is to turn off Track Changes by going back into it through the Tools menu and unchecking the box.

Be aware that Excel is keeping track of only the last edit made. If you want a complete history of changes, you must instruct Excel to keep a complete tracking history on a separate revisions worksheet. To do that place a check in the box List changes on a new sheet.

AN EVEN BETTER WAY
In the September 2001 Tech Q&A column, we suggested a way in Excel to get rid of the dreaded #DIV/0 when you try to divide a number by 0. We suggested using the IF(). So, if you divide B2 by C2, the formula would look like this:

=IF(C2=0,“Please enter a divisor other than 0”,B2/C2)

This is what it would look like in Excel—with and without the IF formula:

Another way to solve the problem is to use the ISERROR function in an IF statement:

=IF(ISERROR(B2/C2),"",B2/C2)

The two quote marks with nothing between them will return a blank cell, which could be replaced with a 0 if you wish.

This solution has another advantage: It’s not likely to cause an error if that cell is summed in a formula.

(Submitted by Ryan R. Blazei, CPA, of Virchow, Krause & Co., LLP, Appleton, Wisconsin.)

I try to test shortcuts in two Windows editions: Windows 2000 and XP. As you can imagine, it would be very difficult to test them in every edition, and it would be equally difficult to find out which editions are incompatible with a tip. I apologize for the inconvenience.

—The editors