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 को आप अपने मोबाइल में डेस्कटॉप मोड विजिट कीजियेगा आशा है आप कमेंट करेंगे |
और ब्लॉग पढ़ने के लिए निचे लिंक्स दिए है क्लिक करे |
कंप्यूटर टिप्स || एक्सेल टिप्स || टैली टिप्स || ऑटोकैड टिप्स || वर्ड टिप्स || एक्सेल एग्जाम || टैली एग्जाम
- Advertisement -
nice one sir
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
Sir ye formula pdf me download karna tha to. Kaise hoga
Thank you sir., learn a lot from you
just drag the plus sign from above cell that copies the formula.
Great work dear
thank
you
how can I download it
Sir ye formula pdf me download karna tha to. Kaise hoga
Heya i am for the first time here. I found this board and I find It truly useful & it helped me out much.
I hope to give something back and aid others like you aided me.
Great beat ! I wish to apprentice while you amend your website, how can i subscribe
for a blog website? The account helped me a acceptable deal.
I had been a little bit acquainted of this your broadcast provided bright clear idea