Using The Help Topic Pane

F1

Display the Help window if the Assistant is turned off (if the Assistant is turned on, F1 displays the Assistant balloon).

F6

Switch between the Help topic and the Contents, Answer Wizard, Index pane

TAB

Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic

SHIFT+TAB

Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web site article

ENTER

Perform the action for the selected Show All, Hide All, hidden text, or hyperlink

ALT+O

Display the Options menu to access any Help toolbar command

ALT+O, and then press T

Hide or show the pane with the Contents, Answer Wizard, and Index tabs

ALT+O, and then press B

Display the previously viewed topic

ALT+O, and then press F

Display the next topic in a previously displayed sequence of topics

ALT+O, and then press H

Return to the specified home page

ALT+O, and then press S

Stop the Help window from opening a Help topic (useful if you want to stop a Web page from downloading)

ALT+O, and then press I

Open the Internet Options dialog box for Microsoft Internet Explorer, where you can change accessibility settings

ALT+O, and then press R

Refresh the topic (useful if you have linked to a Web page)

ALT+O, and then press P

Print all topics in a book or a selected topic only

ALT+F4

Close the Help window

Resize & Move Menus, Toolbarsm, Task Panes

1. Press ALT to select the Menu Bar.
2. Press CTRL+TAB repeatedly to select the Toolbar or Task Pane you want.
3. Do one of the following:

Resize a Tool Bar

1. 1. In the toolbar, press CTRL+SPACE to display the Toolbar Options menu.
   2. Select the Size command, and then press ENTER.
   3. Use the arrow keys to resize the toolbar. Press CTRL+ the arrow keys to resize one pixel at a time
   4. Move The Toolbar
   1. In the toolbar, press CTRL+SPACE to display the Toolbar Options menu.
   2. Select the Move command, and then press ENTER.
   3. Use the arrow keys to position the toolbar. Press CTRL+ the arrow keys to move one pixel at a time. To undock the toolbar, press DOWN ARROW repeatedly. To dock the toolbar vertically on the left or right side, press LEFT ARROW or RIGHT ARROW respectively when the toolbar is all the way to the left or right side.

   Resize Task Pane

   1. In the task pane, press CTRL+SPACE to display a menu of additional commands.
   2. Use the DOWN ARROW key to select the Size command, and then press ENTER.
   3. Use the arrow keys to resize the task pane. Use CTRL+ the arrow keys to resize by one pixel at a time.

   Move a Task Pane

   1. In the task pane, press CTRL+SPACE to display a menu of additional commands.
   2. Use the DOWN ARROW key to select the Move command, and then press ENTER.
   3. Use the arrow keys to position the task pane. Use CTRL+ the arrow keys to move one pixel at a time.
2. When you are finished moving or resizing, press ESC.

Display and use of Task Pane

F6

Move to a task pane from another pane in the program window. (You may need to press F6 more than once.)

Note If pressing F6 doesn't display the task pane you want, try pressing ALT to place focus on the menu bar, and then pressing CTRL+TAB to move to the task pane. In addition, if you open a dialog box from the Reveal Formatting task pane, the focus may be in your document after you close the dialog box, rather than in the task pane. You can use F6 or CTRL+TAB to return to the task pane.

CTRL+TAB

When a menu or toolbar is active, move to a task pane. (You may need to press CTRL+TAB more than once.)

TAB or SHIFT+TAB

When a task pane is active, select the next or previous option in the task pane.

CTRL+DOWN ARROW

Display the full set of commands on the task pane menu.

DOWN ARROW or UP ARROW

Move among choices in a selected submenu; move among certain options in a group of options.

SPACEBAR or ENTER

Open the selected menu, or perform the action assigned to the selected button.

SHIFT+F10

Open a shortcut menu; open a drop-down menu for the selected gallery item.

HOME or END

When a menu or submenu is visible, select the first or last command on the menu or submenu.

PAGE UP or PAGE DOWN

Scroll up or down in the selected gallery list.

CTRL+HOME or CTRL+END

Move to the top or bottom of the selected gallery list.

Display and Use Windows in Ms-Word

ALT+TAB
Switch to the next window
ALT+SHIFT+TAB
Switch to the previous window
CTRL+W or CTRL+F4
Close the active window
CTRL+F5
Restore the size of the active window after you've maximized it
F6
Move to a task pane from another pane in the program window (clockwise direction). You may need to press F6 more than once.
Note If pressing F6 doesn't display the task pane you want, try pressing ALT to place focus on the menu bar, and then pressing CTRL+TAB to move to the task pane.
SHIFT+F6
Move to a pane from another pane in the program window (counterclockwise direction)
CTRL+F6
When more than one window is open, switch to the next window
CTRL+SHIFT+F6
Switch to the previous window
CTRL+F7
When a document window is not maximized, performs the Move command (on the Control menu for the window). Use the arrow keys to move the window, and, when finished, press ESC.
CTRL+F8
When a document window is not maximized, performs the Size command (on the Control menu for the window). Use the arrow keys to resize the window, and, when finished, press ESC.
CTRL+F9
Minimize a window to an icon (works only for some Microsoft Office programs)
CTRL+F10
Maximize or restore a selected window
PRINT SCREEN
Copy a picture of the screen to the Clipboard
ALT+PRINT SCREEN
Copy a picture of the selected window to the Clipboard

