Home < Tips <
Welcome To Our PC Tips Page


The tips on this page came from PC Magazine and other computer tip services. Click on top to come back here from the tips. Use following links to view specific topics on this page.
  Learning Sites
  Web Browsing
  Microsoft Windows
  Microsoft Paint
  Microsoft Excel
  Microsoft Word
  Microsoft PowerPoint
  Microsoft Access

Learning Sites

This section contains some links to websites where you can learn a lot about computer usage. If any of the links do not work, pleas email us to let us know.

PC Magazine Tips
PC Magazine has a website where you can find tips on computer usage. You can sign up to receive tips by email on several computer related topics at the site. Click here to visit the site..

HP Learning Center
When one of the most important names in American business offers you the chance to learn something, it's an opportunity that shouldn't be missed -- especially when it is free. The HP (Hewlett-Packard) Learning Center has excellent online classes in a variety of interesting and timely business subjects.
At the HP Learning Center, you can find courses on topics such as wireless mobile solutions, intro to programming, advanced Adobe Photoshop, intro to MS Excel and many more. The tutorials are free and easy to follow. An experienced instructor leads each course, and lessons are available 24/7 for your convenience. Classes change monthly, so you will always find something new. Click here to visit the site.


Did you Know?
"Did you Know?" is a part of the Webopaedia web site. In this area, you'll find information on such topics as deleted files, CD drive speeds, how hard disks work, and much other computer information.
There is also an Internet section on this page that answers questions about the origin of the Internet, cookies, e-mail, and the World Wide Web (WWW). Click here to visit the site.


Learning about Computers
Since you're reading this, you probably already know a good bit about computers and the Internet. However, you may have friends that are new to computers--perhaps some who just got computers as Holiday gifts. These people might like to have you point them to a site that will help them learn how to work with their computers. The site we suggest for learning computers is the Sunshine Coast Home Computer User Guide. Click here to visit the site.

Return to Top.

Web Browsing

For tips on designing a web page visit our Web Design Tips page.

Export Your Favorites
Here's a tip if you use both Netscape Navigator and Internet Explorer: You don't need a special utility to convert bookmarks and cookies. Microsoft, surprisingly, has provided a simple utility for this purpose. In IE, choose File | Import and Export, and choose whether to import or export bookmarks or cookies. On the Destination page, choose to work with an application, and select your Navigator profile from the list. Click Next and Finish and you're done.
Even if you never use Navigator, you should try exporting your favorites from Internet Explorer. Just specify a destination filename rather than an application. The result is an HTML document containing links to all of your Favorites, organized by folder in outline form. When you open this document in IE, every link is available at once; there's no need to wade through levels of submenus.
Note that PC Magazine's SyncURLs utility does more than import and export bookmarks; it synchronizes them, making the two sets identical without duplication. You can find SyncURLs at www.pcmag.com/utilities.

Return to Top.

Control IE's Initial Size
You can force Internet Explorer to open in whatever size or position you want by going to Tools | Internet Options and entering the following line as the Address in the Homepage panel:
javascript:resizeTo(800,600);moveTo(0,0);document.location.href='http://www.yourhomepage.com'
Change the size and location to whatever values you prefer, and replace yourhomepage with your actual home page.
You can also control the initial size and position for Favorites menu items. Open the Favorites menu, right-click on an item, and choose Properties. In the URL field, enter the JavaScript command shown above, specify the size and position you want, replace the homepage with the item's original URL, and click on OK. IE will complain The protocol "javascript" does not have a registered program. Do you want to keep this target anyway? Click on Yes. Now this Favorite will open at the size and position you prefer.

Return to Top.

