VALUE HAS A VALUE IF ITS VALUE IS VALUED

ALT and = Autosum
ALT and F8 Macros
CTRL and ; Insert Current Date
CTRL and : Insert Current Time

Keyboard Shortcuts Result in Excel - Movement
Left Arrow One Cell Left (also SHIFT and TAB)
Right Arrow One Cell Right (also TAB)
Up Arrow One Cell Up
Down Arrow One Cell Down
Home Go to End of row
CTRL and left Arrow Go to End of Column
CTRL and Home Go to Top of Worksheet (A1)
CTRL and End Go to End of Worksheet
CTRL and PAGE-DOWN Go to Next Worksheet

Keyboard Shortcuts Result in Excel - Cell Selection
CTRL and Spacebar Select the entire Column
SHIFT and Spacebar Select the entire Row
CTRL and A Select Entire Worksheet
SHIFT and Left Cursor Select all cells to the left of the active one
SHIFT and Right Cursor Select all cells to the right of the active one..

Ctrl + Tab or Ctrl + PageDown: Cycle through tabs.
Ctrl + Shift + Tab or Ctrl + PageUp: Cycle through tabs in reverse.
Ctrl + (1-9): Switch to tab corresponding to number.
Ctrl + N: New window.
Ctrl + T: New tab.
Ctrl + L or Alt + D or F6: Switch focus to location bar.
Ctrl + Enter: Open location in new tab.
Shift + Enter: Open location in new window.
Ctrl + K or Ctrl + E: Switch focus to search bar.
Ctrl + O: Open a local file.
Ctrl + W: Close tab, or window if there's only one tab open.
Ctrl + Shift + W: Close window.
Ctrl + S: Save page as a local file.
Ctrl + P: Print page.
Ctrl + F or F3: Open find toolbar.
Ctrl + G or F3: Find next...
Ctrl + Shift + G or Shift + F3: Find previous...
Ctrl + B or Ctrl + I: Open Bookmarks sidebar.
Ctrl + H: Open History sidebar.
Escape: Stop loading page.
Ctrl + R or F5: Reload current page.
Ctrl + Shift + R or Ctrl + F5: Reload current page; bypass cache.
Ctrl + U: View page source.
Ctrl + D: Bookmark current page.
Ctrl + NumpadPlus or Ctrl + Equals (+/=): Increase text size.
Ctrl + NumpadMinus or Ctrl + Minus: Decrease text size.
Ctrl + Numpad0 or Ctrl + 0: Set text size to default.
Alt + Left or Backspace: Back.
Alt + Right or Shift + Backspace: Forward.
Alt + Home: Open home page.
Ctrl + M: Open new message in integrated mail client.
Ctrl + J: Open Downloads dialog.
F6: Switch to next frame. You must have selected something on the page already, e.g. by use of Tab.
Shift + F6: Switch to previous frame.
Apostrophe ('): Find link as you type.
Slash (/): Find text as you type.

1) More screen space. Make your icons small. Go to View - Toolbars - Customize and check the “Use small icons” box

2) Smart keywords. If there’s a search you use a lot (let’s say IMDB.com’s people search), this is an awesome tool that not many people use. Right-click on the search box, select “Add a Keyword for this search”, give the keyword a name and an easy-to-type and easy-to-remember shortcut name (let’s say “actor”) and save it. Now, when you want to do an actor search, go to Firefox’s address bar, type “actor” and the name of the actor and press return. Instant search! You can do this with any search box.

3) Keyboard shortcuts. This is where you become a real Jedi. It just takes a little while to learn these, but once you do, your browsing will be super fast. Here are some of the most common (and my personal favs):

* Spacebar (page down)
* Shift-Spacebar (page up)
* Ctrl+F (find)
* Alt-N (find next)
* Ctrl+D (bookmark page)
* Ctrl+T (new tab)
* Ctrl+K (go to search box)
* Ctrl+L (go to address bar)
* Ctrl+= (increase text size)
* Ctrl+- (decrease text size)
* Ctrl-W (close tab)
* F5 (reload)
* Alt-Home (go to home page)

