कंप्यूटर में शॉर्टकट की का प्रयोग किसी कमांड को तेजी से एवं आसानी से करने के लिए किया जाता है। विभिन्न की जैसे Alt, Ctrl, या Shift का अन्य की के साथ उपयोग करके इनका प्रयोग किया जाता है। जैसे "Ctrl+S" आपको Ctrl दबाकर और S को एक साथ दबाने पर इसे आसानी से प्रयोग किया जा सकता है।
MICROSOFT-EXCEL || SHORTCUT KEYS
|
Shortcut
Key |
Description |
Menu
Option |
|
Ctrl+A |
Select All |
None |
|
Ctrl+B |
Bold |
Format, Cells, Font, Font Style,
Bold |
|
Ctrl+C |
Copy |
Edit, Copy |
|
Ctrl+D |
Fill Down |
Edit, Fill, Down |
|
Ctrl+F |
Find |
Edit, Find |
|
Ctrl+G |
Goto |
Edit, Goto |
|
Ctrl+H |
Replace |
Edit, Replace |
|
Ctrl+I |
Italic |
Format, Cells, Font, Font Style,
Italic |
|
Ctrl+K |
Insert Hyperlink |
Insert, Hyperlink |
|
Ctrl+N |
New Workbook |
File, New |
|
Ctrl+O |
Open |
File, Open |
|
Ctrl+P |
Print |
File, Print |
|
Ctrl+R |
Fill Right |
Edit, Fill Right |
|
Ctrl+S |
Save |
File, Save |
|
Ctrl+U |
Underline |
Format, Cells, Font, Underline,
Single |
|
Ctrl+V |
Paste |
Edit, Paste |
|
Ctrl W |
Close |
File, Close |
|
Ctrl+X |
Cut |
Edit, Cut |
|
Ctrl+Y |
Repeat |
Edit, Repeat |
|
Ctrl+Z |
Undo |
Edit, Undo |
|
F1 |
Help |
Help, Contents and Index |
|
F2 |
Edit |
None |
|
F3 |
Paste Name |
Insert, Name, Paste |
|
F4 |
Repeat last action |
Edit, Repeat. Works while not in
Edit mode. |
|
F4 |
While typing a formula, switch between absolute /relative
reference |
None |
|
F5 |
Goto |
Edit, Goto |
|
F6 |
Next Pane |
None |
|
F7 |
Spell check |
Tools, Spelling |
|
F8 |
Extend mode |
None |
|
F9 |
Recalculate all workbooks |
Tools, Options, Calculation,
Calc,Now |
|
F10 |
Activate Menubar |
N/A |
|
F11 |
New Chart |
Insert, Chart |
|
F12 |
Save As |
File, Save As |
|
Ctrl+: |
Insert Current Time |
None |
|
Ctrl+; |
Insert Current Date |
None |
|
Ctrl+" |
Copy Value from Cell Above |
Edit, Paste Special, Value |
|
Ctrl+’ |
Copy Formula from Cell Above |
Edit, Copy |
|
Shift |
Hold down shift for additional
functions in Excel’s menu |
none |
|
Shift+F1 |
What’s This? |
Help, What’s This? |
|
Shift+F2 |
Edit cell comment |
Insert, Edit Comments |
|
Shift+F3 |
Paste function into formula |
Insert, Function |
|
Shift+F4 |
Find Next |
Edit, Find, Find Next |
|
Shift+F5 |
Find |
Edit, Find, Find Next |
|
Shift+F6 |
Previous Pane |
None |
|
Shift+F8 |
Add to selection |
None |
|
Shift+F9 |
Calculate active worksheet |
Calc Sheet |
|
Shift+F10 |
Display shortcut menu |
None |
|
Shift+F11 |
New worksheet |
Insert, Worksheet |
|
Shift+F12 |
Save |
File, Save |
|
Ctrl+F3 |
Define name |
Insert, Names, Define |
|
Ctrl+F4 |
Close |
File, Close |
|
Ctrl+F5 |
Restore window size |
Restore |
|
Ctrl+F6 |
Next workbook window |
Window, ... |
|
Shift+Ctrl+F6 |
Previous workbook window |
Window, ... |
|
Ctrl+F7 |
Move window |
Move |
|
Ctrl+F8 |
Resize window |
Size |
|
Ctrl+F9 |
Minimize workbook |
Minimize |
|
Ctrl+F10 |
Maximize or restore window |
Maximize |
|
Ctrl+F12 |
File Open |
File, Open |
|
Alt+F1 |
Insert Chart |
Insert, Chart... |
|
Alt+F2 |
Save As |
File, Save As |
|
Alt+F4 |
Exit |
File, Exit |
|
Alt+F8 |
Macro dialog box |
Tools, Macro, Macros in Excel 97
Tools,Macros - in earlier versions |
|
Alt+F11 |
Visual Basic Editor |
Tools, Macro, Visual Basic Editor |
|
Ctrl+Shift+F3 |
Create name by using names of row and column labels |
Insert, Name, Create |
|
Ctrl+Shift+F6 |
Previous Window |
Window, ... |
|
Ctrl+Shift+F12 |
Print |
File, Print |
|
Alt+Shift+F1 |
New worksheet |
Insert, Worksheet |
|
Alt+Shift+F2 |
Save |
File, Save |
|
Alt+= |
AutoSum |
No direct equivalent |
|
Ctrl+` |
Toggle Value / Formula display |
Tools, Options, View, Formulas |
|
Ctrl+Shift+A |
Insert argument names into formula |
No direct equivalent |
|
Alt+Down
arrow |
Display AutoComplete list |
None |
|
Alt+’ |
Format Style dialog box |
Format, Style |
|
Ctrl+Shift+~ |
General format |
Format, Cells, Number, Category,
General |
|
Ctrl+Shift+! |
Comma format |
Format, Cells, Number, Category,
Number |
|
Ctrl+Shift+@ |
Time format |
Format, Cells, Number, Category,
Time |
|
Ctrl+Shift+# |
Date format |
Format, Cells, Number, Category,
Date |
|
Ctrl+Shift+$ |
Currency format |
Format, Cells, Number, Category,
Currency |
|
Ctrl+Shift+% |
Percent format |
Format, Cells, Number, Category,
Percentage |
|
Ctrl+Shift+^ |
Exponential format |
Format, Cells, Number, Category, |
|
Ctrl+Shift+& |
Place outline border around selected
cells |
Format, Cells, Border |
|
Ctrl+Shift+_ |
Remove outline border |
Format, Cells, Border |
|
Ctrl+Shift+* |
Select current region |
Edit, Goto, Special, Current Region |
|
Ctrl++ |
Insert |
Insert, (Rows, Columns, or Cells)
Depends on selection |
|
Ctrl+- |
Delete |
Delete, (Rows, Columns, or Cells)
Depends on selection |
|
Ctrl+1 |
Format cells dialog box |
Format, Cells |
|
Ctrl+2 |
Bold |
Format, Cells, Font, Font Style,
Bold |
|
Ctrl+3 |
Italic |
Format, Cells, Font, Font Style,
Italic |
|
Ctrl+4 |
Underline |
Format, Cells, Font, Font Style,
Underline |
|
Ctrl+5 |
Strikethrough |
Format, Cells, Font, Effects,
Strikethrough |
|
Ctrl+6 |
Show/Hide objects |
Tools, Options, View, Objects, Show
All/Hide |
|
Ctrl+7 |
Show/Hide Standard toolbar |
View, Toolbars, Standard |
|
Ctrl+8 |
Toggle Outline symbols |
None |
|
Ctrl+9 |
Hide rows |
Format, Row, Hide |
|
Ctrl+0 |
Hide columns |
Format, Column, Hide |
|
Ctrl+Shift+( |
Unhide rows |
Format, Row, Unhide |
|
Ctrl+Shift+) |
Unhide columns |
Format, Column, Unhide |
|
Alt or
F10 |
Activate the menu |
None |
|
Ctrl+Tab |
In toolbar: next toolbar |
None |
|
Shift+Ctrl+Tab |
In toolbar: previous toolbar |
None |
|
Ctrl+Tab |
In a workbook: activate next
workbook |
None |
|
Shift+Ctrl+Tab |
In a workbook: activate previous workbook |
None |
|
Tab |
Next tool |
None |
|
Shift+Tab |
Previous tool |
None |
|
Enter |
Do the command |
None |
|
Shift+Ctrl+F |
Font Drop Down List |
Format, Cells, Font |
|
Shift+Ctrl+F+F |
Font tab of Format Cell Dialog box |
Format, Cells, Font |
|
Shift+Ctrl+P |
Point size Drop Down List |
Format, Cells, Font |
Microsoft Excel Shortcut Keys PDF Download Download Microsoft Excel Shortcut Keys
Microsoft Word | Shortcut Keys
Microsoft Excel Video Tutorials
Microsoft Office Online Test