Thursday, 5 January 2017

Shortcut Command of Excel and word



Shortcut Command of Excel

Excel 2000
Alternate between displaying cell values and displaying cell formulas
CTRL+` (single left quotation mark)
Excel 2000
Calculate all sheets in all open workbooks
F9
Excel 2000
Calculate the active worksheet
SHIFT+F9
Excel 2000
Copy
CTRL+C
Excel 2000
Create a chart that uses the current range
F11 or ALT+F1
Excel 2000
Display the Format Cells dialog box
CTRL+1
Excel 2000
Display the Go To dialog box
F5
Excel 2000
Fill the selected cell range with the current entry
CTRL+ENTER
Excel 2000
Insert the current time
CTRL+:
Excel 2000
Insert today's date
CTRL+;
Excel 2000
Move to the beginning of the worksheet
CTRL+HOME
Excel 2000
Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottommost used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
CTRL+END
Excel 2000
Open
CTRL+O
Excel 2000
Paste
CTRL+V
Excel 2000
Paste a function into a formula
SHIFT+F3
Excel 2000
Print
CTRL+P
Excel 2000
Save
CTRL+Singh
Excel 2000
Select all (when you are not entering or editing a formula)
CTRL+A
Excel 2000
Select the current column
CTRL+SPACEBAR
Excel 2000
Select the current row
SHIFT+SPACEBAR
Excel 2000
Undo
CTRL+Z
Excel 2000
When you enter a formula, display the Formula Palette after you type a function name
CTRL+A



Shortcut Command of  Word

Word 2000
Bold
CTRL+B
Word 2000
Change case
SHIFT+F3
Word 2000
Copy
CTRL+C
Word 2000
Delete a word
CTRL+BACKSPACE
Word 2000
Find and replace
CTRL+F
Word 2000
Go to page, section, line, etc.
CTRL+G
Word 2000
Go to the beginning of the document
CTRL+HOME
Word 2000
Go to the end of the document
CTRL+END
Word 2000
Insert a hyperlink
CTRL+K
Word 2000
Italicize
CTRL+I
Word 2000
Open
CTRL+O
Word 2000
Open the thesaurus
SHIFT+F7
Word 2000
Paste
CTRL+V
Word 2000
Print
CTRL+P
Word 2000
Repeat your last action
F4 or CTRL+Y
Word 2000
Save
CTRL+S
Word 2000
Select all
CTRL+A
Word 2000
Select to the beginning of the document
CTRL+SHIFT+HOME
Word 2000
Select to the end of the document
CTRL+SHIFT+END
Word 2000
Undo
CTRL+Z







No comments:

Post a Comment

If you have any doubt please let me know..