Shortcut Key Ms Excel

No	Shortcut Key Ms Excel	Description
1	F12	Edit contents of a cell
2	F7	Spell check entire document or only highlighted text
3	F11	Create chart
4	CTRL + ;	Enter the current date
5	CTRL + SHIFT + ;	Enter the current time
6	CTRL + ‘	Copies formula from cell above into current cell
7	CTRL + SHIFT + “	Copies value from cell above into current cell
8	CTRL + `	Toggles between displaying cell contents and cell formulas
9	CTRL + R	Copies contents of current cell into selected cells to the right
10	CTRL + D	Copies contents of current cell into selected cells below
11	ALT + SHIFT + F1	Create new worksheet
12	SHIFT + F3	Displays the formula dialogue
13	SHIFT + F5	Displays the search dialogue
14	CTRL + 1	Opens the Format Cells dialogue
15	CTRL + A	Selects all text in current document
16	CTRL + B	BOLD highlighted text
17	CTRL + I	ITALICIZE highlighted text
18	CTRL + U	UNDERLINE highlighted text
19	CTRL + 5	STRIKETHROUGH highlighted text
20	CTRL + X	Cuts (deletes) all highlighted text
21	CTRL + C	Copies all highlighted text to the Windows clipboard
22	CTRL + V	Pastes contents of Windows clipboard into current document at cursor position
23	CTRL + K	Insert hyperlink
24	CTRL + P	Displays the print dialogue
25	CTRL + Z	Undo last action
26	CTRL + Y	Repeat last action
27	CTRL + F6	Switches between open workbooks
28	CTRL + F9	Minimize current window
29	CTRL + F10	Maximize current window
30	CTRL + PGUP	Rotates forward between worksheets in current document
31	CTRL + PGDN	Rotates backward between worksheets in current document
32	CTRL + TAB	Rotates between open documents
33	CTRL + SHIFT + !	Displays numbers in comma format
34	CTRL + SHIFT + @	Displays numbers in time format
35	CTRL + SHIFT + #	Displays numbers in date format
36	CTRL + SHIFT + $	Displays numbers in currency format
37	CTRL + SHIFT + %	Displays numbers in percentage format
38	CTRL + SHIFT + ^	Displays numbers in scientific format
39	CTRL + SHIFT + ~	Displays numbers without special formatting
40	ALT + =	Adds a range of cells
41	CTRL + SHIFT + RIGHT ARROW	Positions cursor at next section of text
42	CTRL + SHIFT + LEFT ARROW	Positions cursor at previous section of text
43	CTRL + SPACE	Selects entire current column
44	SHIFT + SPACE	Selects entire current row
45	F12	Edit contents of a cell

sumber : www.mihirbabu.com