Friday, December 3, 2010

If I double click on a folder search window opens. How to correct this?

Quick Fix
  • Click Start->Run 
  • Type regsvr32 /i shell32.dll
If this doesn't work try the following

  1. Start -> Run
  2. Type Regedit
  3. Navigate to
    HKEY_CLASSES_ROOT \ Directory \ shell
    In the right-pane, locate and click the (Default) value
    Select Edit menu
    Click Modify
    Locate Value data box
    Type the word none
    Click OK
  4. Navigate to HKEY_CLASSES_ROOT \ Drive \ shell
    In the right-pane, locate and click the (Default) value
    Select Edit menu
    Click Modify
    Locate Value data box
    Type the word none
    Click OK
  5. Exit Registry Editor.

Wednesday, November 17, 2010

How to copy a formula from one cell to many in Excel?

Example 1
Assume you have a formula =sum(A8+A9)
To copy this formula, do the following!

Change the formula as =sum($A$8 + $A$9)
Now copy and paste. 

Example 2 
Assume you have a formula =B3 * 5 / SUM(B4:B7)
To copy this formula, do the following!

Change the formula as =$B$3 * 5 / SUM($B$4:$B$7)
Then copy and paste. 

Example 3
Assume you have a formula =COUNTIF(C2:C4,A2)
To copy this formula, do the following!

Change the formula as =COUNTIF($C$2:$C$4,$A$2)
Then copy and paste.

Tuesday, November 16, 2010

How to hide non printable characters in Ms-Word?

Press Ctrl + Shift + 8 to show or hide Non printable characters!

Press the number 8 key with * symbol.
This will almost work in all versions of MS-Word.

Thursday, September 23, 2010

How to stop Autoplay?

1. Start ->Run
2. Type gpedit.msc
3. Computer Configuration --> Administrative Templates --> System
4. Find Turn off autoplay
5. Double Click
6. Select Disabled

To start Autoplay, do the same and in step 6 select Enabled.

Wednesday, August 25, 2010

How can I post a video response in YouTube?

  • Below the video, you will find a box with  "Video responses".
  • Click the box to get the link "Post a video response". 
  • Click the link (A gray menu bar will appear)
  • Select "Choose a video"
    (to select a video you have already uploaded)
    Select "Upload a video"
    (to upload a video).

Wednesday, July 7, 2010

My Nokia N70 is not showing contacts from my Sim card. Please help!

You should copy all the contacts from your Sim to N70 phone.

1. Select Sim directory
Contacts > Options > SIM Contacts > SIM Directory.

2. Copy all your SIM contacts to the phone memory, 
Options > Mark/Unmark > Mark all, then Options > Copy to Contacts.

Tuesday, May 18, 2010

I am using XP and can't connect with Wi-Fi. My friend say WZC is missing. Any solution?

  1. Start->Run
  2. Type regedit
  4. Click SYSTEM
  5. Click CurrentControlSet
  6. Click Services
  7. Click WZCSVC
  8. Add a DWORD entry named "Start"
  9. Change value as "2"

Saturday, May 15, 2010

Face Book : How to stop video postings by others in my page?

  1. Acctounts -> Application Settings ->
  2. Select Allowed to Post from Show list box
  3. Click Edit settings of Video (To open Edit Video Settings window)
  4. Click Additional settings -> Uncheck publish content to my wall

How to see the Hidden files of a folder?

Open the folder.
Tool -> Folder Options -> View ->
(In advanced settigns box) Hidden files and folders ->
select  show hidden files and folders -> OK
If you are using windows 7
Open the folder 
Click the Organize menu entry and then click the  Folder and search options
View -> Show hidden files, folders and drives

Saturday, May 1, 2010

In facebook, how to hide 'Recent Activity' from others?

It's so simple!

Application settings -> Ads and Pages -> Edit Settings -> Additional Permissions.

Uncheck the box next to “Publish recent activity”

Note: You can find Ads and Pages under Notifications Tab

Wednesday, April 28, 2010

How to create your own Sleep button in XP?

  1. Right click on the desktop.
  2. Select New -> Shortcut.
  3. In the text box type rundll32.exe powrprof.dll,SetSuspendState
  4. Click Next.
  5. Type Sleep in the text box.
  6. Click Finish.

Saturday, April 24, 2010

How to stop the over heating of my laptop?

Tip #1
Clean the dust blocking fan inlet or outlet (usually at the bottom)

Tip #2
Check and clean the dust from CPU fan

Tip #3
Try  Laptop cooling stand

Tip #4
Stop the unnecessary programs running in the background
Start->run->type "msconfig" ->OK
A window will open.
In the window goto startup tab and disable the unnecessary progrms.

Tip #5
Turn On Power Saver Mode
Invoke the  'power saver'. The power saving modes usually turn down the display brightness and spin down the hard drives if the machine is idle for a fixed period of time.

Tips #6
Remove the unwanted USB Devices
USB ports are a well-known heat generator.  Plug out the unwanted USB devices and your machine will start to cool down.

Tips #7
Make sure to use in hard surface
If you have your laptop placed on a soft surface (e.g. bed or carpet) the air circulation will be blocked and will cause extensive heat.

Tuesday, March 30, 2010

How to change drive letters of my PC?

  • Start 
  • Control Panel 
  • Administrative Tools
  • Computer Management
  • Disk Management
  • Right-click the drive(name you want to change)
    (click in the white area just below the word "Volume")
  • select "change drive letter and paths."
    Now you can add / remove / change drive letters and paths.

Friday, March 12, 2010

How to remove junk files from my computer?

There are few windows utilities available. But I'd suggest a free Disk cleaner, which is free and effective.
Usually junk files appear as a result of program's incomplete uninstalls, or Temporary Internet Files. At some point, these files use a considerable amount of space on your drives.

Wise Disk Cleaner, with its intuitive and easy to use interface, helps you quickly wipe out all the junk files. Using the program is indeed easy. It also works fast when both scanning for files and deleting files.

Click here to download Wise Disk Cleaner

Monday, March 8, 2010