Welcome Members News Search Committees
  You are not logged in Log in
You are here: Home » Members » dkalbus91's Home » Tips & Trick V

Tips & Trick V

Enabling drag and drop text editing in PowerPoint 97/2000/2002

You can easily highlight text within a text box and drag it to a new location on your slide to create a new text box containing the text you selected. However, in order for this to work, you need to enable the Drag And Drop Text Editing option. To do so, choose Tools | Options (Edit | Preferences in PowerPoint 2001) and then click the Edit tab. Now select Drag And Drop Text Editing (so that a check mark appears in the associated check box) and click OK.

Print an attachment with the Outlook message

In these days of email viruses, you can't be too careful about attachments. However, if you do have an Outlook message with a safe attachment enclosed, you can easily print both the message and the attachment all at the same time. To do this, either select the message in your Inbox or open the message. Then, choose File | Print from the menu bar. In the Print Style list box, select Memo Style (if it's not already selected). Then in the Print Options panel, select the Print Attached Files With Item(s) check box. Now click OK. The message will print with the attachment icon followed by the attached document.

Select a cell without triggering its hyperlink (Excel 2002)

Beginning with Excel 2000, entering a Web or email address into a cell automatically creates a hyperlink, which can be used just like any hyperlink on a Web page. Unfortunately, this can make selecting a cell that contains a hyperlink a chore--as soon as you click on the cell to select it, the hyperlink is activated and your Web browser or default email program is launched. To avoid triggering the hyperlink in Excel 2000, you had to select an adjacent cell and then navigate to the desired cell using your arrow keys. Fortunately, Microsoft realizes what a pain this is and provides a way to select a cell without activating its hyperlink. To do so, simply hold the mouse button down a little longer than usual when selecting the cell. When the mouse pointer changes from the hand graphic to the traditional Excel pointer, release the button. When you really do want to activate a hyperlink, simply click and release the mouse button as you usually would.

Five techniques for selecting a table (97/2000/2002)

Method 1: Place the insertion point in any table cell, and then choose Table | Select | Table from the menu bar (Table | Select Table in Word 97).

Method 2: Place the insertion point in any table cell, and then press [Alt]A, followed by C, followed by T.

Method 3: In Word 2000 and later, switch to Print Layout view or Web Layout view, and then hover the pointer over the table. Click on the table's selection icon when it appears near the table's upper-left corner.

Method 3: Hold down the [Alt] key, and then double-click on the table.

Method 4: Make sure your keyboard's NumLock key is turned off. Place the insertion point in any table cell, and then press [Alt]5 using the numeric keypad. You can also delete a selected table by pressing [Shift][Delete].

Method 5: Use Word's built-in TableSelectTable command to create a custom toolbar button or shortcut menu item that selects the current table. To do so, choose Tools | Customize from the menu bar to open the Customize dialog box, and then choose Normal.dot from the Save In dropdown list. (If you want to add the command to a shortcut menu, click on the Toolbars tab and select the Shortcut Menus check box.) Next, click on the Commands tab and select All Commands from the Categories list box. Now drag the TableSelectTable item from the Commands list box to any toolbar. (Or, if you're adding the command to a shortcut menu, drag the TableSelectTable command to the Shortcut Menus toolbar and drop it in the Table | Table Text shortcut menu.) Customize the button as desired, and then close the Customize dialog box. To use the command, place the insertion point in any table cell and then click the button you created. (Or, if you added the command to a shortcut menu, right-click on the table and choose Select Table from the resulting shortcut menu.)

Quickly move to a particular Access column in Datasheet view

When you're working with a table or a query that has many fields in Datasheet view, navigating between columns can be awkward. Fortunately, there's an easy way to move to a particular column. Simply choose the name of the field you want to move to from the Go To Field dropdown list on the Formatting (Datasheet) toolbar. First display the toolbar by choosing View | Toolbars | Formatting (Datasheet). Then click on the arrow to the right of the Go To Field dropdown list box and select a field name. The focus moves to the appropriate field within the current record.

