Tutorials     
WebTools        
Troubleshooting
Workshops        
MS Sites
Press Releases
FAQs - "How To's"
Web Resource Sites
Subject Area Resource Sites
Downloads
home page general information e-mail our webmaster copyright information

WebTools - Tips and Tricks - Archive

MS Word - MS Excel - MS PowerPoint - MS Access - MS Win95/98




MS Word 95/97/2000


Volume 1
Toggle upper case and current case in Word

You may already know that you can quickly toggle the case of selected text by pressing
[Shift][F3]. Each time you press
[Shift][F3], the selected text's case cycles from lower case to title case (sentence case in Word 95) to upper case. A lesser known case-toggling keyboard shortcut you'll be sure to get some use from is the
[Ctrl][Shift]A shortcut. When you select text that contains both upper-case and lower-case characters and then press
[Ctrl][Shift]A, Word toggles the case of the lower-case characters to upper case. For example, if you select the text "My Dog has Fleas" and press
[Ctrl][Shift]A, the text becomes "MY DOG HAS FLEAS." If you press
[Ctrl][Shift]A again, the text returns to its initial state. A word of warning: the
[Ctrl][Shift]A shortcut works just like the
Caps Lock key. If you don't select any text before pressing
[Ctrl][Shift]A and then begin typing, your text will all be upper case. To turn the feature off, press
[Ctrl][Shift]A again.


Volume 2
Ungrouping Word pictures with one click (97/2000)

As you probably know, when you insert clip art or other Windows metafile objects in your Word documents, the rotation tools on the Drawing toolbar aren't available. To use these tools, you must convert the metafile to a Word picture object. You can do so by ungrouping and then regrouping the object; however, this process is tedious. To make this process more efficient, add Word's built-in Disassemble Picture button to the Drawing toolbar. This button is also convenient to use when you want to modify the components of a clip art object. To add the button, first display the Drawing toolbar by selecting View/Toolbars/Drawing from the menu bar. Then select Tools/Customize from the menu bar, and click on the Commands tab.  Choose Normal.dot from the Save In dropdown list to save the button for use in the Normal.dot template. Select Drawing from the Categories list box. Finally, locate the Disassemble Picture button in the Commands list box and drag it to the Drawing toolbar. To use the button, select a clip art or other object and click the Disassemble Picture button. Word automatically ungroups the object so you can work with its individual components. To regroup the object, click the Select Objects button on the Drawing toolbar and then select the objects you'd like to group. Then, select
Draw/Group from the Drawing toolbar. 

Volume 3
Search subfolders from Word's Open dialog box (95/97)

When you search for files using Word's Open dialog box, Word limits its search to the current folder. You can configure Word to search the current folder's subfolders by clicking the Advanced button, selecting the Search Subfolders check box, and then clicking the Find Now button. This is quite a few steps for such a simple task. Luckily, there's a much easier way to prompt Word to search in the current folder's subfolders, and you don't have to leave the Open dialog box to do it! After you've specified your search criteria in the Open dialog box, click the Commands And Settings button in the Open dialog box's toolbar. Select Search Subfolders from the resulting submenu, and voila! Word automatically performs your search, looking in the current folder's subfolders, and returns all matches in the results pane.

Volume 4  
Create a presentation from a Word document (97, 98, 2000)

Do you need to create a PowerPoint presentation from text you've stored in a Word document? Why cut and paste text from Word to PowerPoint when you can automate the process? Simply open the Word document you'd like to use as a presentation, then choose File/Send To/Microsoft PowerPoint from the menu bar. PowerPoint opens, imports the information from your Word document, and distributes a collection of slides according to paragraph, style, and outline levels you used in the Word document.

Volume 5
Restoring Word's Normal.dot template (95, 97, 2000)

If you've ever unintentionally saved changes to Word's global template, Normal.dot, you've probably gone to any number of lengths  to restore it to its original state. The easiest way to restore the Normal.dot template to its original state may surprise you-delete it! When Word can't find the Normal.dot template in the User Templates or Workgroup Templates location (you can determine these locations by selecting Tools/Options from the menu bar and clicking on the File Locations tab) it creates a new Normal template with the standard Word document formats, menu, toolbar, and shortcut key settings.

Volume 6
Place a border around one or more words (97, 98, 2000)

You probably already know that you can place a border around a paragraph using the options in the Borders And Shading dialog box. However, did you know that you can place a border around a text selection? To do so, select the text around which you'd like to create a border. Then choose Format/Borders And Shading from the menu bar. On the Borders property sheet, select the border formatting you desire. When you've finished, select Text from the Apply To dropdown list if necessary; this option should be selected by default since you selected a block of text prior to accessing the dialog box. When you've finished, click OK. Voila! The text you selected is bedecked with a border. This is a handy technique for emphasizing information you'd like people to notice at a glance.

Volume 7
Displaying shortcut keys with ScreenTips in Word (97/98/2000)

You can quickly learn the shortcut keys (aka "keyboard shortcuts") associated with Word's toolbar buttons by displaying them in the toolbar buttons' ScreenTips. ScreenTips are tiny pop-up windows that show a button's name when you hover the pointer over it. To do so, choose Tools | Customize from the menu bar to open the Customize dialog box, and then click on the Options tab. First, select the Show ScreenTips On Toolbars check box to make sure that Word's ScreenTips are turned on. Next, select the Show Shortcut Keys In ScreenTips check box to display each button's shortcut key beside its name when its ScreenTip is displayed. When you've finished, click OK. Now, hover your pointer over a button on one of Word's toolbars to display its name. If the command is associated with a shortcut key, it appears to the right of the button name.

Volume 8
Discover Word's hot spots

If you rely on the right-click method to display shortcut menus, then you'll find that displaying dialog boxes, windows, or other items by double-clicking on certain hotspots is another alternative method to using Word's main menus.

For example, to access the Paragraph dialog box, double-click on any indent marker located on Word's ruler. If you double-click in the empty space to the left of the ruler indent markers or in the empty space to the right of the ruler indent markers, Word displays the Page Setup dialog box. If you've set tabs, just double-click on a tab marker on the ruler and Word opens the Tabs dialog box. If you want to jump to another page of your document, try double-clicking on the page or section number located on the status bar at the bottom left of your screen. This action opens the Go To dialog box. There are more hotspots hidden within Word. Try double-clicking on Section Breaks or footnote reference marks and see what you uncover.

Volume 9
Resuming the numbering scheme of a previous list

Word's Bullets And Numbering feature enables you to create numbered lists and outlines by formatting lists for you automatically. You can apply list numbering using the Bullets And Numbering command on the Format menu, the Numbering button on the Formatting toolbar, or the AutoFormat As You Type feature's Automatic Numbered Lists option.

Occasionally, you might wish to include an unnumbered line or paragraph between list items. For example, you might want to follow item number 3 in your list with an unnumbered paragraph offering detailed information about that item. To do so, you'd press [Enter] to begin a new line and then turn off Word's automatic list formatting temporarily by toggling the Numbering button. At this point, you can type whatever you want and Word will refrain its automatic numbering. When you're ready to continue your list, press [Enter] to begin a new line and then click the Numbering button to resume the previous list's numbering scheme.