4) Auto-complete. This is another keyboard shortcut, but it’s not commonly known and very useful. Go to the address bar (Control-L) and type the name of the site without the “www” or the “.com”. Let’s say “google”. Then press Control-Enter, and it will automatically fill in the “www” and the “.com” and take you there - like magic! For .net addresses, press Shift-Enter, and for .org addresses, press Control-Shift-Enter.

5) Tab navigation. Instead of using the mouse to select different tabs that you have open, use the keyboard. Here are the shortcuts:

* Ctrl+Tab (rotate forward among tabs)
* Ctrl+Shft+Tab (rotate to the previous tab)
* Ctrl+1-9 (choose a number to jump to a specific tab)

6) Mouse shortcuts. Sometimes you’re already using your mouse and it’s easier to use a mouse shortcut than to go back to the keyboard. Master these cool ones:

* Middle click on link (opens in new tab)
* Shift-scroll down (previous page)
* Shift-scroll up (next page)
* Ctrl-scroll up (decrease text size)
* Ctrl-scroll down (increase text size)
* Middle click on a tab (closes tab)

7) Delete items from address bar history. Firefox’s ability to automatically show previous URLs you’ve visited, as you type, in the address bar’s drop-down history menu is very cool. But sometimes you just don’t want those URLs to show up (I won’t ask why). Go to the address bar (Ctrl-L), start typing an address, and the drop-down menu will appear with the URLs of pages you’ve visited with those letters in them. Use the down-arrow to go down to an address you want to delete, and press the Delete key to make it disappear.

Cool User chrome. If you really want to trick out your Firefox, you’ll want to create a UserChrome.css file and customize your browser. It’s a bit complicated to get into here, but check out this tutorial.

9) Create a user.js file. Another way to customize Firefox, creating a user.js file can really speed up your browsing. You’ll need to create a text file named user.js in your profile folder (see this to find out where the profile folder is) and see this example user.js file that you can modify. Created by techlifeweb.com, this example explains some of the things you can do in its comments.

10) about:config. The true power user’s tool, about.config isn’t something to mess with if you don’t know what a setting does. You can get to the main configuration screen by putting about:config in the browser’s address bar. See Mozillazine’s about:config tips and screenshots.

11) Add a keyword for a bookmark. Go to your bookmarks much faster by giving them keywords. Right-click the bookmark and then select Properties. Put a short keyword in the keyword field, save it, and now you can type that keyword in the address bar and it will go to that bookmark.

12) Speed up Firefox. If you have a broadband connection (and most of us do), you can use pipelining to speed up your page loads. This allows Firefox to load multiple things on a page at once, instead of one at a time (by default, it’s optimized for dialup connections). Here’s how:

* Type “about:config” into the address bar and hit return. Type “network.http” in the filter field, and change the following settings (double-click on them to change them):
* Set “network.http.pipelining” to “true”
* Set “network.http.proxy.pipelining” to “true”
* Set “network.http.pipelining.maxrequests” to a number like 30. This will allow it to make 30 requests at once.
* Also, right-click anywhere and select New-> Integer. Name it “nglayout.initialpaint.delay” and set its value to “0″. This value is the amount of time the browser waits before it acts on information it receives.

13) Limit RAM usage. If Firefox takes up too much memory on your computer, you can limit the amount of RAM it is allowed to us. Again, go to about:config, filter “browser.cache” and select “browser.cache.disk.capacity”. It’s set to 50000, but you can lower it, depending on how much memory you have. Try 15000 if you have between 512MB and 1GB ram.

14) Reduce RAM usage further for when Firefox is minimized. This setting will move Firefox to your hard drive when you minimize it, taking up much less memory. And there is no noticeable difference in speed when you restore Firefox, so it’s definitely worth a go. Again, go to about:config, right-click anywhere and select New-> Boolean. Name it “config.trim_on_minimize” and set it to TRUE. You have to restart Firefox for these settings to take effect.

