Setting Excel 2000 High-Contrast Cell Selection

Setting Excel 2000 High-Contrast Cell Selection

April 25, 2009

If you want to increase the contrast in selected cells:

  1. Start Regedit
  2. Go to HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 9.0 \ Excel \ Options
  3. Add a DWORD value call Options6
  4. Give it a value of 16
  5. Now when you select cells, they will be white on black.
Comparing Registries

Comparing Registries

April 25, 2009

While working with changes to your system, you might want to see what is changing in your Registry.
Since you can export it to a text file, the steps are fairly easy

  1. Start Regedit
  2. With the very top level select - My Computer, on the Toolbar select Registry / Export Registry File
  3. I usually save it to the root of the C: drive with the name before (you don't need to add an extension)
  4. Make the change to your system
  5. Go back to Regedit
  6. Press F5 to update it
  7. Export the Registry like step 2
  8. Name the file after and have it go in the same directory
  9. Open up a DOS window
  10. Go to the directory where the two exported files are
  11. Enter FC before.reg after.reg > diff.txt
  12. Then you can edit diff.txt with your favorite text editor.

Note: I do the last steps so often I have a simple batch file already set up.

Preparing to Move Hard Drive to Another Computer

Preparing to Move Hard Drive to Another Computer

April 25, 2009

To remove the devices from device manager when taking a HD from one computer to another,
simply:

  1. Run Regedit
  2. Go to HKEY_LOCAL_MACHINE\ and delete the Enum section
  3. This removes all of the hardware specific settings
Setting the Internet Explorer Home Page

Setting the Internet Explorer Home Page

April 25, 2009

If you want to set the home page used by Internet Explorer through the registry

  1. Start Regedit
  2. Go to HKey_Current_User \ Software \ Microsoft \ Internet Explorer \ Main
  3. Give the Start Page key the string value you wish set as homepage
Setting the Recycle Bin to Always Delete

Setting the Recycle Bin to Always Delete

April 25, 2009

You can set the recycle bin to always delete items (like holding down the shift key when dragging files to the recycle bin)

  1. Start Regedit
  2. Go to HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Explorer \ BitBucket
  3. Set the key NukeOnDelete to 1
Deleting Specific Registry Value

Deleting Specific Registry Value

April 25, 2009

In a previous tip, Automatically Deleting a Registry Key, it was mentioned how to remove an entire registry key.
If you want to simply remove a specific value within a key, use the syntax below:

[Registry Key]
"value"=-

For example:

REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run]
"MSConfig"=-

would delete the value MSCONFIG.

Changing the Location Of Special Folders

Changing the Location Of Special Folders

April 25, 2009

You can modify the registry to change the location of special folders like:

  • My Documents
  • Favorites
  • My Pictures
  • Personal
  1. Start Regedit
  2. Go to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders
  3. Double click on any locations you want to change and alter the path
  4. Logoff or restart for the changes to go into effect

Note: TweakUI from Microsoft will allow you to make these changes from a dialog box as well