|
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. |
There are available materials and also E-mail collection and surfing with useful information.
Monday, March 19, 2012
Accelerating Microsoft Excel
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
Subscribe to:
Posts (Atom)