Switch to another view

ALT+CTRL+P

Switch to print layout view

ALT+CTRL+O

Switch to outline view

ALT+CTRL+N

Switch to normal view

CTRL+\

Move between a master document and its subdocuments

Printing and previewing documents

CTRL+P
Print a document
ALT+CTRL+I
Switch in or out of print preview
Arrow keys
Move around the preview page when zoomed in
PAGE UP or PAGE DOWN
Move by one preview page when zoomed out
CTRL+HOME
Move to the first preview page when zoomed out
CTRL+END
Move to the last preview page when zoomed out

How i can change Formating with Keyboard in MS-WORD

CTRL+SHIFT+C
Copy formatting from text
CTRL+SHIFT+V
Apply copied formatting to text
CTRL+SHIFT+F
Change the font
CTRL+SHIFT+P
Change the font size
CTRL+SHIFT+>
Increase the font size
CTRL+SHIFT+<
Decrease the font size
CTRL+]
Increase the font size by 1 point
CTRL+[
Decrease the font size by 1 point
CTRL+D
Change the formatting of characters (Font command, Format menu)
SHIFT+F3
Change the case of letters
CTRL+SHIFT+A
Format letters as all capitals
CTRL+B
Apply bold formatting
CTRL+U
Apply an underline
CTRL+SHIFT+W
Underline words but not spaces
CTRL+SHIFT+D
Double-underline text
CTRL+SHIFT+H
Apply hidden text formatting
CTRL+I
Apply italic formatting
CTRL+SHIFT+K
Format letters as small capitals
CTRL+EQUAL SIGN
Apply subscript formatting (automatic spacing)
CTRL+SHIFT+PLUS SIGN
Apply superscript formatting (automatic spacing)
CTRL+SPACEBAR
Remove manual character formatting
CTRL+SHIFT+Q
Change the selection to the Symbol font

How i can Edit Data With Keyboard

F2
Edit the active cell and position the insertion point at the end of the cell contents.
ALT+ENTER
Start a new line in the same cell.
BACKSPACE
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents.
DELETE
Delete the character to the right of the insertion point, or delete the selection.
CTRL+DELETE
Delete text to the end of the line.
F7
Display the Spelling dialog box.
SHIFT+F2
Edit a cell comment.
ENTER
Complete a cell entry and select the next cell below.
CTRL+Z
Undo the last action.
ESC
Cancel a cell entry.
CTRL+SHIFT+Z
When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.

Enter And Calculate Formula

= (equal sign)
Start a formula.
F2
Move the insertion point into the Formula Bar when editing in a cell is turned off.
BACKSPACE
In the Formula Bar, delete one character to the left.
ENTER
Complete a cell entry from the cell or Formula Bar.
CTRL+SHIFT+ENTER
Enter a formula as an array formula.
ESC
Cancel an entry in the cell or Formula Bar.
SHIFT+F3
In a formula, display the Insert Function dialog box.
CTRL+A
When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
CTRL+SHIFT+A
When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
F3
Paste a defined name into a formula.
ALT+= (equal sign)
Insert an AutoSum formula with the SUM function.
CTRL+SHIFT+" (quotation mark)
Copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+' (apostrophe)
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+` (single left quotation mark)
Alternate between displaying cell values and displaying formulas.
F9
Calculate all worksheets in all open workbooks.
When a portion of a formula is selected, calculate the selected portion. You can then press ENTER or CTRL+SHIFT+ENTER (for array formulas) to replace the selected portion with the calculated value.
SHIFT+F9
Calculate the active worksheet.
CTRL+ALT+F9
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9
Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

Show, hide, and outline data

ALT+SHIFT+RIGHT ARROW
Groups rows or columns.
ALT+SHIFT+LEFT ARROW
Ungroups rows or columns.
CTRL+8
Displays or hides the outline symbols.
CTRL+9
Hides the selected rows.
CTRL+SHIFT+( (opening parenthesis)
Unhides any hidden rows within the selection.
CTRL+0 (zero)
Hides the selected columns.
CTRL+SHIFT+) (closing parenthesis)
Unhides any hidden columns within the selection.
Switch to the previous program.
CTRL+ESC
Display the Windows Start menu.
CTRL+W or CTRL+F4
Close the selected workbook window.
CTRL+F5
Restore the window size of the selected workbook window.
F6
Switch to the next pane in a worksheet that has been split (Window menu, Split command).
SHIFT+F6
Switch to the previous pane in a worksheet that has been split.
CTRL+F6
When more than one workbook window is open, switch to the next workbook window.
CTRL+SHIFT+F6
Switch to the previous workbook window.
CTRL+F7
When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC.
CTRL+F8
When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ESC.
CTRL+F9
Minimize a workbook window to an icon.
CTRL+F10
Maximize or restore the selected workbook window.

Most Helpful Short Keys in Ms-Excel

ALT+TAB
Switch to the next program.
ENTER
Complete a cell entry and select the cell below.
ALT+ENTER
Start a new line in the same cell.
CTRL+ENTER
Fill the selected cell range with the current entry.
SHIFT+ENTER
Complete a cell entry and select the previous cell above.
TAB
Complete a cell entry and select the next cell to the right.
SHIFT+TAB
Complete a cell entry and select the previous cell to the left.
ESC
Cancel a cell entry.
Arrow keys
Move one character up, down, left, or right.
HOME
Move to the beginning of the line.
F4 or CTRL+Y
Repeat the last action.
CTRL+SHIFT+F3
Create names from row and column labels.
CTRL+D
Fill down.
CTRL+R
Fill to the right.
CTRL+F3
Define a name.
CTRL+K
Insert a hyperlink.
ENTER (in a cell with a hyperlink)
Activate a hyperlink.
CTRL+; (semicolon)
Enter the date.
CTRL+SHIFT+: (colon)
Enter the time.
ALT+DOWN ARROW
Display a drop-down list of the values in the current column of a list.
CTRL+Z
Undo the last action.
Press F2 to edit the cell, turn on NUM LOCK, and then press the following keys by using the numeric key pad:
ALT+0162
Enters the cent character ¢.
ALT+0163
Enters the pound sterling character £.
ALT+0165
Enters the yen symbol ¥.
ALT+0128
Enters the euro symbol €.

= (equal sign)
Start a formula.
F2
Move the insertion point into the Formula Bar when editing in a cell is turned off.
BACKSPACE
In the Formula Bar, delete one character to the left.
ENTER
Complete a cell entry from the cell or Formula Bar.
CTRL+SHIFT+ENTER
Enter a formula as an array formula.
ESC
Cancel an entry in the cell or Formula Bar.
SHIFT+F3
In a formula, display the Insert Function dialog box.
CTRL+A
When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
CTRL+SHIFT+A
When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
F3
Paste a defined name into a formula.
ALT+= (equal sign)
Insert an AutoSum formula with the SUM function.
CTRL+SHIFT+" (quotation mark)
Copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+' (apostrophe)
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+` (single left quotation mark)
Alternate between displaying cell values and displaying formulas.
F2
Edit the active cell and position the insertion point at the end of the cell contents.
ALT+ENTER

Usage Of Filter By Keys in Ms-Excel

ALT+DOWN ARROW
In the cell that contains the drop-down arrow, displays the AutoFilter list for the current column.
DOWN ARROW
Selects the next item in the AutoFilter list.
UP ARROW
Selects the previous item in the AutoFilter list.
ALT+UP ARROW
Closes the AutoFilter list for the current column.
HOME
Selects the first item (All) in the AutoFilter list.
END
Selects the last item in the AutoFilter list.
ENTER
Filters the list based on the item selected from the AutoFilter list.

Insert, delete, and copy cells in MS-EXCEL

CTRL+C
Copy the selected cells.
CTRL+C, immediately followed by another CTRL+C
Display the Microsoft Office Clipboard (multiple copy and paste).
CTRL+X
Cut the selected cells.
CTRL+V
Paste copied cells.
DELETE
Clear the contents of the selected cells.
CTRL+HYPHEN
Delete the selected cells.
CTRL+SHIFT+PLUS SIGN
Insert blank cells.

How u can format data in Ms-Excel with Keyboard.

ALT+' (apostrophe)
Display the Style dialog box.
CTRL+1
Display the Format Cells dialog box.
CTRL+SHIFT+~
Apply the General number format.
CTRL+SHIFT+$
Apply the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%
Apply the Percentage format with no decimal places.
CTRL+SHIFT+^
Apply the Exponential number format with two decimal places.
CTRL+SHIFT+#
Apply the Date format with the day, month, and year.
CTRL+SHIFT+@
Apply the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!
Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values.
CTRL+B
Apply or remove bold formatting.
CTRL+I
Apply or remove italic formatting.
CTRL+U
Apply or remove underlining.
CTRL+5
Apply or remove strikethrough.
CTRL+9
Hide the selected rows.
CTRL+SHIFT+( (opening parenthesis)
Unhide any hidden rows within the selection.
CTRL+0 (zero)
Hide the selected columns.
CTRL+SHIFT+) (closing parenthesis)
Unhide any hidden columns within the selection.
CTRL+SHIFT+&
Apply the outline border to the selected cells.
CTRL+SHIFT+_
Remove the outline border from the selected cells.