Saturday, January 24, 2009

Tip # 47 Opening multiple windows

One of the most frustrating problems for Excel users is viewing all the information they need, especially because it often lives in different worksheets. Here you can know about this simple way to view multiple sheets, and you will love forever.

1. Click on the tab of the worksheet you want to view.
2. Choose New Window from the Window menu.
3. Repeat this process for each of the worksheets you want to display. (Excel opens each sheet in a window that sits on top of the previous one.)
4. To see them all at one time, choose Arrange from the Window menu.
5. Select Tiled, Horizontal, or Vertical.
6. Select the Windows Of Active Workbook check box.
7. Click OK.

Saturday, January 10, 2009

Tip # 46 User-level prevention is a magic cure

Every support pro knows that most of their problems could be avoided if their users would just follow a few simple, common sense precautions. If you keep getting calls on corrupted Excel documents, pass around this list of Microsoft-endorsed tips to help users keep their data safe and make your days a little less stressful:

• Move radios, fax machines, televisions, stereos, speakers, and other sources of electromagnetic radiation away from computers.

• If your users are still using floppies, make sure they are not putting them on top of their monitors.

• Regularly run Norton AntiVirus or another utility to scan for viruses.

• Store floppy disks in a disk storage container.

• Don't be a slob—prevent dust from building up around your computer.

• And, most important, exit Windows before restarting or shutting down a client system.

Saturday, January 3, 2009

Tip # 45 Detect And Repair

Microsoft Office 2000 programs, including Excel, contain a command line called Detect And Repair, which checks and fixes problems with Office program files, DLLs, and registry settings. (This utility does not affect worksheets or other document files.)
Detect And Repair, which you access as a command line option of the Setup utility, performs the following actions:
• Reinstalls Office .exe and .dll files if missing, out-of-date, or corrupt
• Reinstalls all Windows Installer shortcuts, overwriting any existing shortcuts
• Rewrites all required local machine registry values
• Rewrites all required user registry values
You can run Detect And Repair from within Office, but that won't do much good if a serious error is preventing your user from even launching an Office application. Fortunately, you can run the utility from the Run dialog box with the following entry:
drive:\setup.exe /focums install.msi