Excel 2003 Zebra Colored Rows

In MS Excel 2003

1. Select the entire table.
2. Goto Format – Conditional formatting
3. Select ‘Formula Is’ ption in 1st Dropdown
4. Enter Formula =Mod(Row(),2)=0
5. Select the color you want to fill every alternate row and click ok

Source: http://msexcelraj.wordpress.com/2007/11/11/excel-format-table-with-zebra-stripes/

Tortoise SVN Moving files and folders

If you want to do a simple in-place rename of a file or folder, use Context Menu → Rename... Enter the new name for the item and you're done.

If you want to move files around inside your working copy, perhaps to a different sub-folder, use the right-mouse drag-and-drop handler:

1. select the files or directories you want to move

2. right-drag them to the new location inside the working copy

3. release the right mouse button

4. in the popup menu select Context Menu → SVN Move versioned files here

http://tortoisesvn.net/docs/release/TortoiseSVN_en/tsvn-dug-rename.html

How to Convert ALL CAPS to Lowercase Letters

I will assume you are using Microsoft Word. I am not sure if this works in other word processing programs or not. Highlight the all caps text you would like to convert to lowercase letters. Next, simply press Shift+F3.

Source: http://www.associatedcontent.com/article/65773/how_to_convert_all_caps_to_lowercase.html

HP solution center popup

Disabling This Obnoxious Popup

In order to disable this utility, we’ll have to run the configuration tool from within the directory. After doing a little research, I found the directory the app is actually running from, which is this one:

C:\Program Files\HP\Digital Imaging\Product Assistant\bin

Once you get into this directory, launch hprbui.exe, which is the Hewlett-Packard Product Assistant UI.

http://www.howtogeek.com/howto/windows-vista/turn-off-the-obnoxious-hp-driver-uac-popup-update-check-in-vista/

Sony Ericsson PC Suite Contacts export

Goto: C:\Users\Username\AppData\Local\Sony Ericsson\Sony Ericsson PC Suite\Sync\SyncML
plug in and sync phone
copy the file Contacts.txt elsewhere
rename to .vcf

Source: http://alfred.co.in/how-to/how-to-sync-sony-ericsson-phone-contacts-with-windows-contacts/