Thursday, June 28, 2007

Disable balloon help(WinXP)

To disable balloon pop-ups, click Start > Run, type regedit and hit Enter. In the left column, drill down to HKEY_CURRENT_ USER > Software > Microsoft > Windows > Current Version > Explorer > Advanced. Right-click anywhere in the right column, select New > DWORD Value, and rename it EnableBalloonTips. Double-click this new entry, and give it a hexadecimal value of 0. Then close the Registry Editor and restart your computer. Just be careful; Registry mistakes are irreversible.

Synchronise Windows' clock

If your Windows clock has a habit of losing track of time, synchronise it with an Internet time server. Double-click the time located on your taskbar. Select the Internet Time tab and check "Automatically synchronise with an Internet time server." Don't bet your next job interview on it, though -- the time's synchronised only once a week. If you want to synchronise immediately, click Update Now.

Wednesday, June 13, 2007

Keyborad Shortcuts For MS Excel

General

F2 Key Edit current Cell

F5 Key Goto

F7 Key Spell Check

F12 Key Save file as

CTRL+A Select entire worksheet.

CTRL+B Toggle Bold Text.

CTRL+C Copies the item or items selected to the Clipboard.

CTRL+F Displays the Find dialog box.

CTRL+H Displays the Replace dialog box.

CTRL+I Toggles Italic Text.

CTRL+N New File.

CTRL+O Open File.

CTRL+P Print.

CTRL+S Save File.

CTRL+U Toggles Underlined Text.

CTRL+V Paste the contents of the clipboard.

CTRL+X Cut the selected item.

CTRL+Y Redo the last undone action

CTRL+Z Undoes the last action.

CTRL+1 Displays Format Cells Dialogue Box

CTRL+5 Toggles Strikethrough Text


Formulas

ALT+ = Autosum

ALT+ F8 Macros

CTRL+ ; Insert Current Date

CTRL+ : Insert Current Time



Movement

Left Arrow One Cell Left (also SHIFT+TAB)

Right Arrow One Cell Right (also TAB)

Up Arrow One Cell Up

Down Arrow One Cell Down

CTRL+left Arrow Go to End of Column

CTRL+Home Go to Top of Worksheet (A1)

CTRL+End Go to End of Worksheet

CTRL+PAGE-DOWN Go to Next Worksheet



Cell Selection

CTRL+Spacebar Select the entire Column

SHIFT+Spacebar Select the entire Row

CTRL+A Select Entire Worksheet

SHIFT+Left Cursor Select all cells to the left of the active one

SHIFT+Right Cursor Select all cells to the right of the active one

Keyboard Shortcuts For Windows XP

Windows Logo

Display or hide the Start menu

Windows Logo+BREAK

Display the System Properties dialog box

Windows Logo+D

Display the desktop

Windows Logo+M

Minimize all of the windows

Windows Logo+SHIFT+M

Restore the minimized windows

Windows Logo+E

Open My Computer

Windows Logo+F

Search for a file or a folder

CTRL+Windows Logo+F

Search for computers

Windows Logo+F1

Display Windows Help

Windows Logo+ L

Lock the keyboard

Windows Logo+R

Open the Run dialog box

Windows Logo+U

Open Utility Manager

F1 key

Gives help on the active window or selected item.

F2 key

Rename the selected item

F3 key

Search for a file or a folder

F4 key

Display the Address bar list in My Computer or Windows Explorer

F5 key

Update the active window

F6 key

Cycle through the screen elements in a window or on the desktop

F10 key

Activate the menu bar in the active program

CTRL+A

Selects all the items in the active window.

CTRL+C

Copies the item or items to the Clipboard and can be pasted using CTRL and V.

CTRL+F

Displays the Find all files dialog box.

CTRL+G

Displays the Go to folder dialog box.

CTRL+N

Displays the New dialog box.

CTRL+O

Displays the Open dialog box.

CTRL+P

Displays the Print dialog box.

CTRL+S

Displays the Save dialog box.

CTRL+V

Pastes the copied item or items from the Clipboard.

CTRL+X

Cuts the item or items selected to the Clipboard.

