MS Excel Complete Keyboard Shortcut PDF
Excel Shortcut Keys – Quick Reference
कंप्यूटर में शॉर्टकट की का प्रयोग किसी कमांड को तेजी से एवं आसानी से करने के लिए किया जाता है। विभिन्न की जैसे Alt, Ctrl, या Shift का अन्य की के साथ उपयोग करके इनका प्रयोग किया जाता है। जैसे "Ctrl+S" आपको Ctrl दबाकर और S को एक साथ दबाने पर इसे आसानी से प्रयोग किया जा सकता है।
| 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 | 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 | Redo | Edit, Repeat |
| Ctrl+Z | Undo | Edit, Undo |
| Ctrl+1 | Format Cells | 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, Underline, Single |
| Ctrl+5 | Strikethrough | Format, Cells, Font, Effects, Strikethrough |
| Ctrl+6 | Show or hide objects | Tools, Options, View, Objects |
| Ctrl+8 | Display or hide outline symbols | Data, Group and Outline, Settings |
| Ctrl+9 | Hide rows | Format, Row, Hide |
| Ctrl+0 (zero) | Hide columns | Format, Column, Hide |
| Ctrl+Shift+( | Unhide rows | Format, Row, Unhide |
| Ctrl+Shift+) | Unhide columns | Format, Column, Unhide |
| Ctrl+Shift+& | Apply outline border | Format, Cells, Border, Outline |
| Ctrl+Shift+_ | Remove outline border | Format, Cells, Border, None |
| Ctrl+Shift+~ | General format | Format, Cells, Number, General |
| Ctrl+Shift+! | Number format, two decimals, thousands separator | Format, Cells, Number |
| Ctrl+Shift+@ | Time format | Format, Cells, Number, Time |
| Ctrl+Shift+# | Date format | Format, Cells, Number, Date |
| Ctrl+Shift+$ | Currency format | Format, Cells, Number, Currency |
| Ctrl+Shift+% | Percentage format | Format, Cells, Number, Percentage |
| Ctrl+Shift+^ | Exponential format | Format, Cells, Number, Scientific |
| Ctrl+Shift+* | Select current region | Edit, Go To, Special, Current Region |
| Ctrl+Shift+Spacebar | Select entire worksheet | None |
| Ctrl+Spacebar | Select entire column | None |
| Shift+Spacebar | Select entire row | None |
| Ctrl+Shift+Arrow key | Extend selection to last nonblank cell | Edit, Go To, Special, Current Region |
| Ctrl+Arrow key | Move to edge of region | None |
| Shift+Arrow key | Extend selection by one cell | None |
| Alt+Enter | Start new line in same cell | None |
| F1 | Help | Help, Contents and Index |
| F2 | Edit | Edit, Repeat / Insert, Name, Define |
| F3 | Paste Name | Insert, Name, Paste |
| F4 | Repeat last action | Edit, Repeat. Works while not in Edit mode. |
| 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 | None |
| F11 | New Chart | Insert, Chart |
| F12 | Save As | File, Save As |
| 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 | 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++ | Insert | Insert, (Rows, Columns, or Cells) Depends on selection |
| Ctrl+- | Delete | Delete, (Rows, Columns, or Cells) Depends on selection |
| 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 |
Microsoft Excel Shortcut Keys PDF Download
माइक्रोसॉफ्ट एक्सेल ऑनलाइन टेस्ट | Microsoft Excel Online MCQ Test
माइक्रोसॉफ्ट एक्सेल टेस्ट – 01
Microsoft Excel Online Test - 01 माइक्रोसॉफ्ट एक्सेल टेस्ट – 02
Microsoft Excel Online Test - 02 माइक्रोसॉफ्ट एक्सेल टेस्ट – 03
Microsoft Excel Online Test - 03 माइक्रोसॉफ्ट एक्सेल टेस्ट – 04
Microsoft Excel Online Test - 04 माइक्रोसॉफ्ट एक्सेल टेस्ट – 05
Microsoft Excel Online Test - 05 माइक्रोसॉफ्ट एक्सेल टेस्ट – 06
Microsoft Excel Online Test - 06 माइक्रोसॉफ्ट एक्सेल टेस्ट – 07
Microsoft Excel Online Test - 07 माइक्रोसॉफ्ट एक्सेल टेस्ट – 08
Microsoft Excel Online Test - 08 माइक्रोसॉफ्ट एक्सेल टेस्ट – 09
Microsoft Excel Online Test - 09 माइक्रोसॉफ्ट एक्सेल टेस्ट – 10
Microsoft Excel Online Test - 10
Microsoft Excel Online Test - 01 माइक्रोसॉफ्ट एक्सेल टेस्ट – 02
Microsoft Excel Online Test - 02 माइक्रोसॉफ्ट एक्सेल टेस्ट – 03
Microsoft Excel Online Test - 03 माइक्रोसॉफ्ट एक्सेल टेस्ट – 04
Microsoft Excel Online Test - 04 माइक्रोसॉफ्ट एक्सेल टेस्ट – 05
Microsoft Excel Online Test - 05 माइक्रोसॉफ्ट एक्सेल टेस्ट – 06
Microsoft Excel Online Test - 06 माइक्रोसॉफ्ट एक्सेल टेस्ट – 07
Microsoft Excel Online Test - 07 माइक्रोसॉफ्ट एक्सेल टेस्ट – 08
Microsoft Excel Online Test - 08 माइक्रोसॉफ्ट एक्सेल टेस्ट – 09
Microsoft Excel Online Test - 09 माइक्रोसॉफ्ट एक्सेल टेस्ट – 10
Microsoft Excel Online Test - 10
