Learn More

101 ЁЯШп Shortcuts of Excel Explain in Hindi | Excel Shortcut Keys Download PDF

рдПрдХреНрд╕реЗрд▓ рдореЗрдВ рд╕реБрдкрд░рдлрд╛рд╕реНрдЯ рдмрдирдиреЗ рдХреЗ рд▓рд┐рдП рдХреАрдмреЛрд░реНрдб ( Shortcuts of Excel) рдкреЗ рдЖрдкрдХрд╛ рд╣рд╛рде рдЕрдЪреНрдЫреА рддрд░рд╣ рд╕реЗ рдмреИрдардирд╛ рдЪрд╛рд╣рд┐рдП рд╣реИред рдЕрдм рдХреАрдмреЛрд░реНрдб рдкреЗ рд╣рд╛рде рдмреИрдардирд╛ рдпрд╛рдирд┐ рд╢реЙрд░реНрдЯрдХрдЯ рдХреАрдЬрд╝ (Excel Shortcut Keys) рдкреЗ рдЕрдЪреНрдЫреА рдХрдорд╛рдВрдб рд╣реЛрдирд╛ред

рдФрд░ рдЗрд╕реА рдХреЗ рд▓рд┐рдП рдЖрдЬ рдХреЗ рдЗрд╕ рдЖрд░реНрдЯрд┐рдХрд▓ рдореЗ рд╣рдо рдЖрдкрдХреЛ Excel shortcut Keys рдмрддрд╛рдиреЗ рд╡рд╛рд▓реЗ рд╣реИ рдФрд░ рд╡реЛ 101 ЁЯШп Shortcuts of Excel Explain in Hindiред

рдЗрд╕рдХреЗ рдЕрд▓рд╛рд╡рд╛ рдЖрдк рдЪрд╛рд╣реЗ рддреЛ рдЗрди 101 ЁЯШп Shortcuts of Excel Explain in Hindi рдХрд╛ PDF рдиреЛрдЯреНрд╕ рднреА рдбрд╛рдЙрдирд▓реЛрдб рдХрд░ рд╕рдХрддреЗ рд╣реИ рдЬрд┐рд╕рдХреА рд▓рд┐рдВрдХ рдиреАрдЪреЗ рджреА рдЧрдИ рд╣реИред

101 Shortcut of Excel in Hindi | Excel Shortcut in Hindi

Ctrl + E – Flash Fill  

Ctrl+Page Up/Down: Move to the previous or next worksheet  

Shift+Left/Right Arrow: Extend the cell selection to the left or right  

Shift+Space: Select the entire row  

Ctrl+Space: Select the entire column  

Ctrl+Shift+Space: Select the entire worksheet  

Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)  

Ctrl+Home: Move to the beginning of a worksheet  

Ctrl+End: Go to the most bottom right used cell  

Page Up/Down: Move one screen up or down in a worksheet  

Alt+Page Up/Down: Move one screen to the right or left in a worksheet  

F8: Extend Selection  

Ctrl+W  / CTRL + F4: Close a workbook  (Alt + Space + C)  

F4: Repeat the last command or action. For example, if the last thing you typed in a cell is тАЬhello,тАЭ or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.  

Shift+F11: Insert a new worksheet  

Ctrl+Z: Undo an action  

Ctrl+Y: Redo an action  

Ctrl+N: Create a new workbook  

Ctrl+O: Open an existing workbook  

Ctrl+S: Save a workbook  

F12: Open the Save As dialog box  

Ctrl+ P: Print / Print Preview  

F1: Open the Help pane  

F7: Check spelling  

F9: Calculate all worksheets in all open workbooks  

Alt + V + Z : Zoom in / Zoom Out  

Alt or F10: Turn key tips on or off  

Ctrl+F1: Show or hide the ribbon  

Ctrl+Shift+U: Expand or collapse the formula bar  

Ctrl+F9: Minimize the workbook window  

F11: Create a bar chart based on selected data (on a separate sheet)  

Alt+F1: Create an embedded bar chart based on select data (same sheet)  

Ctrl+F: Search in a spreadsheet, or use Find and Replace  

Alt+F: Open the File tab menu  

Alt+H: Go to the Home tab  

Ctrl+Tab: Switch between open workbooks  

Shift+F3: Insert a function  

Alt+F8: Create, run, edit, or delete a macro  

Alt+F11: Open the Microsoft Visual Basic For Applications Editor  

Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row  

Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column  

Tab = Goto the Next cell  &

Shift+Tab: Go to the previous cell  

F5 or CTRL + G: Go to any cell by pressing F5 and typing the cell coordinate or cell name.  

F2: Edit a cell  

Shift+F2: Add or edit a cell comment  

Ctrl+X: Cut contents of a cell, selected data, or selected cell range  

Ctrl+C or Ctrl+Insert: Copy contents of a cell, selected data, or selected cell range  

Ctrl+V or Shift+Insert: Paste contents of a cell, selected data, or selected cell range  