Unfortunately, when you interrupt a numbered list with an unnumbered paragraph, Word assumes you're beginning a new list when you turn the Numbering button on again. In other words, it would apply the number 1 (or A, a, I, i, etc.) to the current paragraph when you toggle the Numbering button. If you'd like to continue the previous list rather than begin a new one, choose Format | Bullets And Numbering from the menu bar. Select the Continue Previous List option button and then click OK. When you do, Word resumes the numbering sequence of the previous list, in addition to the same numbering scheme, without affecting your unnumbered paragraph. For example, if your previous list contained items numbered 1, 2 and 3, the continued list would begin with item number 4 instead of 1.

Volume 10
Resize toolbar text buttons and boxes in Word

You can change the appearance of the text buttons, text boxes, and list boxes (regular buttons excluded) located on any of the Word toolbars. If you need to make room for additional buttons, you may want to decrease the size of some of the toolbar boxes, such as the Zoom, Font, or Style boxes. Or, perhaps you'd like to increase the size in order to see the entire entry of each option in a dropdown list.

To change the width of a toolbar text button, text box, or list box, choose Tools/Customize to display the Customize dialog box and enable toolbar editing. Next, click on the toolbar box you wish to resize to select it. Then, move your mouse pointer over the right border of the button until the double-headed vertical arrow appears. Now, simply drag the border to the right to increase the width of the box or to the left to decrease it. After you make the changes, close the Customize dialog box

Volume 11
Copying toolbar button images (97/98/2000)

If you're creating a new toolbar button in a Microsoft Office application, you can copy toolbar button images from one application to another. For example, if you've created a custom macro button in Word, you can apply one of Excel's built-in button images to it. This way, you're not limited to a single application's button image collection. To copy button images between Office applications, open the Office application that contains the button image you'd like to copy. Choose Tools | Customize from the menu bar and click on the Commands tab. Next, click on the button in the toolbar area you'd like to copy to select it, and then click Modify Selection in the Customize dialog box. As an alternative, simply right-click ([control]-click on the Mac) on the button you'd like to copy. In the resulting shortcut menu, choose Copy Button Image. Now open the target Office application in which you'd like to paste the copied button image. Choose Tools | Customize from the menu bar and then click on the Commands tab. This time, right-click (or [control]-click) on the button to which you wish to apply the copied image, and then choose Paste Button Image. The button image you copied will be applied to the button you selected. Click Close to dismiss the Customize dialog box, and then use your new button as desired. (Note: You can copy and paste button images within the same Office application, as well.)

Volume 12
Viewing multiple pages simultaneously

