MS Excel शॉर्टकट की

MS Excel Shortcut Key

Sr.No	Shortcut Key's	Use of Shortcut Key's
01	F1	Help
02	F2	Rename
03	F3	Paste Name
04	F4	Last Command Repeat
05	F5	Go To
06	F6	Split Window
07	F7	Check Spelling
08	F8	Extended Selection
09	F9	Calculate all Worksheet
10	F10	Turn Key Tips
11	F11	Create a chart
12	F12	Save as
Sr.No	Shortcut Key's	Use of Shortcut Key's
01	CTRL+A	Select the entire worksheet
02	CTRL+B	Bold
03	CTRL+C	Copy
04	CTRL+D	Fill Down.
05	CTRL+F	Find and Replace
06	CTRL+G	Go To
07	CTRL+H	Find and Replace
08	CTRL+I	Italic
09	CTRL+K	Insert Hyperlink
10	CTRL+N	Create a New Blank Workbook
11	CTRL+O	Open Dialog Box to Open Files
12	CTRL+P	Print
13	CTRL+R	Fill Right
14	CTRL+S	Save
15	CTRL+T	Create Table
16	CTRL+U	Underline
17	CTRL+V	Paste
18	CTRL+W	Close Workbook
19	CTRL+X	Cut
20	CTRL+Y	Redo
21	CTRL+Z	Undo
22	CTRL+ +	Insert Cell
23	CTRL+ -	Delete Selected Cell
24	CTRL+'	Show Formulas
25	CTRL+ ;	Current Date
26	CTRL+1	Format Cell
27	CTRL+2	Applies or Remove Bold Formatting
28	CTRL+3	Applies Italic Formatting
29	CTRL+4	Underline
30	CTRL+5	Applies or Remove Strikethrough
31	CTRL+9	Hide selected Rows
32	CTRL+0	Hide selected Columns
33	CTRL+F1	Displays or Hides the Ribbon
34	CTRL+F2	Print Preview Window
35	CTRL+F3	Name Manager
36	CTRL+F4	Close Selected Workbook
37	CTRL+F5	Restores selected Window Size
38	CTRL+F6	Switches the next Workbook window
39	CTRL+F9	Minimizes a Workbook Window
40	CTRL+F10	Maximizes or Restore selected window
Sr.No	Shortcut Key's	Use of Shortcut Key's
01	Backspace	Delete one Character to the left
02	Delete	Delete th Character to the Right
03	ESC	Cancels an entry in the Cell
04	Home	Move to beginning of a Row
05	End	Move to cell in the Right Corner
06	Page Down	Move One Screen Down
07	Page Up	Move One page up
08	Tab	Move one cell to the Right
Sr.No	Shortcut Key's	Use of Shortcut Key's
01	CTRL+SHIFT+%	Peecent Style
02	ALT+=	Sum
03	CTRL+SHIFT+F3	Create From Selection (name)
04	SHIFT+F9	Calculate Sheet
05	CTRL+ALT+F5	Refresh All information in the Workbook
06	CTRL+SHIFT+L	Filter
07	SHIFT+ALT+RIGHT	Group
08	SHIFT+ALT+LEFT	Ungroup
09	ALT+Click	Research
10	SHIFT+F2	New Comment
11	ALT+F8	View Macros
12	----	----
13	----	----
14	----	----
15	----	----
16	----	----
17	----	----
18	----	----
19	----	----
20	----	----
21	----	----
22	----	----
23	----	----
24	----	----