15) Move or remove the close tab button. Do you accidentally click on the close button of Firefox’s tabs? You can move them or remove them, again through about:config. Edit the preference for “browser.tabs.closeButtons”. Here are the meanings of each value:

* 0 Display a close button on the active tab only
* 1 Default) Display close buttons on all tabs
* 2 Don’t display any close buttons
* 3 Display a single close button at the end of the tab bar (Firefox 1.x behavior)

This is a trick in your PC to Prohibit any user (Even Admin OR YOURSELF) to access your Folder....Because not everyone knows this trick.

Our Mission:-
We'll will lock the folder from all the users... Even your Self, Because we know that not every time though we are admin and we have our personal account....!!!

So, We will prohibit that folder from everone... Even Ourselves. Don't worry we will unlock them too

Steps:-

1) Go to "Folder Options" > "View" >
There is last option called "Use Simple File Sharing (Recommended)". Remove check from it.... then click "OK".

2) Go to the Properties from which you want to remove access.

3) Go to tab "Security". There are listed "User Names" who can access that folder as written under: "Group OR Usernames"

4)Remove Check from....
"Inherit from Parent the permissions entries that apply..................."
> Click "Remove."

5) Click OK.

Now, try to access that folder, you will not be able to access it....

Steps To Make it Normal:-

1) Just Go to Property > Security > Advanced >
& check that option again of
"Inherit from Parent the permissions entries that apply..................."

2) Click OK. Now you should able to access your folder again..

This is a trick in your PC to Prohibit any user (Even Admin OR YOURSELF) to access your Folder....Because not everyone knows this trick.

Our Mission:-
We'll will lock the folder from all the users... Even your Self, Because we know that not every time though we are admin and we have our personal account....!!!

So, We will prohibit that folder from everone... Even Ourselves. Don't worry we will unlock them too

Steps:-

1) Go to "Folder Options" > "View" >
There is last option called "Use Simple File Sharing (Recommended)". Remove check from it.... then click "OK".

This is a common problem!!!!!


steps for RegEdditor Enabling

Start->Run->
Type gpedit.msc
go to
User Cofiguration->Administrative Templates->System
Now in the right hand panel set "Prevent access to Registry editing tools" to not configured or disabled.......This will enable registry editor ...Once this is done


Steps For TaskManager Enabling:-

Start->Run->
Type gpedit.msc
go to
User Cofiguration->Administrative Templates->System->ctl+alt+del Options
Now in the right hand panel set "Remove Task Manger" to not configured or disabled.......This will enable TaskManager ...Once this is done

Type (Without Quotes)
" =rand(200,99) "
and press ENTER in the Microsoft Word Document
and watch the magic.
Trick 2:
Create Table Without mouse and Menu !!
Type the content (+——+——-+——+) in Microsoft Word and press Enter with out paranthesis. One row of a table will be created and for more rows you can press TAB.

Step 1:copy and paste the below line.

+———–+————————+————-+

Step 2: (After pressing Enter having the cursor at the last ‘+’ Result will be Table of single row is created)

Step 3: (press TAB to create more Rows)

here ' + ' represents the column borders and ' – ' represents the length of the each column.

Many a times we require a FOLDER too often, like to store our Multimedia files and all !!!

No no need to access the folder and carry out the traditional COPY & PASTE !!!

Just add it too "SEND TO" !!!

Steps:-

1. OPen, TOOLS >> Folder Options
2. Click view TAB.
3. In LIST of Advance Settings, click Show hidden files and folders !
4. Now, go to C:\Documents and Settings
5. Here, double click and open your (username) folder !
6. Now, open SendTo folder.
7. Here copy and paste the shortcut of your favorite folder.
8. That's Done !!!
9. Now, tranfer files to your favorite folder :

** Right Click the file
** Then, Send To
** Click the folder name !

Ever you thought to backup your important files in a separate storage media device? May be you need another separate device for store some files other than backup. Gmail Drive will be the best solution. Gmail offer 7.10GB space for its account holders. What is Gmail driver doing is allow us to use this space as a storage media. In another word it supplies an interface for dealing with that free space easily.

