Scale Word documents for different page sizes without reformatting
Thursday, January 03, 2008 03:28 PM
You realize that your Word document detailing new company policies will fit in a smaller-sized sheet and doesn't need to take up a letter-size memo.
Microsoft Word
Scale Word documents for different page sizes without reformatting
You realize that your Word document detailing new company policies will fit in a smaller-sized sheet and doesn't need to take up a letter-size memo. The good news is that you don't have to reformat your Word document--you can simply print to scale. Here's how:
- Open the document containing the announcement.
- Press [Ctrl]P.
- In the Zoom section, click the Scale To Paper Size drop-down arrow.
- Scroll to and select the desired sheet size.
- Enter how many copies you want and then click OK.
Note that changing the size in the Print dialog box will not reformat your original document; the new paper size will apply to this printout only.
You can scale your document to print to any paper size listed; or, if your printer supports it, you can create your own size. Click the Properties button in the Print dialog box to access your printer’s menus and create a custom paper size.
Microsoft Excel
Copy hundreds of rows of Excel formulas in three steps
Excel provides a number of ways to copy formulas. You can use Excel's Autofill feature or, as an alternative, select the cells you wish to copy to, enter the formula in the active cell, and then press [Ctrl][Enter]. These methods are fine for copying formulas down a column of cells--unless the column extends down hundreds of rows.
For example, say Column A in your worksheet lists 100 products and Column B lists the wholesale price of each. You would like to enter a formula that calculates the retail price for each product and displays the results in Column C. Selecting 100 cells is a time-consuming and error-prone process, but you can copy the formula down Column C without having to select the cells. Follow these steps for foolproof cell copying:
- Click in C2 and enter =B2*300%.
- Press [Ctrl][Enter].
- Double-click the fill handle (the small black square in the lower right-hand corner of the cell).
Excel will stop copying the formula when it reaches a row with a blank cell in Column B. To ensure that you copied the formula correctly, click in C1 and then press [Ctrl][Shift][End].
Microsoft Access
Bring Access forms to life with animation
Publishing your Access forms on the Web? Add some fun with animated images! For example, say you want to publish a form that allows your users to enter a keyword that will search your software catalog for winter specials; to illustrate this, you've embedded an image of two boys hitting the a puck with their hockey sticks. To animate the image, follow these steps:
- Open your form in Design view.
- Right-click the embedded image of the hockey players.
- Click Properties.
- Click the All tab.
- Click in the Name Property box and enter ctlImage.
- Double-click the Form Properties button in the top left-hand corner of the form window.
- Click the Timer Interval property box and enter 200.
- Click in the On Timer property box and click the Build button.
- Select Event Procedure and click OK.
- Enter the following code at the prompt:
On Error GoTo HandleError
ctlImage.Left = ctlImage.Left + 200
ctlImage.Top = ctlImage.Top + 100
ExitHere:
Exit Sub
HandleError:
ctlImage.Left = 0
ctlImage.Top = 800
Resume ExitHere
- Click [Alt]Q.
When you subsequently run the form, the boys will appear to skate across the form.
» Powerful server blade for SMBs
Test Drive Now!
There are currently no comments for this post.