Customize your arrows in PowerPoint

A commonly used tool in presentation development is PowerPoint's arrow tool, which is located on the Draw toolbar. To add an arrow to your slide, you simply click on the tool and use your mouse to draw an arrow on your slide. This may suffice in some situations, but you can also customize the look of the arrow. Just right-click on the arrow and select Format AutoShape from the shortcut menu. In the Format AutoShape dialog box, click on the Colors And Lines tab. In the Line panel, you can select a new color for your arrow, several types of solid or dashed lines, a style and a weight (which increases the thickness of the arrow). In the Arrows panel, you can choose a new starting point design, a new endpoint design or arrowhead, and alter the size for both ends of the arrow.

Customizing footnote separators

(97/2000/2001/2002) When you add footnotes to your documents, Word includes a default two-inch separator line between the document text and the footnotes for each page. You can easily remove or change Word's default separator. To do so, choose View | Normal to switch to Normal view, then choose View | Footnotes to open the Footnotes pane. Next, choose Footnote Separator from the Footnotes dropdown list in the Footnotes pane. Delete the default separator line, or replace it with whatever text or graphic you want to use in its place. When you are finished, click close to dismiss the Footnotes pane. The separator you specified is used on each page that contains a footnote.

Shortcuts for navigating within a selected range (Excel 97/2000/2001/2002)

By default, pressing the [Enter] key moves the cell selector to the cell below the active cell. Pressing [Tab] moves one cell to the right. Likewise, pressing [Shift][Enter] or [Shift][Tab] move the cell selector up and to the left, respectively. Although you're probably already aware of this behavior, you may be surprised to know that these shortcut keys are also applicable to selected ranges and there are several other shortcuts that make it easy to move the cell selector within a particular range. For example, if you have a cell range selected, the [Enter] and [Tab] keys (as well as [Shift][Enter] and [Shift][Tab]) still move the cell selector, but movement is restricted to the confines of the selected range. When the cell selector is at the edge of the range, pressing a shortcut key moves the cell selector back to the beginning of the range. In addition, you can use the [Ctrl][.] shortcut to move among the four corners of the currently selected range. If noncontiguous ranges are selected, the keystroke combinations [Ctrl[Alt][Right Arrow] and [Ctrl][Alt][Left Arrow] let you move the cell selector to the selected range that's to the left or right of the current range.

Add space between the header or footer and the document text (Word 97/2000/2001/2002)

If your document uses a multi-line header, or if the header uses a particularly large font, the space left between the bottom of the header and the beginning of the document text can begin to look pretty cramped. The same thing can happen when you use a multi-line or oversized footer. To add space between the header or footer and the document text, many folks insert blank lines, either in the header/footer or in the document itself, to create the much-needed buffer. However, this hackneyed approach lacks both precision and polish. Instead, add the extra space as it was meant to be added--by increasing the top and bottom page margins. Although you can change your document's page margins by selecting File | Page Setup to access the Page Setup dialog box, you might find it easier to use the vertical ruler in Print Layout view (Page Layout view in Word 97/2001). First, select View | Print Layout (View | Page Layout in Word 97/2001) to switch views. Your document's header should be grayed out, but viewable, at the top of the page. Now, take a look at the vertical ruler that appears along the left edge of the document window. (If the vertical ruler isn't active, select View | Ruler to display it.) The gray portion of the ruler represents the margin (including the header area), and the white portion represents the text area. To adjust the space between the header and the document text, hover the mouse pointer over the ruler where the gray area meets the white area. When the mouse pointer changes to a two-headed arrow, click and drag to increase or decrease the page's top margin as desired. If you'd like to add space between the footer and the document text, scroll down to the bottom of the page, then use the same technique to change the page's bottom margin. (Note: You can also adjust the page's top and bottom margins using the vertical ruler in Header And Footer view. In addition, you can view precise measurements by holding down the [Alt] key as you drag a margin setting on the vertical ruler.)