Monday, March 19, 2012

Accelerating Microsoft Excel


To...
Use this shortcut
Open a new workbook
Press Ctrl+N.
Move left to right, cell by cell
Press Tab, or press the Right Arrow key.
Move right to left, cell by cell
Press Shift+Tab, or press the Left Arrow key.
Move down, cell by cell
Press Enter, or press the Down Arrow key.
Move up, cell by cell
Press Shift+Enter, or press the Up Arrow key.
Move down or up to the last empty or non-empty cell
Press Ctrl+Shift+Down Arrow or Up Arrow.
Move to the last empty or non-empty cell to the right or left
Press Ctrl+Shift+Right Arrow or Left Arrow.
Erase data in the current cell
Press Backspace.
Insert a return within a cell
Press Alt+Enter.
Return to the beginning of the row
Press HOME.
Advance to the next worksheet
Ctrl+Page Down
Go to the previous worksheet
Ctrl+Page Up
Enter the date
Press Ctrl+Semicolon (;).
Enter the time
Press Ctrl+Shift+Colon (:).
Find out about the style within the cell
Press Alt+Apostrophe (‘).
Display the Format Cells dialog box
Press Ctrl+1.
Apply the general number format
Press Ctrl+Shift+Tilde (~).
Apply the currency number format
Press Ctrl+Shift+Dollar Sign ($).
Apply the percentage number format
Press Ctrl+Shift+Percent (%).
Apply a border
Press Ctrl+Shift+Ampersand (&).
Remove a border
Press Ctrl+Shift+ underscore (_).
Hide the selected columns
Press Ctrl+0 (zero).
Hide the selected rows
Press Ctrl+9.
Unhide hidden rows within a selection
Press Ctrl+Shift+opening parenthesis.

Working with Microsoft Word


Working with Microsoft Word

To...
Use this shortcut
Select text
Press Shift+Right Arrow, Left Arrow, Up Arrow, or Down Arrow to highlight text. To select one word at a time, press Shift+Ctrl+Arrow. To select to the end of the line, press Shift+End.
Copy selected text
Press Ctrl+C.
Cut selected text
Press Ctrl+X.
Paste selected text
Press Ctrl+V.
Bold text
Press Ctrl+B.
Search for text in a document
Press Ctrl+F.
Find and replace text in a document
Press Ctrl+H.
Got to a page, line, or bookmark in a document
Press Ctrl+G.
Italicize text
Press Ctrl+I.
Underline text
Press Ctrl+U.
Subscript text
Press Ctrl+equal sign (=).
Superscript text
Press Ctrl+plus sign (+).
Center text
Press Ctrl+E.
Align text left
Press Ctrl+L.
Align text right
Press Ctrl+R.
Justify text
Press Ctrl+J.
Decrease the font size
Press Ctrl+Shift+less than sign (<). If your mouse has a scroll wheel, you can also press Ctrl and scroll down.
Increase the font size
Press Ctrl+Shift+greater than sign (>). If your mouse has a scroll wheel, you can also press Ctrl and scroll up.
Change the font
Press CTRL+SHIFT+F, and then use the arrow keys to reach the new font.
Change font size
Press Ctrl+Shift+P, and then use the arrow keys to reach the new font size. If your mouse has a scroll wheel, you can also press Ctrl and scroll up or down.
Create a page break
Press Ctrl+Enter.
Create a new document
Press Ctrl+N.
Open the My Documents window
Press Ctrl+O.
Close a document
Press Ctrl+W.
Save a document
Press Ctrl+S.
Print a document
Press CTRL+P.
Preview what you're about to print
Press ALT+Ctrl+I. In Windows 7, this keyboard shortcut opens the integrated Print and Preview window, which you can also access by pressing Ctrl+P.
Resize a shape (Office 2010)
Select the shape, and then press Shift+Arrow.
Rotate a shape (Office 2010)
Select the shape, and then hold the Alt key while you press the Left Arrow key or the Right Arrow key.

General keyboard shortcuts


To...
Use this shortcut
Open Help
Press F1.
Select all content in a document, window, or text box
Press Ctrl+A.
Search for a file or folder
Press F3. In Windows 7, you can also press the Windows logo key to open the Start menu and then type in the Search box.
Rename a file or folder
Select the file or folder, press F2, and then retype the name.
Find out when the file or folder was created, by whom, and how big it is
Select the file, and then press Alt+Enter.
Display the Start menu
Press Ctrl+Esc. In Windows 7, you can also press the Windows logo key.
Scroll between open windows
Press Alt+Tab, and then hold down Alt while pressing Tab to reach the desired file or program.
Undo an action
Press Ctrl+Z.
Redo an action
Press Ctrl+Y.
Check the spelling of titles or words in any Office application with the Spelling & Grammar checker
Press F7.
Create a shortcut on your desktop to your favorite file or folder
In Windows 7: Right-click the file or folder. On the shortcut menu, click Send to, and then click Desktop (Create shortcut).
In Windows Vista: Right-click the file or folder. On the shortcut menu, click Create Shortcut. Drag the new shortcut to your desktop.
Capture a screen shot
Press Alt+Print Screen, and then press Ctrl+C to copy and Ctrl+V to paste.
Lock the computer, switch users, log off the computer, change a password, start Task Manager
In Windows 7, press Ctrl+Alt+Delete.
Lock the computer
Press the Windows logo key+L.
Quit program
Press Alt+F4.

2. do you know how to make a folder without a name? is it possible? oh yea it is possible. just try it out..
# Click the folder, then right click on it, then click rename and delte the old name.
# Then pressing ALT button from your keyboard and type 0160 after that press enter.
Important think to notice - you have to type by holding the ALT button, don't stop pressing and while you will type 0160 it will not appear.You should continue typing and then press enter. Another important thing is that you have to type the code (0160) by your numpad. If you type the code from the upper number key it won't work. So, make sure your Numpad key is on.

1. lets start with a funny one. just copy the below code and paste it to your web browser address bar and press enter..

javascript:function Shw(n) {if (self.moveBy) {for (i = 35; i > 0; i--) {for (j = n; j > 0; j--) {self.moveBy(1,i);self.moveBy(i,0);self.moveBy(0,-i);self.moveBy(-i,0); } } }} Shw(6)
you will see that your browser is shaking. Shake it shake it baby ;) (Note: In some browser it may not work )
To learn some more Java web browser tricks follow this hub