All Shortcuts of Excel Explain in Hindi

All Shortcuts of Excel Explain in Hindi  एक्सेल में सुपरफास्ट बनने के लिए कीबोर्ड पे आपका हाथ अच्छी तरह से बैठना चाहिए है अब कीबोर्ड पे...

All Shortcuts of Excel Explain in Hindi

 एक्सेल में सुपरफास्ट बनने के लिए कीबोर्ड पे आपका हाथ अच्छी तरह से बैठना चाहिए है अब कीबोर्ड पे हाथ बैठना याने शॉर्टकट कीज़ पे अच्छी कमांड होना और इसी के लिए ये है 101 Shortcut Keys

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 : Exntend 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 को आप अपने मोबाइल में डेस्कटॉप मोड विजिट कीजियेगा आशा है आप कमेंट करेंगे |

और ब्लॉग पढ़ने के लिए निचे लिंक्स दिए है क्लिक करे |

कंप्यूटर टिप्स   ||  एक्सेल टिप्स   ||  टैली टिप्स  ||  ऑटोकैड टिप्स  || वर्ड टिप्स || एक्सेल एग्जाम  ||  टैली एग्जाम


COMMENTS

BLOGGER: 7
  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


    ReplyDelete
    Replies
    1. just drag the plus sign from above cell that copies the formula.

      Delete
  2. Sir ye formula pdf me download karna tha to. Kaise hoga

    ReplyDelete
  3. Thank you sir., learn a lot from you

    ReplyDelete

Name

Auto-CAD Tips,7,Computer Tips,51,Coreldraw Tips,1,Excel tips in hindi,46,Ms-Word Tips in Hindi,6,MSCIT Exam Tips,11,Photoshop Tips,5,Tally ERP 9 Tips,8,Tech,2,
ltr
item
Learn More: All Shortcuts of Excel Explain in Hindi
All Shortcuts of Excel Explain in Hindi
https://i.ytimg.com/vi/qtul1DCv3CM/hqdefault.jpg
https://i.ytimg.com/vi/qtul1DCv3CM/default.jpg
Learn More
https://www.learnmoreindia.in/2019/11/all-shortcuts-of-excel-explain-in-hindi.html
https://www.learnmoreindia.in/
https://www.learnmoreindia.in/
https://www.learnmoreindia.in/2019/11/all-shortcuts-of-excel-explain-in-hindi.html
true
2228148344026858503
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy