How to change case in Word 2007?

• Press Home
• Click Aa
• Select your choice

 

How to see the formula of a cell in my spreadsheet?

There are two ways to display the formula than the results.
Point to the cell. Then . . .



1. Press Ctrl and ~ (Ctrl-Tilde)

OR

2. Tools | Options | View tab | Window Options section, check Formulas

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.

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.

How to hide non printable characters in Ms-Word?

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

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

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.

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)
  OR
  Select "Upload a video"
  (to upload a video).

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

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

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.

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.

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.

How to connect your lap top with Wi-Fi network?

Click on the Wifi Connection icon on bottom right of screen and you should see a window that indicates connection, strength and duration. Click on the Properties tab.

This window will show the type of networking card installed. Click on the Wireless Networks tab.

Once the Wireless Network Connection Properties window is open you will have two options depending on how you set up your laptop.

If you do not see any networks listed in Preferred or Available networks, you will have to manually add the SSID. Click on Add. You will have to enter the SSID and WEP key (if required). Click OK and you should then see the network you just added in the Available networks box.

If you see the correct SSID showing in the Available Networks, then you need to click on Configure in order to enter the WEP key if that is required.

In this window, enter the SSID for the Wi-Fi network you want to access. Make sure you do not have CAPS lock or NUM lock while entering the information.

If a Network key is required, click on "Data Encryption and then enter the Network key you have been provided with. Again make sure you do not have CAPS or NUM lock on. Click OK when entered. If you have entered the key incorrectly a message will pop up and you will need to re-enter the key.

Next go to Start - and where it says Connect To click on that and you should see choices. Click on Wireless Network Connection and it should work.

How to add a stranger to your wave?

So now you've got into wave. Welcome!
But "Now what?" . This is the question everyone asked, after entering into wave. Especially when you find nobody to wave with, what will you do?

Very simple. To meet people what you do? You go public to see and interact people. Same way you reach a public wave, jump into it, meet strangers, say hello and develop contacts.

Here is how you can do that.
with:public
This is the first search command every Wave newbie needs to know:
Type with:public in the inbox window.
Press search button.
Now you will see a sea of public wave.

Select any wave of your choic.
Click on the profile photo of anybody.
Ping them, chat with them  and add them

Thats all!

How to connect twitter to your Googlewave?

• Press "New Wave" button from the inbox.
  On the right a new wave window will open.
• Press the '+' sign next to your profile photo.
  This will open 'Add Participants' list box.
• Type Tweety in the search box.
  Tweety the Tweetbot will appear.
• Click it.
  Now, Tweety bot will be installed in your wave.
  It will ask you to log in to your twitter account, in a seperate window.
• Enter your Twitter username and password.
• You will see 'Access Granted' window.
  Now your twitter account is connected with Googlewave.
  That means you can tweet from your wave.
• Type your tweets in the "What are you Doing? text box.
  That's all!

How to add contacts in GoogleWave?

• Goto contacts window.
  Type the contact (Ex : r.selvakkumar@googlewave.com) in the search box.
• You will receive a message
  "r.selvakkumar@googlewave.com could not be found in your contacts".
• Now click the contact (r.selvakkumar@googlewave.com)
• That's all. A new contact is added.

To add contacts using emaily-wave@appspot.com robot, please visit here. This link will allow you only if you have googlewave account.

How to add contacts using the robot emaily-wave@appspot.com?

• Goto contacts window. Type "emaily-wave@appspot.com" in the search box.
• You will receive a message "emaily-wave@appspot.com" could not be found in your contacts".
• Now click the contact (emaily-wave@appspot.com)
• Now emaily-wave@appspot.com is added to your contact. emaily-wave@appspot.com is a robot. Using which you can add contacts from your own wave.
• Now click New wave button in inbox.
• Click the "+" button and add emaily-wave@appspot.com to the wave Immediately a text box will open.
• There you can type the contacts (Ex : r.selvakkumar@googlewave.com) and click the Add button. 

For reference click here.

How to block a contact in Gmail?

1. Click Contacts from the left side of Gmail.
2. Select the person you'd like to block.
3. Select Block from "Show in chat list" Box.

To unblock 
Just select Always or Auto from the "Show in chat list" Box.
OR
Type their name in the Search, add, or invite field at the top of your Chat list. Then, in the blue box that appears, hover over your contact's name and select Show in chat list.

How to remove videos from favourites in YouTube?

You can do it in 3 steps

1. Sign in to your YouTube account and click the link "Account" (top right corner of the page).
2. Under the "My Videos" section, click the "Favourites" link
3. Check the box next to the video you want to remove and click the "Remove Video" button.  
   

That's it. The video will be removed from your favorites.
Similar steps will remove videos from your playlists by clicking the"Playlists" link.