CTRL+Z

Undoes the last action.

CTRL+F4

Closes the active document window.

CTRL while dragging an item

Copy the selected item

CTRL+SHIFT with arrow keys

Highlight a block of text

CTRL+F4

Close the active document

CTRL+ESC

Display the Start menu

CTRL and F6

Opens the next document window in the active application.

ALT+ENTER

View the properties for the selected item

ALT+F4

Close the active item, or quit the active program

ALT+SPACEBAR

Open the shortcut menu for the active window

ALT+TAB

Switch between the open items

ALT+ESC

Cycle through items in the order that they had been opened

Tuesday, June 12, 2007

Multiple Login In Yahoo

You can login with multiple ID's on the same yahoo messenger.

Follow these steps : ==>>

* Go to Start ==> Run ==>> Type regedit,hit enter

* Go to HKEY_CURRENT_USER ==>> Software ==>> Yahoo ==>> pager ==>>Test

* On the right pane ==>> right-click and choose new Dword value .

* Rename it as Plural.

* Double click and assign a decimal value of 1.

* Now close registry and restart yahoo messenger.

* For signing in with new id open another messenger .

Time Limitations For Users (Win XP)

You can limit user timings in Windows XP using "net user" command.

  1. Click on Start Menu
  2. Click Run
  3. Type "cmd"
  4. Click "OK"
  5. Type the command according to following syntax and press enter.
Syntax:
net user /time:

Monday, June 11, 2007

Using Msconfig to shut off Auto-Start programs

So you want to speed up your booting process, well here's a tip for you to shut off those programs that start in your system tray when you first turn on your computer. There are a few reasons why you would want to do this:
  • Speed up your boot time
  • The system tray programs won't be running in the background taking up your processor speed
  • Don't you just hate it when a program does that without your permission, grrrr, I mean, really!

Here's the quickest and easiest way to shut off those annoying programs. Here are the steps:

  • Click Start
  • Go to Run
  • Type in the box msconfig. It will open this Window.
  • Click on the Startup tab at the top, this will show a listing of programs that auto start when your computer is first booted. If you uncheck the box the program will no longer auto start and sit in your system tray when you boot. You'll need to reboot before this takes effect.

There are some programs that you definitely want to launch when you launch your computer, like your Antivirus software, you're firewall, and things like that. Programs like MSN, Realplayer, and things like that, I would uncheck, unless you really like those programs.

Another way to do this would be to go to the program that is in your system tray and you can find the settings to remove them from the auto start, most programs have this listed in the properties section, just another way you can do this. Right click and go to properties, sometimes these setting are buried in the program, so the way above is just a quicker way of doing it.

Closing Error Reporting (Win XP)

Error reporting, what is it and why does Microsoft want you to have it on? Basically whenever your computer crashes Win XP makes a little report of what went wrong and then sends it to Microsoft so they can improve the Windows Operating System. Generally it sounds like a nice idea, but do you really want to be sending reports about your computer to Microsoft? I personally don't and they allow you to shut off this feature. Here's how you do it:

  1. Open your control panel
  2. Click on Performance and Maintenance
  3. Then click on System
  4. Go to the Advance Tab
  5. Click on the Error Reporting button at the bottom
  6. Select Disable Error Reporting
  7. Click the "But notify me when a critical error occurs"
  8. Click Ok Twice.

You can leave out step 7, but I like my operating system to tell me when its had a major error, mainly because I can look up the cause of the error and hopefully find a solution to it on the net or at Microsoft. There you have it, error reporting to Microsoft is off and you don't have to worry about sending a report to Bill Gates.

Lock Any Folder You Want

Suppose you want to lock the folder games in d: which has the path D:\Games In the same drive create a text file and type
ren games games.{21EC2020-3AEA-1069-A2DD-08002B30309D}
Now save this text file as loc.bat

create another text file and type in it
ren games.{21EC2020-3AEA-1069-A2DD-08002B30309D} games
Now save this text file as key.bat

Now you can see 2 batch files loc and key.Press loc and the folder games will change to control panel and you cannot view its contents.Press key and you will get back your original folder.

Check it out!!!!!!!