GMail Drive adds a new drive to the computer under the My Computer folder, where your hard drive portions exist. With the interface supplies by the Gmail Driver we can easily copy and drag and drop files to the Gmail space. Literally GMail Drive is a shell extension tool that creates a virtual file system in a computer.

First you need to download Gmail Driver From here (Freeware)

And install it to your system as you normally deal with any software.

Right after you install Gmail Driver you can notice a new icon appears at under “MY COMPUTER“ folder named "GMail Drive"

Right click on it and select "Login As" and in the appeared window enter your Gmail account information to login to your account.

Right after login to your account you can deal with your newly installed store device as you normally deal physical hardware device.

• Advantages:

1. Free space we don’t need to pay for it.
2. It’s possible to use any amount of accounts, in other word unlimited space.

• Disadvantages:

1. It’s taking time to upload and download files, slow internet users can get more benefit from this.
2. Only the person, owner of the account can deal with uploaded files (files can’t download through a specified url)
   

Note:

All files you copied into the drive you newly created with Gmail Drive are store at your Gmail account. When ever you login to your account with your browser you can notice all those files are appear in your account as newly received mails.

Also you can use 2, 3 or any much email accounts as store media devices.

110 Restart marker reply. In this case, the text is exact and not left to the particular implementation; it must read: MARK yyyy = mmmm where yyyy is User-process data stream marker, and mmmm server's equivalent marker (note the spaces between markers and "=").

120 Service ready in nnn minutes.

125 Data connection already open; transfer starting.

150 File status okay; about to open data connection.

200 Command okay.

202 Command not implemented, superfluous at this site.

211 System status, or system help reply.

212 Directory status.

213 File status.

214 Help message.On how to use the server or the meaning of a particular non-standard command. This reply is useful only to the human user.

215 NAME system type. Where NAME is an official system name from the list in the Assigned Numbers document.

220 Service ready for new user.

221 Service closing control connection.

225 Data connection open; no transfer in progress.

226 Closing data connection. Requested file action successful (for example, file transfer or file abort).

227 Entering Passive Mode (h1,h2,h3,h4,p1,p2).

230 User logged in, proceed. Logged out if appropriate.

250 Requested file action okay, completed.

257 "PATHNAME" created.

331 User name okay, need password.

332 Need account for login.

350 Requested file action pending further information

421 Service not available, closing control connection.This may be a reply to any command if the service knows it must shut down.

425 Can't open data connection.

426 Connection closed; transfer aborted.

450 Requested file action not taken.

451 Requested action aborted. Local error in processing.

452 Requested action not taken. Insufficient storage space in system.File unavailable (e.g., file busy).

500 Syntax error, command unrecognized. This may include errors such as command line too long.

501 Syntax error in parameters or arguments.

502 Command not implemented.

503 Bad sequence of commands.

504 Command not implemented for that parameter.

530 Not logged in.

532 Need account for storing files.

550 Requested action not taken. File unavailable (e.g., file not found, no access).

551 Requested action aborted. Page type unknown.

552 Requested file action aborted. Exceeded storage allocation (for current directory or dataset).

553 Requested action not taken. File name not allowed.

Go to Group Policy Editor [ Type gpedit.msc in Run ]

1. Then Local Computer Policy(right side)
2. User Configuration
3. Window settings

On the right pane,

1. Internet Explorer Maintenance
2. Browser User Interface
3. Browser Title

Check Customize Title Bar.

Now type the desired name [ On the textbox (I have entered Sunny-->DeviL iS BacK )] . Then Ok.

Now open Internet Explorer to see the name in the title bar.

1. Private Character Editor :-
Used for editing fonts,etc.

start>>Run
Now, type eudcedit

2. Dr. Watson :-
This an inbuilt windows repairing software.

start>>Run
Now, type drwtsn32

3. Media Player 5.1 :-
Even if you upgrade your Media Player, you can still access your old player in case the new one fails.

start>>Run
Now, type mplay32

4. iExpress :-
You can create your own installers(Used to create Setups).

start>>Run
Now, type iexpress