Ctrl+Alt+V: Open the Paste Special dialog box  

Alt+Enter: Insert a hard return within a cell (while editing a cell)  

F3: Paste a cell name (if cells are named in the worksheet)  

Esc: Cancel an entry in a cell or the formula bar  

Enter: Complete the Formula / Paste Content if already copied  

Alt+H+H: Select a fill color  

Alt+H+B: Add a border  

Ctrl+Shift+&: Apply outline border  

Ctrl+Shift+_ (Underscore): Remove outline border  

Ctrl+9: Hide the selected rows  

Ctrl + Shift + 9 : Unhide Rows  

Ctrl+0: Hide the selected columns  

Ctrl+1: Open the Format Cells dialog box  

Ctrl+5: Apply or remove strike through  

Ctrl+Shift+$: Apply currency format  

Ctrl+Shift+%: Apply percent format  

Ctrl+Shift+#: Apply Date format  

Ctrl+Shift+@: Apply Time format  

Ctrl+Shift+!: Apply Number format  

Ctrl+Shift+ ~: Apply General format  

Ctrl+ ‘ : Copy Above Content to Fill below  

Ctrl + D = Fill Down  

Ctrl + R – Fill Right  

Ctrl + F3 = Name Manager  

Ctrl  + F10 = Restore Window or Alt + Space + R  

Alt + Space + X – Maximize  or Ctrl + F10 – Restore  

Ctrl + F9 – Minimize  / Alt + Tab – Maximize / Switch  

Ctrl + F11 – Insert Macro Name Sheet  

Ctrl  + F12 = Open Dialog box  

Ctrl + Shift + F1 – Hide Tab and Ribbon  

Alt + V + U – Full Screen  

Ctrl + Shift + F3 – Create Names from Selection  

Alt + H + W – Wrap Text  

Ctrl + Shift + Page Down / Page up – Select All Sheets to the right / Left  

Ctrl + ; – Insert Date  

Ctrl + Shift + ; – Insert Time  

Ctrl + T – Create Table or Ctrl + L  

Alt + H + O + R – Rename Sheet  

Ctrl + H – Replace  

Ctrl + K – Hyperlink  

Ctrl + Shift + {  – Select all cells which involved in selected formula  

Ctrl + Shift + }  – Select Formula cells where selected cell in included  

Ctrl  + Shift + A – Insert Argument Names into a Formula  

Alt + A + T – Apply and Remove Filter  

ALT + N + V – PIVOT TABLE  

ALT + = : AutotSum  

ALT + H +M + C – MERGE AND CENTER  

CTRL  + ~ = Show and Hide All formulas from sheet  

CTRL + SHIFT + ENTER – Create Array  

Alt + A + Q – Advance Filter    

Alt + H + O + I – Auto-fit Column Width  

Alt + H + FP – Format Painter  

Alt + H + E + F – Clear Format  

Ctrl + + – Insert Column / Row

Ctrl  + –  = Delete Row / Column

Alt + I + R – Insert Row

Alt + I + C – Insert Column

рддреЛ рдЗрд╕ рдореЗрдВ рдмрддрд╛рдИ рд╣реБрдИ рдпреЗ EXCEL TIPS рдЖрдкрдХреЛ рдкрд╕рдВрдж  рдЖрдпреА рд╣реЛрдЧреА рддреЛ рдмрд╕ рдХрдореЗрдВрдЯ рдХрд░рдХреЗ рдмрддрд╛рдИрдпреЗред COMMENT рдХрд░рдиреЗ рдХреЗ рд▓рд┐рдП рдЗрд╕ WEBSITE рдХреЛ рдЖрдк рдЕрдкрдиреЗ рдореЛрдмрд╛рдЗрд▓ рдореЗрдВ рдбреЗрд╕реНрдХрдЯреЙрдк рдореЛрдб рд╡рд┐рдЬрд┐рдЯ рдХреАрдЬрд┐рдпреЗрдЧрд╛ рдЖрд╢рд╛ рд╣реИ рдЖрдк рдХрдореЗрдВрдЯ рдХрд░реЗрдВрдЧреЗ |

рдФрд░ рдмреНрд▓реЙрдЧ рдкрдврд╝рдиреЗ рдХреЗ рд▓рд┐рдП рдирд┐рдЪреЗ рд▓рд┐рдВрдХреНрд╕ рджрд┐рдП рд╣реИ рдХреНрд▓рд┐рдХ рдХрд░реЗ |

Download – 101 Shortcuts of Excel in Hindi

Download PDF Notes of Excel Shortcut Keys

Watch Video: 101 Excel Shortcuts Keys that will help to increase your Excel speed

101 Excel Shortcuts Keys that will help to increase your Excel speed

Conclusion: рдЕрдкрдиреЗ рдХреНрдпрд╛ рд╕реАрдЦрд╛?