Conditional Comments In Internet Explorer
When I design a page, I like to use some of the features of Microsoft IE that other browsers do not support. This wouldn't be a problem if a visitor's browser simply didn't display anything it didn't understand, but sometimes the offending code makes a mess of the page for the visitor. Is there an easy way for me to hide the code when the visitor doesn't have the specified browser or version?
The easiest way is to use the conditional comment tag introduced with Internet Explorer 5.0. The conditional comment is an extension of HTML's standard comment tag, which takes the form <!-- place comment here -->. The conditional comment tag works precisely the same way, except for the inclusion of an if-endif block placed within the tag. The purpose of the if-endif block is to provide the browser with the conditions under which to display the code within the tag. Specifically, it instructs the browser to render the HTML within the if-endif block only if the conditional statement is true.
Two terms you'll see in relation to conditional comments are uplevel browser and downlevel browser. Uplevel browsers include IE versions 5.0 and higher. Any other browser is considered downlevel. Uplevel browsers recognize conditional comments and process them logically. Downlevel browsers do not recognize them, and that lack of recognition results in their working as Microsoft intended them.
Here's an example of a conditional comment. In this case, a visitor using IE 5.0 or higher will see the text inside the paragraph tags. Visitors with other browsers will see neither the sentence nor any other part of the conditional statement.
<!-- [if IE 5]>
<p>Good to see you've upgraded to IE 5.</p>
<![endif]-->
Note that the sentence will appear in all sub-versions of IE 5: 5.0, 5.1, or 5.5. You may restrict the condition to the subversion by specifying it, which looks like this:
<!--[if IE 5.5]>
<p>Good to see you've upgraded to IE version 5.5.</p>
<![endif]--> 
It's also possible to indicate a relative browser version�such as a browser version higher or lower than the one specified�by including an operator in the conditional statement. For example, the following condition would display the text if the visitor has not upgraded at least to IE 5.5:
<!--[if lt IE 5.5]>
<p>You need to upgrade to Internet
Explorer 5.5 or 6 to read this.
<![endif]-->
The possible operators are: lt for less than (in other words, prior to); gt for greater than; lte for less than or equal to; and gte for greater than or equal to. In addition, you can use the not operator�in the form of !�to specify code to display if the browser is not a specific version. The following example uses the not operator to inform visitors that they will only be able to view the text if they have IE 5.5:
<![if !IE 5.5]>
<p>Only users of Internet Explorer
5.5 will be able to see this text.</p>
<![endif]>
Note the difference between this code and the preceding examples. Here, the double hyphens do not follow the <! tag or the [endif]comment. A conditional comment without the double hyphens is called a downlevel-revealed comment; these comments appear in downlevel browsers, whereas comments that include the hyphens do not. Downlevel-revealed comments let you make a comment to visitors who do not use Internet Explorer at all, or who use IE versions earlier than 5.0.
Conditional comments work because IE 5.x has been programmed to process comment tags differently from other browsers. The uplevel browsers recognize the if-endif block, but all other browsers do not. If the comment tag starts and ends with the double hyphen, downlevel browsers will recognize it as a normal HTML comment and not display any of it, including the if-endif block or any contents inside that block; uplevel browsers, however, will render the if-endif block as instructed. If the comment does not contain the double hyphens, then downlevel browsers will ignore the comment tags as invalid but will render the HTML inside those tags. Uplevel browsers, however, will ignore them completely.
Although we've used simple paragraph containers in these examples, you are by no means restricted to these. You can include anything you wish inside the if-endif block, including scripts, graphics, specific IE features (such as marquees), and so on.

Return to Top.

Printed Headers and Footers in IE
When I print Web pages at home, Page X of Y appears at the top of each page. At the office, pages print with the title, Page X of Y, the site's Web address, and the date�all across the top. How can I change these settings?
From Internet Explorer's File menu, select Page Setup. In the resulting dialog box, you can enter codes that control what appears in the header and footer for a printed page.
To see a complete list of codes, click the question-mark icon in the dialog's title bar and then click on the header or footer box. Every code consists of an ampersand (&) and a letter. For example, &u represents the current URL. Noncode text, like Page and of in Page &p of &P, gets passed through unchanged. A &b code divides the text into two parts, one left-aligned and the other right-aligned. Two &b codes divide the text into left-aligned, centered, and right-aligned portions. You can experiment with the codes, then choose File | Print Preview to see the effect of your changes.

Return to Top.

Microsoft Windows

