Microsoft excel Shortcuts

Sr No	Key	Description
1	CTRL+PgUp	Switches between worksheet tabs, from left-to-right.
2	CTRL+PgDn	Switches between worksheet tabs, from right-to-left.
3	CTRL+SHIFT+(	Unhides any hidden rows within the selection.
4	CTRL+SHIFT+)	Unhides any hidden columns within the selection.
5	CTRL+SHIFT+&	Applies the outline border to the selected cells.
6	CTRL+SHIFT_	Removes the outline border from the selected cells.
7	CTRL+SHIFT+~	Applies the General number format.
8	CTRL+SHIFT+$	Applies the Currency format with two decimal places (negative numbers in parentheses).
9	CTRL+SHIFT+%	Applies the Percentage format with no decimal places.
10	CTRL+SHIFT+^	Applies the Exponential number format with two decimal places.
11	CTRL+SHIFT+#	Applies the Date format with the day, month, and year.
12	CTRL+SHIFT+@	Applies the Time format with the hour and minute, and AM or PM.
13	CTRL+SHIFT+!	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
14	CTRL+SHIFT+*	Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).  In a PivotTable, it selects the entire PivotTable report.
15	CTRL+SHIFT+:	Enters the current time.
16	CTRL+SHIFT+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.
17	CTRL+SHIFT+Plus (+)	Displays the Insert dialog box to insert blank cells.
18	CTRL+Minus (-)	Displays the Delete dialog box to delete the selected cells.
19	CTRL+;	Enters the current date.
20	CTRL+`	Alternates between displaying cell values and displaying formulas in the worksheet.
21	CTRL+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
22	CTRL+1	Displays the Format Cells dialog box.
23	CTRL+2	Applies or removes bold formatting.
24	CTRL+3	Applies or removes italic formatting.
25	CTRL+4	Applies or removes underlining.
26	CTRL+5	Applies or removes strikethrough.
27	CTRL+6	Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
28	CTRL+8	Displays or hides the outline symbols.
29	CTRL+9	Hides the selected rows.
30	CTRL+0	Hides the selected columns.
31	CTRL+A	Selects the entire worksheet.  If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet.  When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.  CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
32	CTRL+B	Applies or removes bold formatting.
33	CTRL+C	Copies the selected cells.  CTRL+C followed by another CTRL+C displays the Clipboard.
34	CTRL+D	Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
35	CTRL+F	Displays the Find and Replace dialog box, with the Find tab selected.  SHIFT+F5 also displaysthis tab, while SHIFT+F4 repeats the last Find action.  CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
36	CTRL+G	Displays the Go To dialog box.  F5 also displays this dialog box.
37	CTRL+H	Displays the Find and Replace dialog box, with the Replace tab selected.
38	CTRL+I	Applies or removes italic formatting.
39	CTRL+K	Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
40	CTRL+N	Creates a new, blank workbook.
41	CTRL+O	Displays the Open dialog box to open or find a file.  CTRL+SHIFT+O selects all cells that contain comments.
42	CTRL+P	Displays the Print dialog box.  CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
43	CTRL+R	Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
44	CTRL+S	Saves the active file with its current file name, location, and file format.
45	CTRL+T	Displays the Create Table dialog box.
46	CTRL+U	Applies or removes underlining.  CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
47	CTRL+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.  CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
48	CTRL+W	Closes the selected workbook window.
49	CTRL+X	Cuts the selected cells.
50	CTRL+Y	Repeats the last command or action, if possible.
51	CTRL+Z	Uses the Undo command to reverse the last command or to delete the last entry that you typed.  CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.