Excel Shortcut Keys : दोस्तों आज हम एक ऐसे विषय के बारे में बताने जा रहे हैं जो कि आमतौर पर सभी की जिंदगी में कभी ना कभी इस्तेमाल जरूर होता है; अगर हम बात करें युवाओं की या फिर उन लोगों की जो कि नौकरी तलाश रहे हैं, या नौकरी कर रहे हैं, तो उनकी रोजमर्रा की जिंदगी में Excel Software का इस्तेमाल बहुत आम हो गया है…
Summary Of Article
Show
Excel Shortcut Keys List – MS Excel Shortcuts And Formulas
Microsoft Excel एक ऐसा सॉफ्टवेयर है जो कि सभी व्यापार-व्यवसाय में डाटा एंट्री (Data-Entry) के लिए इस्तेमाल किए जाते हैं, अगर आपने Excel किसी कोचिंग से सीखा है, तो आप बहुत ही आसानी से एक सॉफ्टवेयर का इस्तेमाल कर पाएंगे, और अगर आप खुद ही Excel के सॉफ्टवेयर को सीख रहे हैं, तो आपके लिए हम Excel से जुड़ी हुई Shortcut Keys की List लेकर आए हैं..
For Excel Formulas :
2022 Useful Excel Formulas With Examples In Hindi
MS Excel Shortcut Keys PDF 2022 – Advance Excel Shortcut Keys PDF
अगर आप Excel Software के Shortcut Keys का PDF Download करना चाहते हैं, तो नीचे दिए गए लिंक पर क्लिक करें :
Excel Shortcut Keys PDF Free Download
Common Excel Shortcut Keys – All Excel Shortcuts PDF
| Shortcut Keys | Action | Menu |
| 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+X | Cut | Edit>>Cut |
| Ctrl+Y | Repeat | Edit>>Repeat |
| Ctrl+Z | Undo | Edit>>Undo |
Advanced Excel Shortcuts – Excel Shortcut Keys For Filter
| Shortcut Keys | Action | Menu |
| Alt or F10 | Activate the menu | None |
| Alt+’ | Format Style dialog box | Format>>Style |
| Alt+= | Auto Sum | No direct equivalent |
| Alt+Down arrow | Display Auto Complete list | None |
| Alt+F1 | Insert Chart | Insert>>Chart… |
| Alt+F11 | Visual Basic Editor | Tools>>Macro>>Visual Basic Editor |
| 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+Shift+F1 | New worksheet | Insert>>Worksheet |
| Alt+Shift+F2 | Save | File>>Save |
| Ctrl W | Close | File>>Close |
| Ctrl+’ | Copy Formula from Cell Above | Edit>>Copy |
| Ctrl+- | Delete | Delete(Rows, Columns, or Cells) Depends on selection |
| Ctrl+” | Copy Value from Cell Above | Edit>>Paste Special>>Value |
| Ctrl+: | Insert Current Time | None |
| Ctrl+; | Insert Current Date | None |
| Ctrl+` | Toggle Value/Formula display | Tools>>Options>>View>>Formulas |
| Ctrl++ | Insert | Insert(Rows, Columns, or Cells) Depends on selection |
| Ctrl+0 | Hide columns | Format>>Column>>Hide |
| 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 | Strike through | Format>>Cells>>Font>>Effects>>Strike through |
| 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+F10 | Maximize or restore window | XL>>Maximize |
| Ctrl+F11 | Inset 4.0 Macro sheet | None in Excel 97. In versions prior to 97 – Insert>>Macro 4.0 Macro |
| Ctrl+F12 | File Open | File>>Open |
| Ctrl+F3 | Define name | Insert>>Names>>Define |
| Ctrl+F4 | Close | File>>Close |
| Ctrl+F5 | XLRestore window size | Restore |
| Ctrl+F6 | Next workbook window | Window… |
| Ctrl+F7 | Move window | XL>>Move |
| Ctrl+F8 | Resize window | XL>>Size |
Ctrl+F9 |
Minimize workbook | XL>>Minimize |
| Ctrl+Shift+! | Comma format | Format>>Cells>>Number>>Category>>Number |
| 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+& | Place outline border around selected cells | Format>>Cells>>Border |
| Ctrl+Shift+( | Unhide rows | Format>>Row>>Unhide |
| Ctrl+Shift+) | Unhide columns | Format>>Column>>Unhide |
| Ctrl+Shift+* | Select current region | Edit>>Goto>>Special>>Current Region |
| Ctrl+Shift+@ | Time format | Format>>Cells>>Number>>Category>>Time |
| Ctrl+Shift+^ | Exponential format | Format>>Cells>>Number>>Category, |
| Ctrl+Shift+_ | Remove outline border | Format>>Cells>>Border |
| Ctrl+Shift+~ | General format | Format>>Cells>>Number>>Category>>General |
| Ctrl+Shift+A | Insert argument names into formula | No direct equivalent |
| Ctrl+Shift+F12 | File>>Print | |
| Ctrl+Shift+F3 | Create name by using names of row and column labels | Insert>>Name>>Create |
| Ctrl+Shift+F6 | Previous Window | Window |
| Ctrl+Tab | In toolbar: next toolbar | None |
| Ctrl+Tab | In a workbook: activate next workbook | None |
| Enter | Do the command | None |
Excel Functions Shortcut Keys – Basic Excel Shortcuts Pdf
| Shortcut Keys | Action | Menu |
| F1 | Help | Help>>Contents and Index |
| F10 | Activate Menu Bar | N/A |
| F11 | New Chart | Insert>>Chart |
| F12 | Save As | File>>Save As |
| 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 refs | 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 |
| Shift | Hold down shift for additional functions in Excel’s menu | 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+F6 | Previous workbook window | Window… |
| Shift+Ctrl+P | Point size Drop Down List | Format>>Cells>>Font |
| Shift+Ctrl+Tab | In toolbar: previous toolbar | None |
| Shift+Ctrl+Tab | In a workbook: activate previous workbook | None |
| Shift+F1 | What’s This? | Help>>What’s This? |
| Shift+F10 | Display shortcut menu | None |
| Shift+F11 | New worksheet | Insert>>Worksheet |
| Shift+F12 | Save | File>>Save |
| 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+Tab | Previous tool | None |
| Tab | Next tool | None |
Conclusion
तो दोस्तों यहां हमने आपको Excel Software से जुड़ी हुई सभी तरह की Shortcut Keys का विवरण दिया है और साथ ही हमने आपको | Excel Shortcut Keys PDF | भी उपलब्ध कराया है; आप आसानी से इसी पोस्ट से | Excel Shortcut Keys PDF Download | कर सकते हैं..
और अगर आपको Excel से जुड़े हुए कोई भी प्रश्न मन में है, तो आप हमें कमेंट करके जरूर बताएं, हम आपके प्रश्न का उत्तर जरूर देंगे…
Pingback: MS Word Shortcut Keys | MS Word Tips & Tricks – Kab Kaha Kaise
Pingback: MS Excel Formula with Examples In Hindi 2022 - Excel All Formula In Hindi