The Applog Folder
In Windows 98 and Windows Me, the Task Monitor tracks which programs are launched and how they load from disk, and it records the info in the Applog folder. The Defrag utility then uses this info to provide special optimization for the program files you use most often. Rather than rearranging the clusters of these files in sequential order, Defrag rearranges them in the order they're loaded when the program launches.
This specialized processing reduces the time required to launch certain programs, but you may prefer to trade that speed for disk space. You're perfectly free to delete the entire contents of this folder, but Task Monitor will start refilling the folder right away. To prevent this, you need to tweak a Registry setting. Launch Regedit from the Start menu's Run dialog and navigate to HKEY_LOCAL_MACHINE\ SOFTWARE\Microsoft\Windows\
CurrentVersion\Applets\Defrag\AppStartParams. In the right-hand pane, find or create a DWORD value named UseProfile, and set its value to 0. For more information, see the Microsoft TechNet article.

Return to Top.

Alternative to My Documents
I like to save all my attachments in the Attachments folder located on our server, not on my hard drive. But whenever I use the Save as... command in Outlook, it defaults to My Documents and I have to waste time navigating to the Attachments folder. Is there a way to change Outlook's default behavior?
My Documents is a system-defined folder, and many applications insist on using it as the default for saving a new file. Rather than fighting this behavior, you can create an easy link from My Documents to the folder of your choice. Open My Documents, right-click within it, and choose New | Shortcut from the pop-up menu. In the Create Shortcut dialog, enter the full pathname of the folder you'd rather use. Give the shortcut whatever name you wish. Now, when My Documents appears as the destination for saving a file, double-click this shortcut to reach the folder you prefer. You can put several folder shortcuts within My Documents for different purposes.

Return to Top.

Environment Variables in 2000/XP
Windows 2000 and XP include most of the commands you're familiar with from DOS and Windows 9x. But when Command Extensions are enabled�as they are by default�many of these commands gain additional features. The DATE /T switch itself (which causes DATE to return without waiting for input) is one such added feature.
Fortunately, you don't need to do a single thing to get the current date into an environment variable. When Command Extensions are enabled, your batch files can access a number of dynamic environment variables that return various system values. Specifically, the %DATE% and %TIME% variables return the current date and time. You may also find uses for %CD% (returns the current directory), %ERRORLEVEL% (returns the exit code of the most recent command) and %RANDOM% (returns a random number from 0 through 32,767). Type SET /? at a command prompt for more information.

Return to Top.

Clear Out Old Files
Use Disk Cleanup to clear out temp-file directories, caches, the Recycle Bin, etc. From the Start Menu, select Programs, Accessories, System Tools, then Disk Cleanup. Choose the locations to be cleared out, then click on OK.
Return to Top.

Deal with Unwanted Online Services
To remove unwanted online service options that clutter your hard drive, select Settings from the Start menu, Control Panel, then double-click the Add/Remove Programs icon. Click the Windows Setup tab, scroll down to Online Services, then double-click it. Deselect the boxes for the online services you don't use, then click OK.
Return to Top.

