जाने कुछ एक्सेल शॉर्टकट कुंजियों के बारे में (Learn About Excel Function Shortcut Keys)
Table Of Contents
Excel shortcut keys list pdf download free
Excel shortcut keys list pdf download free: दोस्तों में तुम सबको ये बताना चाहता हु की आज कल किसी भी छेत्र में या Bissness में या Office के work में ज्यादातर Use में लिया जाता हे क्योंकी excel एक मात्र ऐसा हे जिसने तुम अपना काम आसानी से और काफी जल्दी कर सकते हो अगर आपको excel आता हे ये मायने नहीं रखता आपको excel के बारे कुछ Basic Information भी आनी चाहिये जैसे बताना चहाता हूँ की Excel में आपको shortcut key और formulas
इसके आलावा आपको function key भी आनी चाहये ! क्युकी अगर आप ये सब कुछ आता हे और आप कही अपनी new job के Interview के लिए जाते हो तो तुमको ये सब कुछ आता हे तो फिर तुम्हारा Slection जरूर हो जायेगा और यदि तुम आपने खुद का कुछ bissness start करते हो तो ये और भी अच्छी बात हे तुम कर सकते हो किसी और को तुम्हे ढूढ़ने की जरूत नहीं हे तुम आपने काम sefty कर सकते हो ! इसलिए में आप सबको ये बताना चाहता हु की Microsoft ने एक्सेल को बना कर हम सब का काम बहुत आसान कर दिया Excel shortcut keys list pdf download free below the artical.
Excel function shortcut keys
- General Keya of excel
Shortcut key | Action |
Ctrl+A | Select All |
Ctrl+B | Bold |
Ctrl+C | Copy |
Ctrl+D | Fill Down |
Ctrl+F | Find |
Ctrl+G | Goto |
Ctrl+H | Replace |
Ctrl+I | Italic |
Ctrl+K | Insert Hyperlink |
Ctrl+N | New Workbook |
Ctrl+O | Open |
Ctrl+P | |
Ctrl+R | Fill Right |
Ctrl+S | Save |
Ctrl+U | Underline |
Ctrl+V | Paste |
Ctrl W | Close |
Ctrl+X | Cut |
Ctrl+Y | Repeat |
Ctrl+Z | Undo |
F1 | Help |
F2 | Edit |
F3 | Paste Name |
F4 | Repeat the last action |
F4 | While typing a formula, switch between absolute/relative refs |
F5 | Goto |
F6 | Next Pane |
F7 | Spell check |
F8 | Extend mode |
F9 | Recalculate all workbooks |
F10 | Activate Menubar |
F11 | New Chart |
F12 | Save As |
Ctrl+: | Insert Current Time |
Ctrl+; | Insert Current Date |
Ctrl+" | Copy Value from Cell Above |
Ctrl+’ | Copy Formula from Cell Above |
Shift | Hold down shift for additional functions in Excel’s menu |
Shift+F1 | What’s This? |
Shift+F2 | Edit cell comment |
Shift+F3 | Paste function into the formula |
Shift+F4 | Find Next |
Shift+F5 | Find |
Shift+F6 | Previous Pane |
Shift+F8 | Add to selection |
Shift+F9 | Calculate active worksheet |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
Ctrl+Alt+Shift+F9 | Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
Shift+F10 | Display shortcut menu |
Shift+F11 | New worksheet |
Shift+F12 | Save |
Ctrl+F3 | Define name |
Ctrl+F4 | Close |
Ctrl+F5 | XL, Restore window size |
Ctrl+F6 | Next workbook window |
Shift+Ctrl+F6 | Previous workbook window |
Ctrl+F7 | Move window |
Ctrl+F8 | Resize window |
Ctrl+F9 | Minimize workbook |
Ctrl+F10 | Maximize or restore window |
Ctrl+F11 | Inset 4.0 Macro sheet |
Ctrl+F12 | File Open |
Alt+F1 | Insert Chart |
Alt+F2 | Save As |
Alt+F4 | Exit |
Alt+F8 | Macro dialog box |
Alt+F11 | Visual Basic Editor |
Ctrl+Shift+F3 | Create name by using names of row and column labels |
Ctrl+Shift+F6 | Previous Window |
Ctrl+Shift+F12 | |
Alt+Shift+F1 | New worksheet |
Alt+Shift+F2 | Save |
Alt+= | AutoSum |
Ctrl+` | Toggle Value/Formula display |
Ctrl+Shift+A | Insert argument names into the formula |
Alt+Down arrow | Display AutoComplete list |
Alt+’ | Format Style dialog box |
Ctrl+Shift+~ | General format |
Ctrl+Shift+! | Comma format |
Ctrl+Shift+@ | Time format |
Ctrl+Shift+# | Date format |
Ctrl+Shift+$ | Currency format |
Ctrl+Shift+% | Percent format |
Ctrl+Shift+^ | Exponential format |
Ctrl+Shift+& | Place outline border around selected cells |
Ctrl+Shift+_ | Remove outline border |
Ctrl+Shift+* | Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report. |
Ctrl++ | Insert |
Ctrl+- | Delete |
Ctrl+1 | Format cells dialog box |
Ctrl+2 | Bold |
Ctrl+3 | Italic |
Ctrl+4 | Underline |
Ctrl+5 | Strikethrough |
Ctrl+6 | Show/Hide objects |
Ctrl+7 | Show/Hide Standard toolbar |
Ctrl+8 | Toggle Outline symbols |
Ctrl+9 | Hide rows |
Ctrl+0 | Hide columns |
Ctrl+Shift+( | Unhide rows |
Ctrl+Shift+) | Unhide columns |
Alt or F10 | Activate the menu |
Ctrl+Tab | In toolbar: next toolbar |
In a workbook: activate next workbook | None |
Shift+Ctrl+Tab | In toolbar: previous toolbar |
In a workbook: activate the previous workbook | None |
Tab | Next tool |
Shift+Tab | Previous tool |
Enter | Do the command |
Alt+Enter | Start a new line in the same cell. |
Ctrl+Enter | Fill the selected cell range with the current entry. |
Shift+Ctrl+F | Font Drop Down List |
Shift+Ctrl+F+F | Font tab of Format Cell Dialog box |
Shift+Ctrl+P | Point size Drop Down List |
Ctrl+Spacebar | Select the entire column |
Shift+Spacebar | Select the entire row |
CTRL+/ | Select the array containing the active cell. |
CTRL+SHIFT+O | Select all cells that contain comments. |
CTRL+\ | In a selected row, select the cells that don’t match the formula or static value in the active cell. |
CTRL+SHIFT+| | In a selected column, select the cells that don’t match the formula or static value in the active cell. |
CTRL+[ | Select all cells directly referenced by formulas in the selection. |
CTRL+SHIFT+{ | Select all cells directly or indirectly referenced by formulas in the selection. |
CTRL+] | Select cells that contain formulas that directly reference the active cell. |
CTRL+SHIFT+} | Select cells that contain formulas that directly or indirectly reference the active cell. |
ALT+; | Select the visible cells in the current selection. |
SHIFT+BACKSPACE | With multiple cells selected, select only the active cell. |
CTRL+SHIFT+SPACEBAR | Selects the entire worksheet. |
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. | |
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet | |
Ctrl+Alt+L | Reapply the filter and sort on the current range so that changes you've made are included |
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. |
Excel shortcut keys list pdf download free