A. Excel provides a wide assortment of formatting possibilities for numbers. I’ll show you how they work so you can set up any combination you wish.

First, highlight the cells containing the numbers you want to format and then go to Format (right-click and then select Format Cells), and you will get this screen (see right).

The Category box contains a wide assortment of formatting choices. If none of them suits your needs, click on Custom at the bottom of the list. That will give you many possibilities—plus the option of creating your own format.

Here’s how to create custom formats: Under the Type box, scroll down the list of choices. Notice that some lines have several formats, each separated by a semicolon.

If you click on such a line, as shown above, the entire line appears at the top of the Type box—semicolon and all. In the example above, that combination of code tells Excel to put the comma in for thousands (1,234); it also sets negative numbers in both red and with parentheses.

You can change the code in many ways—adding colors and conditionals. Whatever you enter automatically is added to the Custom category and can be used anywhere within the workbook.

For some reason—or maybe for no good reason at all—Excel hides a good tutorial on customizing numbers. To find it, go to Help (F1), click on the Index tab and under Type keywords, enter format. Then scroll down the drop-down list until you come to Create or delete a custom format number.

In the meantime, here are some frequently used codes:

Likewise, you can format fractions, too.

Be aware that no matter which format you use to display numbers, you aren’t affecting the accuracy of the number. Internally, Excel maintains all numbers to 15 places. So if a number is displayed using two decimal places, Excel still maintains it internally to 15 decimal places, and it calculates using the internal representation.

A. There is, and it’s a real time-saver. In fact, I don’t think it’s documented in any of the Microsoft help files—or at least I haven’t found it.

All you have to do is place your cursor in the paragraph you want to move, hold down both the Shift and Alt keys and press the up arrow to move it up or the down arrow to move it down.

A. You may not realize it, but you can generate very customized headers and footers in Excel. Let’s tackle the easy one first. Open a worksheet and, on the toolbar, click on File, Page Setup and then the Header/Footer tab.

Excel provides a bunch of default headers and footers. To see them, click on the down arrow at the right edge of the Header or Footer box.

If none of them meets your needs, click on either Custom Header or Custom Footer, which brings up this screen:

By placing your cursor in any of the boxes (Left section, Center section, Right section) and clicking on any of the icons, you can add the appropriate header or footer to that section of the spreadsheet.

For example, let’s say I want to add the page number on the left, a graphic in the middle and the date on the right. The setup screen then looks like this:

And when I print the page, it looks like this:

If none of the defaults meets your needs, here are some command codes you can manually add—by typing an ampersand (&) followed by the command (see below)—in any of the section boxes.

A. Right on! Those bullets and numbers can be a major pain. Here’s an undocumented (or well-hidden) two-finger solution. Just highlight the paragraph and press Ctrl+Q.

The URL I gave you in

Also in the May issue, I gave you a tip (page 72) for shutting down programs running in the background that may interfere with a defragmentation. Reader Helen Donnell, CPA, CMA, of Orlando, Florida, suggests a much better way to close down interfering programs: Use the infamous “three-finger salute” (Ctrl+Alt+ Delete). In the “old” days, those key strokes shut down Windows, but in Windows editions since 2000, Ctrl+Alt+ Delete evokes a screen that displays all the programs running in the background (see screenshot) and gives you the option of shutting each of them down.

To end a program, click on its name and then on End Task. When finished defragging, you’ll need to reboot the computer to get rid of the task screen.