Limit The Visual Frills in XP
Windows XP may be more attractive than previous versions, but its good looks come at a cost. Extras such as transparent mouse shadows, font smoothing, and menu effects add little more than aesthetic value while using up valuable system resources.
To disable the effects you can live without (an idea we especially recommend if you're running Windows XP on an older Pentium II system), go to the Control Panel, open the System applet, select the Advanced tab, and click on Settings in the Performance section. You can disable unnecessary items on the Visual Effects tab.

Return to Top.

Locked Folders in Windows
To create a locked folder in Microsoft Windows, launch Windows Explorer and navigate to the directory one level above the folder you want to lock. Click Run... in the Start menu, type the word command, and press Enter. A command window will open in the folder displayed by Explorer. Suppose the folder's name is Private; enter the command ren private privateX, but instead of typing X, hold down the Alt key and type 255. To unlock the folder from the command prompt, enter ren privateX private (again replacing X with Alt-255). When the folder is locked, Windows won't be able to open it, though it will be visible as Private.
They say everything old is new again. This tip was useful even under ancient DOS versions, and it still works in Windows 95, 98, and Me but not in Windows 2000 and XP. If you attempt to open the locked folder in Explorer, you'll get a message like {name} is not accessible. The folder was moved or removed. If you attempt to rename it, you'll get a different message, like Cannot rename file: File system error (1026).
Note that to enter ASCII character 255 you must hold down the Alt key, tap the numbers 2-5-5 on the numeric keypad, and then release the Alt key. You can't use the top-row number keys for this procedure.

Return to Top.

Remove Hidden Windows Components
If you've been looking for a way to remove Windows Messenger or other Windows components that don't show in the Add or Remove Programs applet, here's the secret. Windows keeps a list of components in a file called Sysoc.inf in C:\Windows\ Inf. Some of the entries under the [Components] heading, among them the line for Messenger, include the word hide. To make them visible to the Add or Remove Programs applet so that you can remove them, you have to delete the instruction to hide them.
First, make sure that Windows Explorer is set to display hidden files: In Windows Explorer, choose Tools | Folder Options, then the View tab, and set the option to Show hidden files and folders. Also remove the check from the check box labeled Hide protected operating system files (Recommended).
After clicking OK, you can navigate to the C:\Windows\Inf folder. Open Sysoc.inf in Notepad and find the line msmsgs=msgrocm.dll,OcEntry,msmsgs.inf,hide,7. Delete the word hide, being careful to leave the commas. Save and close the file.
Next, go to the Control Panel, choose Add or Remove Programs, and when the applet opens, choose Add/Remove Windows Components. Windows Messenger should now appear in the list. You can make other hidden components appear in the applet by following the same steps.

Return to Top.

Fast New Folders
Is there some way of significantly reducing the time required for the File | New menu in Windows Explorer to come up? Often I simply want to create a series of new folders. I have to wait about 10 seconds for each, which is very annoying!
Your best bet is to bypass the New menu completely. Select Folder Options from Explorer's Tools menu, click the File types tab, choose File Folder from the list, and click the Edit... button (the Advanced button in Windows 2000 or Windows ME). In the Edit File Type dialog box, click the New... button. Enter New Subfolder in the Action box, and in the Application box enter this line:

command.com /c md "%1\New Folder"

Click OK, then click New... again and create an action named Five New Subfolders with this command:

command.com /c for %%v IN (1 2 3 4 5) DO md "%1\New Folder (%%v)"

Click OK to close all the option windows.

If you're running Windows 2000 or Windows NT4, simply replace command.com with cmd.exe in both of the commands. Be especially careful when entering the commands in Windows 2000, as the default permissions will prevent you from editing or removing the new commands using the Edit File Type dialog. If you need to change or remove these items in Windows 2000, you'll have to use the Registry Editor. Now when you right-click a folder icon, you can choose one of the new commands directly from the pop-up menu. You'll have to rename the created folders right away, but that's still a lot faster than waiting for File | New to come up.

Return to Top.

Simple XP File Sharing
If you're familiar with network file sharing, you may get a shock when you upgrade to Windows XP. The sharing dialog is completely different and doesn't allow nearly as much control. For example, it won't let you set up a folder so that only you can access it remotely. You can't password-protect folders the way you can in Windows 9x versions, and you can't set networkwide, per-user permissions as you can in Win 2000.
Microsoft calls this feature simple file sharing, and Windows XP Home users are stuck with it. In Windows XP Professional, however, you can turn off the feature. To do this, choose Folder Options from the Tools menu in Windows Explorer. Click the View tab. Scroll down to the box titled Use simple file sharing (Recommended) and uncheck it. Click OK. Now when you right-click a folder and choose Sharing and Security, the Sharing tab will be just like the one in Windows 2000.

Return to Top.

Delete Your Empty Folders
You don't need a program to delete any folders that are empty or that contain only empty subfolders you can do this at the command prompt. Open a command prompt window and navigate to the root folder of the drive in question. Enter this command:

DIR /AD/B/S | SORT /R > EMPTIES.BAT

The file EMPTIES.BAT now contains a list of all folders on your hard drive in reverse order. Use Word or another editor to put the filenames in quotes and add the prefix RD (with a space after RD) to every line in the file. In Word, you can do this easily by using Find and Replace to search for ^p (which represents the paragraph mark) and replace it with "^pRD " (quote, p, R, D, space quote), then hand-correct the first and last lines of the file if necessary. Save the modified EMPTIES .BAT file and exit your editor. Then simply launch the batch file. It will attempt the RD (remove directory) command on each folder, but the command will fail for any folder that is not empty.
How does it work? For the DIR command, the switch /AD means select files whose attributes include the Directory attribute (in other words, folders). The /B switch means give a "bare" listing�just the filename�and /S means look in subfolders, too (which, incidentally, modifies /B, so it shows the full pathname). The output is piped (|) as input to the SORT command. Not surprisingly, the switch /R means sort in reverse. Finally, the output of SORT is redirected (>) into the file EMPTIES.BAT. Because we're sorting in reverse, every folder's subfolders precede it in the list. If they are empty, then by the time the parent folder is processed, it too will be empty. You'd be surprised at what you can do with simple commands!

Return to Top.

Microsoft Paint

Saving Paint Files as GIFs or JPEGs
My Windows 98 SE system at home won't let me save a Paint file in either GIF or JPEG format, both of which are available on my office PC running the same version of the OS. I found a reference that said I need to install the GIF/JPEG filter. What is that, and where can I download it?
The filter in question is installed along with Microsoft Office, but strangely, Paint will not realize this until you alert it to the filter's presence by opening a GIF or JPEG file.
To ensure the filter is installed, launch Add/Remove Programs from the Control Panel. Select Microsoft Office and choose Add/Remove; then choose Add or Remove Features. Expand the Converters and Filters selection. Click on Graphic Filters and select Run all from my Computer. Finally, click on Update Now.
Now launch Paint, click on Open, and select a GIF or JPEG image (you'll have to set Files of type to All files). Once you've done that, you should also be able to save files in either of the two formats.

Return to Top.

Microsoft Excel

Adjust Column Widths When Pasting
When you copy a range of data (several columns), you can't automatically paste the column widths that accommodate your data. You must first select the data you want to copy and press Ctrl+C. Click a destination cell, and press Ctrl+V to paste the data to the new range. Right-click the new range and choose Paste Special. Select the Column Widths option in the Paste section, then click OK. When you return to your worksheet, the columns in the new range will be the same width as the columns in the original range.
Return to Top.

Print Discontinuous Portions
To print discontinuous portions of a worksheet, select Page Break View from the View menu, press Ctrl, then select the desired parts. From the File menu, choose Print Area, Set Print Area.
Return to Top.

Mystery Function Calculates Age in Excel
I need an equation for calculating the number of years between today's date and a person's date of birth. What formula can I use to calculate age based on date of birth?
Supposing the person's date of birth is in cell A1, this formula will calculate the age: =DATEDIF(A1, TODAY(), "y"). Be sure to format the age cell as a number, not as a date. Surprisingly, unless you're running Excel 2000, you won't find this function in Help. Microsoft has supplied it in every version since Excel 5.0, but only documented it in Excel 2000 (an oversight?). DATEDIF is not mentioned in the Microsoft Knowledge Base, except for an article that lists it as a function not available in the Office Spreadsheet component. A search of http://msdn.microsoft.com for DATEDIF turns up exactly nothing on this mystery function.
DATEDIF's first date argument must be the earlier of the two dates. You can specify m rather than y to get the number of whole months between the dates or d to get the number of days. For a detailed (if unofficial) listing of the DATEDIF function's syntax, visit www.cpearson.com/excel/datedif.htm.

Return to Top.

Highlight the Current Row
How can I make Excel highlight the entire row containing the cell I click on, so I can always clearly see which is the current row?
There's no such feature built into Excel, but you can achieve the desired result using a macro. Two Microsoft Knowledge Base articles on the topic, Q172515 and Q213193, for Excel 97 and 2000, respectively, give the procedure to follow and the code for making the active row bold. The instructions in either article work with Excel 2002.
You'll need to create the macro for each sheet you wish to use it with. Be aware that because the macro uses the SelectionChange event, some features will be disabled on your sheet�Copy, for example. Also note that closing the file does not remove the highlighting. You can overcome this by clicking on the bolded row when you reopen the file.
You can adapt the macro to highlight the current column or both the row and the column. You can also modify the macro to use italics in place of bold. Do this if your worksheet includes any bold formatting that will be undone by the macro.
We've provided a sample file that contains the code and instructions for using the macro. Download Highlights.xls at the following link: Highlights.xls

Return to Top.

Two-Way Lookup in Excel
I want to use Microsoft Excel to look up a value in a two-dimensional table, looking down the row headers for a match to the value in an input cell and across the column headers for another match, retrieving the value at the intersection of the designated row and column. Picture column A filled with hotel names and row 1 filled with room types. The rest of the table is filled with prices. I want to retrieve the price knowing the hotel and type of room. I tried using HLOOKUP and VLOOKUP but couldn't make them work.
HLOOKUP and VLOOKUP search the first row or column in a range and return the corresponding value from another row or column. But they don't give any information about the location of the found value. You can't, for example, use HLOOKUP to determine the column for the desired data and then use VLOOKUP to search that column.
The key is to use the MATCH function, which returns the position of an item within an array. In this case, it will be the position of the desired column header in the top row. We can pass this value as the third argument to VLOOKUP�the one that defines which column's data should be returned. Figure 1 shows a simple worksheet demonstrating this function. Cells A2 to A13 contain months of the year, B1 to F1 contain years, and B2 to F13 contain some random dollar values. You enter the desired month and year in cells B15 and B16, and the corresponding value is retrieved by this function:
=VLOOKUP(B15,A2:H13,MATCH(B16,A1:H1),FALSE)
This tells Excel to find the month value matching cell B15 and return the value found in the same row at the column corresponding to the year value from cell B16. The FALSE argument at the end tells VLOOKUP to return only a precise match.

Return to Top.

Microsoft Word

Make Word's Default Paste Unformatted
I copy and paste text with a variety of formatting styles. I almost always want the pasted text to be in the same format as the target document. To do this, I must click Edit | Paste Special, highlight Unformatted Text, and click OK. How can I make Unformatted Text the default paste option?
Copy some text into the Clipboard. Select Tools | Macro | Record New Macro. Click the Keyboard button to bring up the Customize Keyboard dialog. Associate the macro with the Ctrl-V key combination, click Assign, and click Close. Record a macro that does nothing but invoke Edit | Paste Special, selecting Unformatted text. Click the Stop button in the little macro-recording box. That's it. Ctrl-V now runs your macro. You can still select Edit | Paste if you want to paste with formatting.

Return to Top.

Microsoft Word's Extend Mode
How can you precisely highlight large sections of text in Microsoft Word? When you try to select a block of text that spans multiple pages in a large document, the pages start to roll at dizzying speed. Stopping where you want your highlight to end is nearly impossible. If you overshoot and try to go back, the pages scroll just as fast in the opposite direction. How can you highlight large passages accurately?
Click where you want to start highlighting and press the F8 key to enter Extend Mode. Now the arrow keys and other navigation keys extend the selection. Press F8 repeatedly to enlarge the selection to the current word, sentence, paragraph, section, or document (Shift-F8 reverses the progression).
If you type a character, the selection extends to the next instance of that character�handy for jumping to the end of a parenthetical phrase. Perform a search and the selection will extend to include the found text. Click somewhere in the document and the highlight will extend or shrink to that point. Finally, press Ctrl-Shift-F8, then use the arrow keys or mouse to select a rectangular block of text. Extend Mode ends when you cut, copy, or format the selection, or press Esc.

Return to Top.

Word as Spyware
I recently heard that hackers can steal information from your hard drive using Microsoft Word. Is this true?
The Document Collaboration Spyware exploit, as it is being called, filches files via Microsoft Word fields.
Fields let you insert self-updating information into documents. For example, select Insert | Page Numbers... from the Word menu and you're actually inserting a self-updating Page field. A field called IncludeText can insert entire Word documents or Excel worksheets. Two features of fields make them a potential problem: They update automatically under some conditions, and there are a number of ways to hide them.
Suppose you received a document for comment, edited it, and sent it back. If the document contained a hidden IncludeText field that specified the locations and names of files your system can access, those files could have been sent back as part of the original file.
For this to work, an interloper has to know the names of the files and their locations, but if the person works with you, the possibility is not too far-fetched. This trick lets someone without access to certain network folders use your access to get files stored in those folders.
There are some steps you can take to minimize your vulnerability. You can use Edit | Links to see if there's a list of links in a file. You can also search manually for fields and examine each one. Choose Tools | Options | View. Make sure that the Field codes box is checked and that Field shading is set to Always, which will help you spot the fields. Unfortunately, this can be a chore. When Word is set to show field codes, you can use Edit | Find to search for IncludeText and similar fields, but there are several, and you have to search for each separately.
As of this writing, there is at least one tool that can help: Bill Coan's Hidden File Detector, which you can download from www.wordsite.com/HiddenFileDetector.html or from www.woodyswatch.com/util/sniff/. Hidden File Detector adds a new item, Detect Hidden Files, to the Tools menu. Choose this item and you'll see a dialog box that lists any documents inserted into the file by a potential spyware field. You can then select each document to see a short description of the suspect field. Clicking on the Go to button will take you directly to the highlighted field.

Return to Top.

Recover a Document if Word Crashes
Go to the Tools menu, then select Options and click the File Locations tab. Empty space next to AutoRecover files means your data is lost. If there is a location, go there and open the document.
Return to Top.

Microsoft PowerPoint

Create a PowerPoint Design Template
To create a design template for a new presentation, choose Master from the View menu, then select Slide Master. (Now that you're in Master Layout, every element you create will appear on every slide of your presentation.) Click on the Common Tasks button on the toolbar, then select New Title Master. Format the slide as desired, then choose Close on the Master toolbar to open a new presentation with the newly created slide. Choose Save from the File menu, then Save As Presentation Template. Name your template, then select Apply Design from the Format menu.
Check out more Microsoft PowerPoint tips.

Return to Top.

Microsoft Access

Working With Data Blocks
When working in Datasheet view, you can select records or you can select a data block (a data block is a rectangular selection of fields that doesn't consist of complete records). To create a data block, click one corner of the block, hold down the Shift key, and then click the opposite corner. Doing so will select all the fields horizontally and vertically between both fields; it won't select any fields beyond those two fields. A data block can be as small as just two fields in one record or one field in two records. However, it must consist of more than one field in one record. A single field doesn't constitute a data block; there must be more than one selected field. There's one limitation when working with a data block. Although you can copy that block of data to the Clipboard, you can't delete it from the table. If you check the Cut command on the Edit menu while a data block is selected, you'll notice this command is disabled.
Return to Top.

Avoid Bound Control Errors
When you update a bound control, Access opens the data source internally. You won't see it happen, of course, but the table opens just the same. If you don't close that table, you could create an error. The next time you try to modify the table, Access will return an error because the table is already opened and locked. The problem arises if you force Access to update a field. For instance, you might run a quick VBA statement similar to Me!fieldname = "newentry" to change a particular field. Unfortunately, that statement alone would open and lock your data source. If you must update a field in this way, remember to unlock the table afterward. The easiest way to do so is simply to move to the next record using a statement in the form DoCmd.GoToRecord acDataForm, Me.fieldname, acNext.
Return to Top.

Clean up Database Using the Table Analyzer
You can save memory, space and processing time by using the Table Analyzer. In order to analyze your data, select Tools, Analyze, Table. Use the Table Analyzer Wizard to take redundant information in tables and break it out. For instance, if you have one field in your database that has nothing but a list of names with a fair amount of repetition between records, the Table Analyzer converts that field into a reference field that points to an auxiliary table that holds the names, therefore eliminating redundancy.
Return to Top.

Display a String in a Numeric Null Field
To leave a blank cell in a table when the field is a Numeric value, you simply replace the default value of 0 with the Null value. You can also display more information if you're willing to assign a format to the field. For example, if you're entering values in a field and you want to display the string "NA" when the record has no corresponding value. To do so, you might use a simple format in the form #;;;"NA" The # placeholder will accept values or no entry. However, the last component of that format--"NA"--will display that string when you leave the cell blank instead of entering a value. To assign a format to a field, open the table in Design view and select the appropriate field row. Then, select the Format property field and enter the format. When you close the table or return to Datasheet view, be sure to save your changes. For the record, this format will also display the string "NA" in a text field
Return to Top.

Hosted by www.Geocities.ws

1