рддреЛ рдореИрдВ рдЙрдореНрдореАрдж рдХрд░рддрд╛ рд╣реБ рдХрд┐ рдЖрдЬ рдХреЗ рдЗрд╕ EXCEL TIPS рдХреЗ рдЖрд░реНрдЯрд┐рдХрд▓ рдореЗ рдмрддрд╛рдП рдЧрдП 101 Shortcuts of Excel рдЖрдкрдХреЛ рдкрд╕рдВрдж рдЖрдпреА рд╣реЛрдЧреАред рддреЛ рдмрд╕ рдХрдореЗрдВрдЯ рдХрд░рдХреЗ рдмрддрд╛рдИрдпреЗред рдФрд░ рдЗрд╕реА рддрд░рд╣ рдХреЗ рдирдП рдирдП рдЖрд░реНрдЯрд┐рдХрд▓ рдХреЗ рдиреЛрдЯрдлрдХреИрд╢рди рдХреЗ рд▓рд┐рдП рд╣рдорд╛рд░реА рдЗрд╕ рд╡реЗрдмрд╕рд╛рдИрдЯ рдХреЛ рд╕рдмрд╕реНрдХреНрд░рд╛рдЗрдм рдХрд░реЗрдВред

рдЖрдкрдХреЛ Excel рдХреЗ рд╕рд╛рде рдФрд░ рднреА рдЕрд▓рдЧ рдЕрд▓рдЧ рдЯреЙрдкрд┐рдХ рдХреЗ рдЙрдкрдпреЛрдЧреА рдФрд░ рдордЬреЗрджрд╛рд░ рдмреНрд▓реЙрдЧ рдкрдврд╝рдиреЗ рдХреЗ рд▓рд┐рдП рдирд┐рдЪреЗ рд▓рд┐рдВрдХреНрд╕ рджрд┐рдП рд╣реИ рдЖрдк рдЗрди рд▓рд┐рдВрдХреНрд╕ рдкреЗ рдХреНрд▓рд┐рдХ рдХрд░рдХреЗ рднреА рд╣рд░ рдЯреЙрдкрд┐рдХ рдХреЗ рдЕрд▓рдЧ рдЕрд▓рдЧ рдмреНрд▓реЙрдЧреНрд╕ рдкрдврд╝ рд╕рдХрддреЗ рд╣реИред

рджреЛрд╕реНрддреЛрдВ рдЕрдЧрд░ рдЖрдк рднреА рдЦреБрдж рдХреЛ Excel рд╕реНрдорд╛рд░реНрдЯ рдФрд░ рдкреНрд░реЛ рдмрдирд╛рдирд╛ рдЪрд╛рд╣рддреЗ рд╣реИ рддреЛ рдЖрдкрдХреЛ Excel рдХрд╛ Excel Basic To Advance course in Hindi Enroll рдХрд░рдирд╛ рдЪрд╛рд╣рд┐рдП рдЬреЛ рд▓рдЧрднрдЧ 60% рдбрд┐рд╕реНрдХрд╛рдЙрдВрдЯ рдХреЗ рд╕рд╛рде рдЪрд▓ рд░рд╣реЗ рд╣реИ рдФрд░ рдЖрдк рдЗрд╕рдореЗ рдЕрдбреНрд╡рд╛рдиреНрд╕ рдЯреЙрдкрд┐рдХ рдХреЛ рд╕реАрдЦрддреЗ рд╣реИ, рд╡реЛ рднреА рдкреВрд░реА рдкреНрд░реИрдХреНрдЯрд┐рд╕ рдлрд╛рдЗрд▓ рдХреЗ рд╕рд╛рдеред

рддреЛ рдЬрд░реВрд░ рдПрдХ рдмрд╛рд░┬аLearn More Pro┬ардкреЗ рдЬрд╛рдП рдпрд╛ рдлрд┐рд░┬аLearn More App┬ардХреЛ рдбрд╛рдЙрдирд▓реЛрдб рдХрд░реЗрдВ рдФрд░ рдХреЛрд░реНрд╕ рдХреЛ рдЬрд░реВрд░ рдЪреЗрдХ рдХрд░реЗрдВред

Spread the love

14 thoughts on “101 ЁЯШп Shortcuts of Excel Explain in Hindi | Excel Shortcut Keys Download PDF”

  1. sir thanks for educational videos

    Here is some problem in my budget sheet
    how to auto apply/copy above formula when insert row.
    for add other item

    Reply
  2. just drag the plus sign from above cell that copies the formula.

    Reply
  3. Simply great knowledge… thanks a lot Satish sir..

    Reply
  4. Very nice sir,
    This is a good website for us, your every content is very good and you are also good sir
    Thank you so much sir

    Reply
  5. Sir i have just seen this website and found it very useful for any student who wants master in computer
    But my concern is this that whatever I have seen or got through, every thing or explanation is in handi language which I am not able to understand
    So please sir can u translate this in English also

    Reply
    • Thank you Mudasir for your feedback, soon we will also start the English section of this article.

      Reply

Leave a Comment