Tech

Guides

Business Applications ▪ Database Management ▪ Disaster Recovery ▪ Enterprise Servers & Storage ▪ IT Security ▪ Java ▪ Microsoft Office Suite ▪ Network Admin ▪ Open Source ▪ SMB ▪ SOA ▪ Tech Management ▪ Software/Web Development ▪ Windows Server ▪ Wireless Tech

Microsoft Office Suite TechGuides

Set a print area to keep Excel from printing what you don't want

By Mary Ann Richardson, Special to ZDNet Asia
Thursday, August 14, 2008 01:57 PM

Follow these steps to define a print area for your worksheet.

Microsoft Excel

Set a print area to keep Excel from printing what you don't want

There are times when you don't want Excel to print everything on your worksheet. For example, your worksheet might include a lookup table or a named range that's used only in your formulas.

Rather than having to select the cells you want to print or to hide cells each time you print the worksheet, you can define a print area that excludes those cells from printing.

Follow these steps:

Select the cells you want Excel to print on the active sheet.
Go to File | Print Area | Set Print Area. (In Word 2007, click the Page Layout tab and then click the Print Area button in the Page Setup group. Select Set Print Area.)

Now when you print the active worksheet, only the area you selected will print. If you wish to print the entire sheet without clearing the Print Area, click the Ignore Print Areas check box in the Print dialog box:

Microsoft Access

Calculating Access fields with Null values

You've created a query that calculates an invoice total by adding the order total and the shipping charges. You used this formula for the calculated field:

Invoice_Total: [Shipping Charge]+[Order Total]

Everything worked fine until about a week ago, when your company began running a special promotion that offered free shipping for orders of US$60 and above.

As a result, many of Shipping Charge fields are blank, and so are their corresponding Invoice Total fields. The Invoice_Total formula, which includes arithmetic operators, just won't include records containing blank (Null) values in their calculations.

Fortunately, the NZ function converts Null values to zeroes so they are included in a calculation. Follow these steps:

Open the query in design view.
Delete the Invoice_Total formula.
Right-click the Invoice_Total field cell and click Zoom.
At the prompt enter the following formula:

Invoice_Total:NZ ([Shipping Charge],0)+NZ([Order Total],0)

Click OK.

Now when you run the query, orders without shipping charges will show an Invoice total:

Microsoft Word

Five Word borders you can apply as you type

When you want to set off a paragraph with a horizontal line, you can switch from the keyboard to the mouse and click the appropriate border tool--or you can simply type it in. For example, suppose you would like to separate the following sentence from the rest of Section One:

After you type the sentence, press Enter, type three hyphens, and then press Enter again, as shown below. (I've turned on the Show/Hide button to reveal the keystrokes.)

Word draws a single line above the second paragraph mark and positions the insertion point marker to begin the next paragraph:

If you prefer a thicker line, substitute the underscore (_) character for the hyphen. Using an equal sign (=) will produce a double line. The tilde character (~) will produce a wavy line, while an asterisk (*) will produce a dotted line. Finally, typing the number sign (#) three times produces this border:

Note that Word's AutoCorrect border option must be set for these keys to work. Go to Tools | AutoCorrect. (In Word 2007, click the Office button, click the Word Options button, point to Proofing in the left column, and then click the AutoCorrect Options button.)