When you're working with a multi-page document layout, it's often helpful to look at it from a birds-eye view. This can help you accurately gauge the layout and length of your document. Viewing multiple pages at the same time also makes it easy to move or copy items from one page to another. You can view multiple pages of your document in Print Preview mode or Print Layout view (Page Layout view in Word 97 and 98). To do so, first switch to Print Preview mode by clicking the Print Preview button in the Standard toolbar, or switch to Print Layout view (or Page Layout view, as applicable) by clicking its corresponding button in the lower-left corner of the application window. Next choose View | Zoom from the menu bar. In the Zoom dialog box, select the Many Pages option button. Click on the option button's corresponding monitor icon, and then choose the number of pages you'd like to display from the resulting pop-up menu. (To extend the pop-up menu's options, click in the pop-up menu and drag the mouse pointer to display additional pages.) When you've finished, click OK. As an alternative, when Print Preview mode is active you can simply click the Multiple Pages button in the Print Preview toolbar to reveal the page-selection pop-up menu. (Note: By default, you cannot edit document contents in Print Preview mode. To enable document editing in Print Preview mode, click on the Magnifier button in the Print Preview toolbar.)

Volume 13
Refine line leading in Word

If you're working on a document that can't exceed a certain number of pages, you can use the Shrink To Fit feature to automatically reduce your text fonts until the overflow text fits on the preceding page. However, this isn't the best way to solve overflow problems if you don't want your document's fonts reduced. An alternative technique involves reducing line leading, or the space between lines. You've probably messed around with Word's preset line spacing options, such as double or single spacing; however, you can configure virtually any degree of leading with the Multiple line spacing option. For example, if double spacing is too much but 1.5-line spacing is too little, try 1.75 line spacing. To do so, place the insertion point in the paragraph you'd like to modify, then select Format/Paragraph from the menu bar. On the Indents And Spacing property sheet, select Multiple from the Line Spacing dropdown list, then type 1.75 in the At text box. When you've finished, click OK. The lines in your paragraph now have 1.75 lines of space between them.

Volume 14
Enabling Overtype mode

By default, Word allows you to insert text in your document without deleting anything you've already typed. If you'd prefer to replace existing text as you type in Word, you can activate Overtype mode. To enable Overtype mode, choose Tools | Options (Preferences on the Mac) from the menu bar and then click on the Edit tab. Select the Overtype Mode check box in the Editing Options panel, and then click OK. As an alternative, you can quickly toggle Overtype mode on and off by pressing the [Insert] key or by double-clicking on the OVR command in Word's Status bar, which is located at the bottom of the application window. Regardless of which method you use to turn Overtype mode on and off, you can easily tell whether it's enabled by looking at Word's Status bar. When the OVR command in Word's Status bar is black, Overtype mode is enabled; when the command is faded, Overtype mode is disabled. (Note: By default, Overtype mode is disabled when you start Word, even if it was turned on the last time you exited Word. in addition, if you've configured Word to use the [Insert] key to paste items from the Clipboard, as we explained in a previous tip, you won't be able to use it with Overtype mode. Instead, enable and disable Overtype mode using one of the alternative methods we've described here.)

Volume 15
Minimize file size with full saves

You can minimize the size of your documents by turning off Word's Allow Fast Saves feature. When turned on, this feature saves only the changes you progressively make to your document. This results in a faster saving time since information that's already been saved once doesn't need to be saved again. However, fast saves can also result in bloated file sizes. Each time you save a document using the fast-save process, information about new changes is tacked on to previously saved information about past changes. To this end, Word might continue to store information about content you deleted from your document during a previous fast save. When the Allow Fast Saves feature is enabled, Word automatically consolidates this information by performing a full save after every 15th save of a document, when the document's accumulation of fast-save changes reaches a peak, or when you save a document over a network. Word also performs a full save whenever you save documents in other formats, such as rich text format (RTF). Saving or converting your documents to RTF format can be another effective way to minimize file size.

However, you can easily minimize the size of existing files (and new files that you create) simply by turning off the Allow Fast Saves feature. Doing so causes Word to save documents using the more space-efficient, full-save process instead. To do so, open the document you'd like to (re)save and then choose Tools | Options (Preferences on the Mac) from the menu bar. Click on the Save tab and then clear the Allow Fast Saves check box. Click OK to dismiss the Options (Preferences on the Mac) dialog box, and then save your document as you normally would. When the Allow Fast Saves feature is disabled, the saving process may take slightly longer, but in most cases you'll hardly notice a difference. (Note: When you disable the Allow Fast Saves feature, it remains disabled during subsequent Word sessions unless and until you enable it again manually.)

Volume 16
Email documents on the fly (97/98/2000)

Many of us share documents with others by sending them as email attachments. Instead of going through the trouble of opening your email program, creating a new message, and attaching the document yourself, why not let Word do it for you? You can easily attach an open Word document to a new email message directly from Word. To do so, open the document you'd like to send, and then choose File | Send To | Mail Recipient from the menu bar. When you do, Word launches your default email client, creates a new message, and attaches a copy of the current Word document to the new message. All you need to do is specify the message's recipients, add any applicable message text if desired, and send the message on its merry way. (Note: This technique works only with MAPI and VIM compatible email clients, such as Outlook and Lotus Notes. Compatible email clients differ on Macintosh systems. For more information about email compatibility with your version and operating system, see Microsoft Word Help.)


   


MS Excel 95/97/2000


Volume 1
Change Excel's default number of worksheets

By default, Excel creates three worksheets in every new workbook. If you find that you routinely don't use all three or that you require more, change the default number that Excel creates. To do so, select Tools/Options from the menu bar. Then, click on the General tab and change the number in the Sheets In New Workbook spinner box to the number of desired sheets.


Volume 2
Quickly navigate previewed Excel files

Excel's Print Preview is helpful for checking the layout of a document before you print, but scrolling through it can be annoying. Depending on the length of the document, you may find it easier to navigate the Print Preview window using shortcut
keys. You probably know that you can use the [Page Up], [Page Down], and direction arrows to move around the current page when a document is zoomed in. However, you can also hold down the [Ctrl] key while using the direction arrows to jump to
the edge of the document that corresponds to the direction arrow. Holding down [Ctrl] while using [Page Up] and [Page Down] lets you horizontally scroll in increments. When the worksheet preview is zoomed out, [Ctrl][Left Arrow] and [Ctrl][Up Arrow]
cause the preview to jump to the first page of the document, while [Ctrl][Right Arrow] and [Ctrl][Down Arrow] move you to the last page.

Volume 3
Speed up your spell check in Excel

Spell checking worksheets helps you catch typos, but it can be cumbersome. For instance, if a worksheet contains acronyms, abbreviations, or field names, you may find yourself repeatedly hitting the Ignore button. Fortunately, Excel can be configured to skip some words that you may not want checked by ignoring all upper-case words. To do so, run the spell checker on data that causes the Spelling dialog box to be displayed. Then, select the Ignore UPPERCASE check box and click OK. You should be aware that this setting carries through to all subsequently spell checked workbooks until it's specifically disabled.

Volume 4
Simplify tracking down Excel formula errors (97/2000)

When you get a worksheet formula error like #VALUE! you may have a hard time finding the cells referenced in the formula that are contributing to the error. You can use Excel's tracer arrows to simplify the process. First, select a cell that contains an error. Then, choose Tools | Auditing | Trace Errors. Excel displays tracer arrows from any referenced cells that contribute to the error to the cell containing the error. You can quickly jump between the formula and the referenced cells by clicking on the appropriate tracer arrow. If you choose Tools | Auditing | Trace Precedents from the menu bar, you can display arrows for the next level of referenced cells. You can use the Trace Precedents feature with any cell that contains a formula, regardless of whether an error has occurred. To remove the tracer arrows, choose Tools | Auditing | Remove All Arrows from the menu bar. These features, and related auditing tools, can also be accessed through the Auditing toolbar. To show the toolbar, choose Tools | Auditing | Show Auditing Toolbar from the menu bar.


Volume 5
Launch Excel without using your mouse (95/97/2000)

Although the mouse has revolutionized the way we work, sometimes it's actually faster to type a command than it is to hunt for an icon to click on. When you need to launch Excel, you may have to minimize several windows to see your Windows desktop or navigate through the Windows Start menu. If you have a keyboard that includes a [Windows] key, you can start Excel without ever taking your hands off the keyboard. First, press [Windows][R] to launch the Run dialog box. Then, simply type "excel" (without the quotes) and press [Enter].

Volume 6
Set print options for multiple Excel sheets (95/97/2000)

To copy print settings from one sheet to others in the same workbook, activate the sheet with the desired settings. Then,
while holding the [Shift] or [Ctrl] key, click on the worksheet tabs of any other sheets that you wish to copy the settings to.
Note that as you do this, the sheet with the desired print settings must remain the active sheet. Next, select File | Page Setup from the menu bar. Finally, click OK. All the basic print settings, including headers and footers, will then be copied over from the active sheet to the other selected sheets.

Volume 7
Copy Excel data with a mouse shortcut

One of the nicest aspects of Excel is that it provides several ways to accomplish the same task, allowing users to choose the method that suits them best. Here's a shortcut you can use to replace the process you probably follow to copy and paste data. First, select the data that you want to copy. Then, move your mouse pointer to the edge of the selection so that it turns into an arrow. Next, hold down the [Ctrl] key and you'll notice a small plus sign (+) next to the pointer. You can now drag and drop with the mouse to create a copy of the data while leaving the original data in place. If you prefer to move the data completely, as if you were cutting and pasting, just skip holding down the [Ctrl] key.

Volume 8
Use Excel's number formatting to scale numbers

Often, you'll want to refer to numbers in terms of thousands or millions. However, if you already have the complete numbers entered in worksheet cells, you may wonder how to convert them. Fortunately, you don't have to change the entries at all -- just change the number format. To do so, select the cells you want to change and then select Format/Cells from the menu bar.
Then, click on the Number tab and select Custom from the Category list box. Next, replace the codes in the Type text box with one of the codes below:

For thousands: #.##,

For millions: #.##,,

Finally, click OK. The numbers will be displayed in terms of thousands or millions, with two decimal places.

Volume 9
Linking AutoShapes to Excel data

As you may know, AutoShapes are pre-defined drawing objects, such as starbursts, circles, and arrows, that you can add to a worksheet to improve its appearance. Most AutoShapes allow you to add text, making them useful for calling attention to particular data. To get the most out of AutoShapes, you can link data from worksheet cells to the shape, so that the information reflected in the AutoShape is always current. To do so, choose View | Toolbars | Drawing from the menu bar to display the Drawing toolbar. Then, choose an appropriate shape from the AutoShapes menu and use your mouse to draw the shape on your worksheet. While the shape is still selected, click in the Formula bar and enter a formula that links to a worksheet cell, such as

=A1

to display whatever value is in cell A1. Finally, press [Enter]. You can now use the formatting options for the AutoShape to control the appearance of the linked data.

Volume 10
Controlling Excel's personalized menus and toolbars (2000)

If you dislike Office 2000's new menu system, which initially shows only the most recently used menu items, you can revert to the standard menu behavior you're used to. To do so, right-click on the menu bar and choose Customize from the shortcut menu. Then, click on the Options tab of the Customize dialog box, clear the Menus Show Recently Used Commands First check box, and click Close. If you like the personalized menus, but find that too many infrequently accessed menu commands are being displayed, you can restore the menus to the state they were in when Excel was originally installed. You should be aware, however, that resetting the menus also resets Excel's toolbars to their original states. To reset the menus and toolbars, display the Customize dialog box and click the Reset My Usage Data button on the Options sheet. Finally, confirm that you want to reset the data and click Close.

Volume 11
Quickly copy formats in an Excel worksheet

To copy formatting from one worksheet range to another, you probably use Excel's Format Painter tool. However, there's sometimes a quicker way. If the cells are adjacent to each other, select the cell containing the formatting you want to copy. Then, right-click ([Ctrl]-click on the Mac) and drag the fill handle (the small square in the lower right corner of the cell) to the cells you want to format. When you release the mouse button, select Fill Formats from the shortcut menu. If the cells aren't adjacent, select the formatted cell, right-click on its border ([Ctrl]-click on the Mac) and drag it to the target cell. When the shortcut menu appears, select Copy Here As Formats Only from the shortcut menu.

Volume 12
Quickly move to the ends of an Excel worksheet

Using shortcut keys, you can quickly move your cell selector to opposite corners of a worksheet. To move to cell A1, press [Ctrl][Home]. To move to the last cell, as defined by the intersection of the rightmost used column and bottom-most used row, press [Ctrl][End].

Volume 13
Shading alternating rows in an Excel worksheet

If you've ever worked with reports printed on greenbar paper, you know that this simple formatting technique can greatly improve the readability of your data. Now that line feed printers are all but extinct, it's unlikely that you come across reports printed this way anymore. However, you can easily reproduce the effect within your Excel worksheets, using the Format Painter. To show you how, we'll create alternating bands of color that are two rows tall. First, select range A1:J2 in a workbook. Next, fill the range with a color from the Fill Color palette that won't overwhelm the worksheet, such as light gray or light green. Now, you must select the range you previously highlighted, as well as enough blank rows beneath it to double its size. For our example, select range A1:J4. At this point, click the Format Painter button on the Standard toolbar. Finally, select range A5:J5 and drag your mouse pointer down to highlight as many cells as desired.

Volume 14
Adjust column widths in Excel's Print Preview

When you're previewing a worksheet before printing, you can make minor formatting adjustments without returning to the worksheet's normal view. To do so, click the Margins button. This reveals the header, footer, and page margins, which appear as dotted lines that can be moved with your mouse. In addition, you'll notice several small black handles at the top of the page. These correspond to your worksheet's column borders, and you can drag the handles to resize your columns as needed.

Volume 15
Protect yourself from Web-based exploits targeting Excel 2000

Unfortunately, the ability for Office applications to work with HTML and access the Internet sometimes makes systems running Office vulnerable to Web-based attacks. Microsoft has released two patches to combat the most recently identified security holes relating to Excel 2000. The first patch addresses a vulnerability that allows a programmer to use HTML Object tags in an Office document in a way that could result in a system crash or the execution of a malicious code. The patch can be found at: http://office.microsoft.com/downloads/2000/Of9data.aspx

The second security patch addresses an issue with a component of the Web folders feature that could allow a user to determine network logon information through an email or Web page. You can obtain this update at: http://office.microsoft.com/downloads/2000/wecsec.aspx

Both patches require that you have your Office CD on hand and Office 2000 SR-1 installed before you apply the updates. Although one of the download pages claims you need SR-1a, if you've already installed SR-1, that's all you need. The Web Client Security Update also requires Internet Explorer 5.0 or higher.

Volume 16
Show Excel's complete Standard and Formatting toolbars (2000)

One aspect of Excel 2000 that many users find annoying is the fact that the Standard and Formatting toolbars share the same row. While this minor conservation of space could be appreciated when large monitors were a luxury, it's likely that you're no longer constrained by limited monitor real estate. To configure Excel so that both toolbars appear in their own rows, select View | Toolbars | Customize from the menu bar. Then, click on the Options tab, clear the Standard And Formatting Toolbars Share One Row check box and click OK.


   


MS PowerPoint 95/97/2000


Volume 1
Adjusting text height without losing width in PowerPoint

Sometimes it's difficult to fit a title onto a PowerPoint slide without losing height. This is because PowerPoint doesn't have an option that lets you adjust the spacing of your text. However, there is a way that you can adjust the height of your text without it affecting the width of your text. To do this, open a blank slide and set a line of text using a large font size. Make sure your text doesn't run off the edge of the slide. Save this slide as a JPEG File Interchange and insert that file as a picture. Once you place that slide in PowerPoint, you can use the Crop tool to adjust its bounding box and then use the bounding box to resize your text. This way you can get the look you want by manipulating your text like a clip art image.


Volume 2
Draw and erase during PowerPoint slide shows   

You can use the shortcut command [Ctrl]P ([c]P on the Mac) to access the Pen tool during a slide show. Click your mouse and drag to use the Pen tool to draw during your slide show. To erase everything you've drawn, press the E key.

Volume 3
PowerPoint's Office Assistant tip of the day

If you're looking for a PowerPoint tip, you don't necessarily have to search all over the Internet; the Microsoft Office Assistant has a new tip each day. In PowerPoint '97, you can view this tip by pressing [F1] and clicking the Tips button.


Volume 4
Revealing a slide as a puzzle in PowerPoint (95,97,98,2000)

For a cool visual effect, you can make a slide gradually reveal itself, puzzle piece by puzzle piece. To do this, start by inserting a picture or logo onto a PowerPoint slide. Next, insert the Jigsaw clipart image, located in the Shapes category, onto your slide. Then, select the puzzle object, choose Draw | Ungroup, select each individual puzzle piece, and change the fill color of each to black.

At this point, select all the black puzzle pieces and choose Draw | Group. Then , press [Ctrl]G to display PowerPoint's guides that split the slide into four equal quadrants. Drag the puzzle image into the upper-left section of the slide and use the selection handles to resize it so that it fills one quadrant. With these pieces in position, copy the puzzle object and fill the remaining quadrants with the puzzle pieces until the slide is completely black.
From this point forward, follow these steps to create a total of 20 slides. Press [Ctrl]A to select all the objects on the slide. Press [Ctrl]C to copy the objects to the Clipboard. Add a new, blank slide. Press [Ctrl]V to paste the objects onto the new slide. Choose Edit | Select All and press [Ctrl]C to make a copy of all the objects on the slide.

Insert a new slide and paste these objects onto the new slide by pressing [Ctrl]V ([Cmd]V on the Mac). Then, click outside the slide to deselect the objects on your slide. Finally, select one of the black puzzle pieces at random and delete it. To animate these slides, apply the slide transition effect Dissolve to the slide show so that each puzzle piece disappears after a few seconds, revealing your image.
 
Volume 5
Hiding slides in PowerPoint (97,98,2000)

To hide a slide during a presentation, first click the Slide Sorter View button or choose Slide Sorter from the View menu. Click on the slide you want to hide and click the Hide Slide button on the Slide Sorter toolbar, or press [Alt]DH if you're using a PC. After you hide the slide, PowerPoint encloses the slide number in a box with a diagonal line through it. Now that you've hidden a slide, PowerPoint will skip it during the actual slide show unless you choose to display it. If you need to hide multiple slides, hold down the [Shift] key ([Ctrl] in 2000), select each slide you wish to hide, and then click the Hide Slide button.

Volume 6
Playing MP3s in PowerPoint (97,98,2000)

You can play MP3s during a slide show in PowerPoint if you own Winamp. To do this, copy an MP3 file from your hardrive and paste it onto a PowerPoint slide. Now that your MP3 is inserted on your slide, you can begin using PowerPoint's Custom Animation feature to set up the track for playback.

To do this, choose Slide Show | Custom Animation. In the Timing property sheet, select each item with an Object prefix until you find your MP3 from the Slide Objects Without Animation list box. Now, choose Animate in the Start Animation panel.
Now that you've indicated how the MP3 will begin playing, you need to tell PowerPoint to activate the file. Click on the Play Settings tab in the Custom Animation dialog box and select Activate Contents from the Object Action dropdown list. Finally, choose Tools | Options and then click on the General tab. Next, deselect the Macro Virus Protection check box so that PowerPoint won't warn you that the MP3 you're using could contain a virus. Make sure you turn virus protection back on when you've finished with your presentation.
When you run your slide show, Winamp will open the MP3 if it's your only MP3 player. If you also own RealPlayer, you need to make sure that Winamp is set up as your default MP3 player before you run your slide show.

Volume 7
Creating a Mouse-Click hyperlink in PowerPoint (97,98,2000)

To create a clickable hyperlink between an object and a WAV file in PowerPoint, first select a clipart image, AutoShape, or text object on your slide. Next, choose Slide Show | Action Settings to open the Action Settings dialog box. Make sure the Mouse Click property sheet is visible, and select the Play Sound check box located at the bottom. Next, choose Other Sound from the Play Sound dropdown list. When the Add Sound dialog box appears, locate the sound file you want to insert and click OK. When you do, you'll hear a sample of the sound file you chose.

At this point, select the Highlight Click check box at the bottom of the Mouse Over property sheet. By selecting this option, in Slide Show view your image will light up for a brief second each time you click on your linked image, indicating that the hyperlink is being activated. Finally, click OK to exit the Action Settings dialog box. To test your hyperlink, choose Slide Show | View Show. You'll notice that your pointer changes to a hand as soon as it touches the linked image. When you click on the selection, the sound file plays and your image appears as a negative.

Volume 8
Saving a presentation as a self running show

To save a presentation as a self-running show, open a regular presentation file, preferably one that contains five or more slides. Once you've done this, choose File | Save As from the main menu. If necessary, enter a name for your presentation in the File Name box. Next, select PowerPoint Show (*.pps) from the Save As Type dropdown list and click the Save button. When
you do, PowerPoint automatically saves your file as a presentation show. If you save a file as a PowerPoint Show on the PC, you can open it on the Mac and vice versa. Once you save your presentation in the PPS format, close the file and exit PowerPoint. Then, navigate to the file and double-click on it to open it. When you double-click on the file, the show starts without making PowerPoint visible. At the end of the show, PowerPoint disappears as if it were never even running.

Volume 9
Inserting an online motion clip into PowerPoint (2000)

If you'd like to insert a motion clip onto a PowerPoint slide, you may want to search Microsoft's Clip Gallery Live. To do this, first choose Insert | Movies and Sounds | Movie from Gallery and then click the Clips Online button when PowerPoint displays the Insert Movie dialog box. If PowerPoint displays an informational message about accessing the Web, click OK, but remember, you must have Internet service to download from a Web site.

First-time visitors to the Clip Gallery will need to click the Accept button before proceeding. Clicking the Accept button launches the Clip Gallery's home page. You'll notice that there are four controls located along the left side of the Clip Gallery Live Web page. At this point, enter a word or phrase in the first control and then select Motion from the 3rd control's dropdown list. Click Go (to the right of the first control) and the gallery will return appropriate motion clips. Select the check box located next to the clip you like, click the Download 1 Clip link, and then click the Download Now link in the resulting window. The Clip Gallery will download the file to your local gallery.

If you end up with two Insert Movie dialogs on your Taskbar, close the current one, which is the result of the download task. (You must save the downloaded clip to a particular gallery category if you want to permanently save the clip to the gallery.) Now, return to the original Insert Movie dialog, click the motion clip icon, and choose Insert Clip (the first option) from the resulting shortcut menu to insert the clip on your slide.

Volume 10
Create a PowerPoint presentation with more than one template (95, 97, 98, 2000)

If you want to use more than one template in a presentation, it looks like you're in luck. To do this, open a presentation using a template and save the first slide in this presentation as a JPEG Interchange Format. Now, open a new presentation with a different template and insert the JPEG file you saved as a picture. You can resize this JPEG to cover your slide and act as an actual template. Any new slides you add to this presentation will use the template you selected when you opened the presentation.

Volume 11
Link two presentations together for continuous playback (97,98,2000)

To link two presentations together for continuous playback, first save both presentations you'd like to loop in a folder. Next, choose one of your presentations (either one will do) and double-click on the last slide. With the last slide visible, choose Insert | Object to open the Insert Object dialog box. Select the Create From File option button and then click the Browse button to open the Browse dialog box. Locate the folder containing your two presentations and select the other presentation you'd like to link to. Click OK. Next, select the Link check box (this option isn't available in PowerPoint 98) and the Display As Icon check. Click OK to insert the link.

You'll notice that the link now appears as an icon on your slide. Drag this icon off the side of your slide. Now you need to tell PowerPoint when to display the linked presentation. To do this, right-click ([control]-click on the Mac) on the icon and choose Custom Animation. If the Effects tab isn't already visible, select it. Next, change No Effect in the Entry Animation And Sound area to Appear. Then, click on the Multimedia Settings tab (Play Settings tab in PowerPoint 97 and 98) and select Show from the Object Action dropdown list. Finally, click on the Order & Timing tab (Timing tab in PowerPoint 97 and 98) and select the Automatically option button. The default time of 00:00 seconds is fine. Click OK to apply the changes.

Now set up your slide transitions. Next, choose Slide Show | Set Up Show to open the Set Up Show dialog box. In the Show Type area, select the Loop Continuously Until 'Esc' check box.

Volume 12
Navigating through PowerPoint's menus

Do you know how to navigate PowerPoint's menus without using the mouse? If you don't like using the mouse to move through a menu, you can access a menu simply by pressing the [Alt] key in conjunction with the first letter of the menu you'd like to open. For example, if you press [Alt]F, the File menu opens. Once you open a menu, you can use the arrow keys to navigate further. To go up and down in a menu, press the up and down arrow keys. You can use the right and left arrow keys to open submenus or to move right and left through the standard toolbar menus.

Volume 13
Put old templates to work in PowerPoint

If you're getting sick of the same old templates, use the Slide Master to create new templates from existing ones. In Slide Master view, you can select images that make up each template and move, rotate, or resize them to create a new template. You can also copy the separate parts of a template and paste them to create unique-looking templates. For example, you can resize the notebook paper in the Portrait Notebook template, make a copy, and then paste it to add a second notebook page to your template. You could position one notebook page on one half of the template and the other notebook page on the other to create two columns. The possibilities are endless.

Volume 14
PowerPoint 97's 3-D Rotation add-in (97 only)

There's an add-in available for PowerPoint 97 that lets you rotate a 3-D object in 1-degree increments. If you're looking for precision, this add-in is the key. You can download the 3-D Rotation add-in by visiting http://www.microsoft.com/downloads/search.asp? This takes you to the Download Center page. From the Product Name dropdown list, select PowerPoint 97 For Windows 95. Next, select your operating system from the Operating System dropdown list and click Find It. The search will generate a list of downloads. In the Title list, click on the PowerPoint 97 Add-in: 3-D Rotation link and then follow the instructions to download the add-in. Once the 3Drotate.exe file appears on your desktop, double-click it to begin the installation process. After you install the add-in, you need to load it. To do this, launch PowerPoint and open a new presentation with a blank slide. Next, choose Tools | Add-Ins to open the Add-Ins dialog box. Any add-ins that are currently loaded will appear in the Available Add-Ins list. Click the Add New button. This opens the Add New PowerPoint Add-In dialog box. Locate the Three.ppa file in the Add-Ins folder and select it. When you do, a preview image will appear in the Preview window. Click OK and a warning dialog box will appear. Click Enable Macros to ignore the warning. When you do, THREED will appear in the Available Add-Ins list. Click Close to exit the Add-Ins dialog box. Choose Tools | 3-D Rotation to use the 3-D add-in.

Volume 15
PowerPoint 2000's Custom Soundtrack feature (2000)

It turns out that a lot of PowerPoint 2000 users receive the message "PowerPoint couldn't open the Visual Basic for Applications project in presentation C\:Program Files\Microsoft Office\Officeppmusic.ppa." There's a legitimate reason for this error. When you install Office 2000 over Office 97, any add-ins that you installed or created in PowerPoint 97 may not be compatible with PowerPoint 2000. One of these features happens to be the Custom Soundtrack add-in. To fix this problem so that the error message doesn't appear each time you launch PowerPoint, you can install the PowerPoint 2000 Custom Soundtrack add-in. To do this, first download the Custom Soundtrack add-in by going to http://www.microsoft.com/downloads/search.asp Next, select PowerPoint 2000 from the Product Name dropdown list and select your operating system from the Operating System dropdown list. Click Find It and the search engine will generate a list of PowerPoint 2000 downloads. Click on the PowerPoint 2000 Updated Custom Soundtrack Add-in (Pp2kmus.exe) located in the download list. Finally, click the file name Pp2kmus.exe on the resulting page and save the file to your desktop. Once you download the EXE file, you have to replace the current Ppmusic.ppa file with the updated 2000 Ppmusic.ppa file. Locate the old ppmusic.ppa file and double-click the Pp2mus.exe file on your desktop to install the program. Accept the license agreement and then enter the location of the old Ppmusic file in the PowerPoint 2000 Custom Soundtrack Add-in dialog box. Click OK and another dialog box will appear asking you if you want to overwrite the pre-existing Ppmusic file. Click Yes to overwrite the file.

Volume 16
Using your own sound effects in PowerPoint (97/98/2000)

If you have a WAV file available on your computer, you can use it as an animation sound effect in PowerPoint. To do this, first launch PowerPoint and open an existing presentation that contains animation. Next, navigate to a slide that has several animated objects and choose Slide Show | Custom Animation to open the Custom Animation dialog box. You can also right-click ([control]-click on the Mac, and select Custom Animation from the resulting shortcut menu. At this point, click on the Effects tab and select Other Sound from the Entry Animation And Sound dropdown list. In the Add Sound dialog box, locate a WAV file and click OK to return to the Custom Animation dialog box. If you need to change any animation effects in the Custom Animation dialog box, do so at this time. If you're satisfied with your changes, click OK. To test your sound effect, choose Slide Show | View Show or click the Slide Show view button to launch your presentation. Next, cycle through your slide animations. When you reach the object that you applied a sound effect to, the sound will play.



   


MS Access 95/97/2000


Volume 1
Create new fields from Access's Datasheet view

If you've ever needed to create a table field on the fly while working in Datasheet view, you probably found switching to Design view and setting up the field a nuisance. There's a much quicker way to create a field from Datasheet view. Simply right-click on the column heading of the column you want immediately to the right of your new field. Then, choose Insert Column from the shortcut menu. Access creates a field with a name resembling "Field1" that you can then immediately start entering data in. You can also use the shortcut menu to rename or delete the newly created field. You'll most likely want to go to Design view at some point to set the field's properties. However, depending on your reason for creating the field, you may find that creating it in the Datasheet view is more efficient for your immediate needs.

Volume 2
Close Access completely from a switchboard

If you used the Switchboard Manager add-in to create a front end for an application, chances are that you used the Exit Application command as a button choice to close the application.  One drawback is that although it does close your application, it leaves Access open. If you'd rather have the button exit completely from Access, add the following to a module:

Sub ExitAccess()
Application.Quit acPrompt
End Sub

Then, change the Command that the button executes to Run Code. Finally, enter ExitAccess in the Function text box and save the changes to the switchboard.

Volume 3
Append records from Access's Database window

If you hate setting up Append queries, you can take advantage of an Access shortcut for appending data. First, right-click on the table containing the data you want to append and choose Copy.  Then, right-click on the file and choose Copy. Now, right-click on the background of the Database window and choose Paste to display the Paste Table As dialog box. Enter the name of the table you want to append to in the Table Name text box. Finally, select the Append Data To Existing Table option button and click OK.  Note that you can also use the Copy and Paste buttons on the Database toolbar to perform these actions.


Volume 4
Highlight the current Access control (95/97/2000)

Many users have trouble knowing which text box on a form they're currently working with. One way to make it clear for users is to highlight the current one, for example, with a yellow background. Access 2000 allows you to do this with conditional formatting, but you can also get a similar result using code. To do so, create a new module and add the following code:

Function Highlight(Stat As String) As Integer
Dim ctrl As Control
On Error Resume Next
Set ctrl = Screen.ActiveControl
If Stat = "GotFocus" Then
    ctrl.BackColor = 65535
ElseIf Stat = "LostFocus" Then
    ctrl.BackColor = 16777215
End If
End Function

Save and close the module, then open the form you want to apply the highlighting to in Design view. Click the Code button and insert

Highlight("GotFocus")
in each textbox control's GotFocus event procedure. Likewise, add
Highlight("LostFocus")

to each textbox's LostFocus event procedure. When you've finished, save the changes, close the VBE, and switch to Form view. When you tab to a field, it's shaded yellow. When you tab away from the field, its background is restored to white.

Volume 5
View multiple pages of an Access report at once (95/97/2000)

When you preview an Access report, you may want to see several pages at one time to examine the layout of the report. You may know that you can do so by choosing View | Pages from the menu bar. However, this technique limits how you view the pages -- you can only view 1, 2, 4, 8, or 12 at a time. For more control over how the pages are displayed, right-click on the report preview and choose Multiple Pages (just Pages in Access 95) from the shortcut menu. In Access 95, you can then pick a configuration of preview thumbnails ranging from 1 page to a layout of 4 x 5 pages. You may think that your choices are limited if you're using Access 97 or 2000, as the default layout grid is 2 x 3 pages. However, if you click and drag with your mouse, you can select a range of up to 4 x 5 pages.

Volume 6
Simplify creating hyperlinks in Access tables (97/2000)

When you populate a hyperlink field in a table, you probably cut and paste the URL from your browser into the Insert Hyperlink dialog box.  However, there's an even easier way to do this using Internet Explorer.  First, open the Access table you're updating and Internet Explorer.  Then, select the hyperlink field you want to create the link in and choose Insert | Hyperlink from the menu bar.  Then, press [Alt][Tab] or use your mouse to select the browser window. Browse to the page you want to link to and then switch back to Access.  You'll find that the URL is automatically inserted in the dialog box.

Volume 7
Turning off AutoCorrect in Access (97/2000)

By default, Access has the AutoCorrect turned on. Unfortunately, that setting could cause a few problems during data entry. For example, suppose you have a customer database, and you have a record with a customer code of BCAK. The AutoCorrect feature will automatically change it to BACK as soon as you enter it into your table. To turn off the feature, choose Tools | AutoCorrect from the menu bar, clear the Replace Text As You Type checkbox and click OK.

Volume 8
Quickly move to an Access datasheet column

When you're working with a table in Datasheet view that has many fields, navigating between columns can be a pain. 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. The focus will move to the appropriate field within the current record.

Volume 9
Disable Access confirmation dialog boxes (97/2000)

Access's confirmation dialog boxes often prevent user errors that would have dire effects on data or an application by putting the brakes on potentially risky actions. Hopefully, the intrusion of the dialog box slows the process down enough so that users don't accidentally delete a needed database object or record. Likewise, confirmation dialog boxes are displayed before executing action queries, providing users with an out before committing irreversible changes to the database. Although you probably want these confirmation dialog boxes in place for end-users, you may find that they slow your work down too much--and you may click through the dialog boxes so quickly out of habit that they're essentially ineffective. If you're willing to live with the risk, you can prevent Access from displaying confirmation dialog boxes. To do so, choose Tools | Options from the
menu bar and click on the Edit/Find tab. Then, clear the appropriate check boxes in the Confirm panel that correspond to the dialog boxes you want to suppress. Finally, click OK.

Volume 10
Customize keyboard navigation in Access

Chances are that you take for granted how your direction arrow and [Enter] keys behave in Access. Typically, when you press [Enter] the focus moves to the next field and the contents of the field are selected. Likewise, when you press the direction arrow keys, the focus moves to the next field in the appropriate direction. You aren't forced to accept these behaviors. If you'd like, you can set up the arrow keys to move from one character to the next in the current field, rather than moving focus to the next field. You can also configure the [Enter] key to move to the next record when it's pressed or configure it to do nothing at all. When you do move focus to another field, you have the option to place the insertion point at the beginning or end of the field, rather than selecting the field's entire contents. To modify these settings, choose Tools | Options from the menu bar and
click on the Keyboard tab. Then, simply make the selections you want and click OK.

Volume 11
Avoiding variable problems in your Access code (97/2000)

It's good practice to always use the Option Explicit statement that appears in the beginning of your code modules to ensure that all variables are explicitly declared in your procedures. With this procedure in place, you'll receive a "Variable not defined" error if you try to execute code containing undeclared variables. Without this statement, it's possible to mistype variable names, which would be interpreted as new Variant type variables. This could severely impact the results of your code, and you might not ever know it. If you do find a problem, tracking down where the error is can be a chore.

In Access 97, new modules contain the Option Explicit statement by default. However, this isn't the case in Access 2000. Although you can manually type the statement into your modules, changing a setting in Access can ensure that the statement is always added to new modules. In Access 2000, open a module and then choose Tools | Options from the menu bar. Then, on the Editor sheet of the Options dialog box, select the Require Variable Declaration check box in the Code Settings panel. Finally, click OK. Although the setting should already be set in Access 97, you can access it by choosing Tools | Options from the menu bar, regardless of whether or not you're working in a module, and switching to the Module sheet. You'll then find the option in the Coding Options panel.

Volume 12
Hiding columns in Access' Datasheet view

When you're working with a recordset in Datasheet View, you can easily hide columns containing data that you don't need to immediately work with. To do so, select any field in the column and choose Format | Hide Columns from the menu bar. As an alternative, right-click on the column's field name and select Hide Columns from the shortcut menu. To redisplay hidden columns, select Format | Unhide Columns from the menu bar. Then, select the check boxes next to the field names of any columns you want displayed and click OK. Note that you can select the Unhide Columns command even if no columns are hidden, allowing you to easily hide multiple columns by clearing the appropriate check boxes.

Volume 13
Simplify text entry with the Zoom dialog box in Access

Entering text can be difficult when the size of the text box you're working with is smaller than the text you need to enter. Fortunately, you can zoom in on form controls, table fields, cells in the QBE grid, and other text entry cells. To do so, press [Shift][F2] to display the Zoom dialog box. This feature is available throughout Access, and can also be used with property sheets and table and macro design grid cells.

Volume 14
Change the appearance of text in Access' Zoom box (2000)

You're probably already aware of Access' Zoom box, which allows you to display the contents of a text box in a dialog box for easier editing and viewing. Although viewing long expressions is more convenient in the Zoom box, it's still sometimes difficult to follow what's displayed due to the font Access uses by default, so you may have gotten out of the habit of using the Zoom box. Fortunately, Access 2000 allows you to change the font that the Zoom box uses. To display the Zoom box, select the text box you want to expand and press [Shift][F2]. Then, just click the Font button, set the options you want, and click OK. The settings you select are used whenever you display the Zoom box during your current instance of Access. However, the next time you start Access the Zoom box font settings will revert to their defaults.

Volume 15
Correctly declaring multiple variables (Access 97/2000)

If you want to declare multiple variables in one line of code, be sure to specify the type for each variable, even if the variables are the same type. For instance, avoid code like the following: Dim strFirstName, strLastName, strTitle As String

In such a case, only the last variable, strTitle, is actually declared as a String type. The first two variables are created as Variant data types. To correctly declare the three variables, you would use the statement Dim strFirstName As String, strLastName As String, strTitle As String

Volume 16
Easily create formatted Excel sheets from Access data (97/2000)

Access provides an easy way to export data to Excel through the Office Links feature. To use this feature, simply select a relevant database object and choose Tools | Office Links | Analyze It With Excel. The worksheet Excel creates includes some minor formatting applied to the field headings that appear in row 1. However, you should be aware that some formatting in your original Access database affects the worksheet cell formatting as well. For example, if you're exporting from a datasheet, gridline and font attributes are carried over to Excel. If you use the Office Links feature to export data behind a form, text box shading and font properties are applied. The final result in Excel may not exactly match your Access data (for example, colors may get changed and bold formatting is lost); however, you'll probably find that less work is required to get your Excel version of the data into an easily readable state.


   


MS Win95/98


Volume 1
Using the DOS Diskcopy command

When you need to make a copy of a floppy disk, you probably use Windows 95's Copy Disk utility. To access the Copy Disk utility, you launch My Computer or Windows Explorer, right-click the floppy disk drive icon, and then select the Copy Disk command from the shortcut menu. When you do, you'll see the Copy Disk dialog box.
Unfortunately, the Copy Disk utility is actually limited when compared to its DOS counterpart--the Diskcopy command. Windows 95's Copy Disk utility is fine for making quick, single copies of disks. 

However, if you need to make more than one copy of a disk, the utility forces you to copy the original each time it makes a duplicate. In contrast, DOS's Diskcopy command lets you make multiple copies of the same disk without having to recopy it over and over again. Therefore, if you want several copies of a disk, you'll save time by using Diskcopy instead of Copy Disk.

To do so, simply open an MS-DOS Prompt window and type the command

Diskcopy A: A:
You can also make a shortcut to this command and put it on your desktop for easy access.

Volume 2
Using Alt+Tab to maneuver   

Most of us know that Alt+Tab allows you to switch between open Applications (in Windows).  But did you know that Alt + Shift +Tab (which works in the same way) allows you to cycle through the applications in reverse order.
Also, CTRL+Tab often allows you to cycle through the open documents within one application.  Unlike the above, however, this does not work with all applications.

Volume 3
Removing the Internet Explorer icon from your desktop

If you like to keep your desktop free from unnecessary clutter, you may have wondered if you could remove the Internet Explorer 5.0 icon from your desktop. After all, it's much easier to launch Internet Explorer by clicking its icon in the Quick Launch tool bar.
To remove the Internet Explorer icon from your desktop, launch Internet Explorer, pull down the Tools menu, and select the Internet Options command. When you see the Internet Options dialog box, select the Advanced tab. Then, scroll though the Settings list until you locate the Show Internet Explorer On the Desktop check box. Now, click the check box to clear it. Finally, click OK to close the Internet Options dialog box.

Volume 4
Creating a Favorites Web page

If you would prefer a larger view of your Favorites menu, why not turn it into Web page? To do so, pull down the File menu and select the Import and Export command. Then, follow the instructions in the Import/Export Wizard to export your Favorites menu to an HTML file. To load the file into Internet Explorer, pull down the File menu, select the Open command, and use the Open dialog box to locate the file.

Volume 5
Use the Show Desktop button

As you use Windows 95 with Active Desktop day-to-day, it's easy to forget about the little things-like the Show Desktop button.  When you need to access the desktop, don't minimize all your open windows one by one-click the Show Desktop button. When you're finished on the desktop, click the Show Desktop button again to return all the windows to the way they were.

Volume 6
Speed up the start up

If you want to speed up Windows 98's start up procedure, you can shave a few seconds by making some changes to the Msdos.sys file. However, the Msdos.sys file is a System file that has both the Read-only and Hidden attributes enabled, so it won't show up in either My Computer or Windows Explorer unless you've enabled the Show all files option on the View tab of the Folder Options properties dialog box. Once you've found Msdos.sys, you need to disable the Read-only attribute so that you can edit the file. To do so, right-click the file's name in the window and select Properties from the shortcut menu. When you do, you'll see the Msdos.sys Properties dialog box. At this point, deselect the Read-only check box and click OK. (Don't worry about the Archive and Hidden check boxes--you can leave them selected.)


Now, launch Notepad, open the Msdos.sys file, locate the [Options] section, and add the setting BootDelay=0. Then, save the Msdos.sys file and close Notepad. Finally, return Windows Explorer or My Computer, access the Msdos.sys Properties dialog box again, and re-enable the read-only attribute.

Volume 7
Using the Cool Switch

In addition to using Windows 98's taskbar to switch among running applications, you can use the Cool Switch. So named in the Windows 3.x days when it was the only way to switch among running applications, the Cool Switch still exists in Windows 98. To use it, press [Alt][Tab]. When you do, you'll see a window in the center of your screen showing all the applications currently running on your system. If you press [Alt][Tab] while the window is open, you'll advance to the next application in the list. When you release the keys, the program that was selected will come to the foreground. If you press [Shift][Alt][Tab] while the window is open you can move backwards in the list.

Volume 8
Disabling delete confirmation

When you drag a file to the Recycle Bin, Windows 95 always displays the Confirm File Delete dialog box and requires you to click Yes before the file is moved to the Recycle Bin.

However, since you can easily retrieve a file from the Recycle Bin, this extra step could be considered overkill. Fortunately, you can disable this confirmation dialog box. To do so, right-click the Recycle Bin icon and select Properties from the shortcut menu. When the Recycle Bin Properties dialog box appears, select the Display Delete Confirmation Dialog check box to disable this feature. Then click OK.

Volume 9
Printing your screen or a dialog box

In the old days, if you ever wanted to print the contents of your screen, you pressed the [Print Screen] key on your keyboard and your printer would begin printing. However, Windows 95 redirects the destination of the [Print Screen] key to the Clipboard. This means that if you want to print the contents of your screen after pressing [Print Screen], you have to open Paint or another application, open the Edit menu, and select the Paste command. Then, choose File | Print to send it to the printer. If you only want a printed copy of the active window or dialog box on your screen, press [Alt][Print Screen] and then paste the contents of the Clipboard into a document.

Volume 10
Accessing Find quickly

To quickly access Windows 95's Find utility without going through the Start menu maze, simply click once in a blank spot on your taskbar and then press [F3]. When you do, you'll immediately see the Find window and can quickly initiate your search.

Volume 11
Navigate in Windows Explorer using the Address Bar (Win98)

In the Windows Explorer window, you're probably used to seeing the Address Bar just under the Standard Buttons toolbar. (If you don't have it displayed, just choose View | Toolbars | Address Bar.) When you see the word Address you might think it's only used for navigating to Web sites. But you can also use it to traverse your directory tree via the keyboard.

Just place the insertion point in the Address text box by clicking in it or pressing [Alt]D, and then start typing the name of the folder you want. If you start with a drive letter such as C:\, you get a dropdown list of the folders at that level. If you select a file, such as a text file, that's saved at the root of the C: drive, when you select the filename and press [Enter], the contents appear in a Notepad window.

Actually, you can get away with just typing the back slash (\) to get a list of all the folders and files off the root of the C: drive. Then just start typing the folder name. As you do, the list only includes those folders with the characters you're typing. Now use your mouse to select the folder name from the drop-down list and the folder opens in Windows Explorer. If you want to open a text file that's saved at the root of the C: drive, just type the back slash and select the filename, and then the contents appear in the right pane of Windows Explorer.

Volume 12
Creating a SendTo Recycle Bin shortcut

If you want to be able to quickly and easily delete files, you can create a shortcut to the Recycle Bin and then move it to the SendTo folder. To do so, right-click on the Recycle Bin icon on your desktop and select the Create Shortcut command from the shortcut menu. Now, open either My Computer or Windows Explorer and locate the \Windows\SendTo folder. Then, move the shortcut to the Recycle Bin from the desktop to the \Windows\SendTo folder. For consistency, you may want to rename the shortcut by eliminating the words "Shortcut to." Now, you can easily delete any file by right-clicking on it and selecting the SendTo\Recycle Bin command.

Volume 13
Selecting multiple files

When working in Windows Explorer or the My Computer window, you might need to perform the same action on more than one file in a folder. For example, you might need to copy a group of files to another location. You might think you have to copy each file individually, but you don't. Just select all the files at one time and then copy (or delete) them together.

To select a group of files that are listed together in the folder window (contiguously), select the first filename, hold the [Shift] key, and click on the last file you want to affect. This technique selects all the filenames between the first and last files. To select noncontiguous files, select the first file, hold the [Ctrl] key, and click on the other files you want to affect. To deselect a file, hold the [Ctrl] key and click on the selected file. Then use the keyboard or right-click on one of the selected files to complete your action with the shortcut menu.

Volume 14
Make the [Caps Lock] key sound off

How many times have you been typing along only to look up and notice that while you were typing, you accidentally hit the [Caps Lock] key and everything you've typed since then is in uppercase? Of course, to clean up this mess you have to press [Backspace] and then retype the words. Fortunately, we've discovered a feature that helps you avoid this situation by assigning a sound to the [Caps Lock] key so that it beeps when you press it. To use this feature, you must have the Accessibility Options installed. To assign a sound to the [Caps Lock] key, access Control Panel and double-click on the Accessibility Options icon. When the Accessibility Properties sheet appears, select the Use ToggleKeys check box in the ToggleKeys panel. Then, to enable the setting, click Apply and then click OK. Now whenever you press the [Caps Lock] key, you'll hear a high-pitched beep from your system's tiny built-in speaker. The beep will be louder when you turn [Caps Lock] on than when you turn it off.

Volume 15
Quickly open files with the Run dialog box

Have you ever wanted to open frequently accessed documents on your hard drive without launching Windows Explorer and sifting though the folder tree? If you often access files on your hard drive and want an easy way to open them, follow this simple process to quickly open the files with the Run dialog box.

First, open Windows Explorer and locate the files you'd like to quickly open. Create shortcuts for these files and then rename them with two- or three-word abbreviations. For instance, you could create a shortcut to your weekly budget report and name it WB for "weekly budget." Then move the shortcuts to the root of your C: drive.

Now, choose Start | Run, and in the Run dialog box type a back slash (\) followed by the name of the shortcut you just created (WB in our example). Click OK, and the file will immediately open on your screen. You can use this handy process to create abbreviated shortcuts for any file you open frequently and save yourself the hassle of searching for them in Windows Explorer.

Volume 16
Placing a drive icon on the desktop

If you frequently access files from a particular drive, you might find it useful to place an icon for that drive on your desktop. You can do so easily by creating a shortcut to the drive. Start by opening My Computer or Windows Explorer. Next, using the right mouse button, drag the target drive's icon to the desktop. When you drop the icon on the desktop, select the Create Shortcut(s) Here command from the shortcut menu. A new desktop shortcut to the drive appears. You'll now be able to easily access your drive by double-clicking on the new drive icon.