Prevent Your Sheet from Scrolling

A while ago, we showed you how to copy data from one sheet to another. You simply hold down the Alt key while you drag the cell or cells to the appropriate sheet tab at the bottom of your screen. Excel automatically jumps to that sheet and continues to drag the data to its new home in the target sheet.

You can also use the Alt key while dragging data to prevent the sheet from scrolling. If you’ve ever had to drag data right to the edge of the worksheet, you already know that Excel can overreact and send you scrolling into oblivion. Holding down the Alt key allows you to move a block of data right to the edge without all that trouble.

Backup Outlook Express email

One of the most important things to create backup copies of, is your email messages. Here’s a short guide on how to do this if you use the Outlook Express mail client.

Copy the following folder:

C:\Documents and Settings\username\Local Settings\Application Data\Identities\{long sequence of numbers and letters}\Microsoft\Outlook Express

to a backup location (blank CD, Zip disk, backup HD, etc.).

———————————————————

To import the email back into OE:

1) Open Outlook Express
2) Click File – Import – Messages
3) Highlight Microsoft Outlook Express 6, and click Next
4) Choose Import mail from an OE6 store directory, and click OK
5) Browse to the location (folder) where you backed up your email and click OK.

That’s it. You’ve now imported all your old emails.

This is especially useful for clean installs of your operating system, or moving emails to a different machine.

Adding the URL History to the Start Menu

If you browse the web a lot and want fast access to recent sites you visited, you can put your history list on the Start Menu.

Right click on the Start button

Choose Explore

Right click on the right pane

Choose New / Folder

Name it URL History.{FF393560-C2A7-11CF-BFF4-444553540000}

The label isn’t critical. The period, braces and CLSID number are.

If you want to search for the string to enter:

Start Regedit

Search for URL History Folder

Right click the CLSID key

Choose Rename

Press Ctrl-C to Copy

In the Explorer window, press Ctrl-V to paste it in