excel and word all shortcut keys

By / Uncategorized / Leave a Comment

 Excels keys

Basic Shortcuts:

  1. Ctrl + N: New workbook kholne ke liye.
  2. Ctrl + O: Existing workbook open karne ke liye.
  3. Ctrl + S: Workbook ko save karne ke liye.
  4. F12: "Save As" dialog box kholne ke liye.
  5. Ctrl + P: Print dialog box kholne ke liye.
  6. Ctrl + Z: Last action undo karne ke liye.
  7. Ctrl + Y: Last undone action redo karne ke liye.
  8. Ctrl + C: Copy selected cells.
  9. Ctrl + V: Paste copied cells.
  10. Ctrl + X: Cut selected cells.
  11. Ctrl + A: Select entire worksheet.
  12. Ctrl + F: Find box kholne ke liye.
  13. Ctrl + H: Find and Replace box kholne ke liye.
  14. Ctrl + Arrow Keys: Data ke end tak jump karne ke liye (up, down, left, right).
  15. Shift + Arrow Keys: Cells ko select karne ke liye.
  16. Ctrl + Space: Entire column select karne ke liye.
  17. Shift + Space: Entire row select karne ke liye.

Formatting Shortcuts:

  1. Ctrl + B: Bold text apply karne ke liye.
  2. Ctrl + I: Italics apply karne ke liye.
  3. Ctrl + U: Underline apply karne ke liye.
  4. Ctrl + 1: Format Cells dialog box open karne ke liye.
  5. Alt + H + H: Fill color menu kholne ke liye.
  6. Alt + H + B: Borders apply karne ke liye.
  7. Ctrl + Shift + $: Currency format apply karne ke liye.
  8. Ctrl + Shift + %: Percentage format apply karne ke liye.
  9. Ctrl + Shift + #: Date format apply karne ke liye.

Navigation and Selection Shortcuts:

  1. Ctrl + Home: Move to the beginning of the worksheet.
  2. Ctrl + End: Move to the last used cell.
  3. Ctrl + Page Down: Next worksheet par jane ke liye.
  4. Ctrl + Page Up: Previous worksheet par jane ke liye.
  5. Ctrl + Shift + Arrow Keys: Data block ko select karne ke liye.
  6. Shift + F11: New worksheet insert karne ke liye.
  7. Alt + Enter: Same cell mein new line insert karne ke liye.

Data Entry Shortcuts:

  1. Ctrl + ;: Current date insert karne ke liye.
  2. Ctrl + Shift + :: Current time insert karne ke liye.
  3. Ctrl + D: Upper cell ka data copy karne ke liye (fill down).
  4. Ctrl + R: Left cell ka data copy karne ke liye (fill right).
  5. Alt + Down Arrow: Drop-down list open karne ke liye.

Editing and Formula Shortcuts:

  1. F2: Active cell mein edit mode mein enter karne ke liye.
  2. Ctrl + Shift + L: Data par filter lagane ke liye.
  3. Alt + =: AutoSum function apply karne ke liye.
  4. Ctrl + ` (Grave Accent): Show all formulas in the worksheet.
  5. Shift + F3: Insert a function dialog box kholne ke liye.
  6. Ctrl + [: Jump to cell jahan se formula ki calculation aa rahi hai.
  7. Ctrl + Shift + Enter: Array formula apply karne ke liye.
  8. F4: Cell reference ko absolute/relative change karne ke liye ($ symbol add karne ke liye).

Advanced Shortcuts:

  1. Ctrl + Alt + V: Paste Special dialog box kholne ke liye.
  2. Alt + E + S + V: Values paste karne ke liye.
  3. Ctrl + T: Selected data ko Table mein convert karne ke liye.
  4. Alt + F1: Insert default chart.
  5. F11: Selected data par new chart create karne ke liye.
  6. Ctrl + Alt + F9: All formulas recalculate karne ke liye.
  7. Ctrl + K: Hyperlink insert karne ke liye.
  8. Ctrl + Alt + F5: Refresh all external data connections.
  9. Ctrl + Shift + K: Column hide karne ke liye.
  10. Ctrl + Shift + U: Formula bar expand/collapse karne ke liye.

Pivot Table Shortcuts:

  1. Alt + N + V: Create a Pivot Table.
  2. Alt + J + T + F: Field list ko show/hide karne ke liye.
  3. Alt + J + T + P: Pivot Table Options kholne ke liye.

Macro and Developer Shortcuts:

  1. Alt + F8: Macros dialog box kholne ke liye.
  2. Alt + F11: Visual Basic Editor kholne ke liye.
  3. Ctrl + Shift + F3: Name a range.

Word all shortcutr keys

Basic Shortcuts:

  1. Ctrl + N: New document create karne ke liye.
  2. Ctrl + O: Existing document open karne ke liye.
  3. Ctrl + S: Document ko save karne ke liye.
  4. F12: "Save As" dialog box kholne ke liye.
  5. Ctrl + P: Document ko print karne ke liye.
  6. Ctrl + W: Document ko close karne ke liye.
  7. Ctrl + Z: Last action undo karne ke liye.
  8. Ctrl + Y: Last undone action redo karne ke liye.
  9. Ctrl + C: Selected text ko copy karne ke liye.
  10. Ctrl + V: Copied text ko paste karne ke liye.
  11. Ctrl + X: Selected text ko cut karne ke liye.
  12. Ctrl + A: Poora document select karne ke liye.
  13. Ctrl + F: Document mein find dialog box open karne ke liye.
  14. Ctrl + H: Find and replace dialog box open karne ke liye.

Text Formatting Shortcuts:

  1. Ctrl + B: Bold text apply karne ke liye.
  2. Ctrl + I: Italicize text apply karne ke liye.
  3. Ctrl + U: Underline text apply karne ke liye.
  4. Ctrl + Shift + D: Double underline apply karne ke liye.
  5. Ctrl + Shift + W: Words par underline apply karne ke liye (without spaces).
  6. Ctrl + Shift + K: Small caps formatting apply karne ke liye.
  7. Ctrl + Shift + L: Bullet list apply karne ke liye.
  8. Ctrl + E: Text ko center align karne ke liye.
  9. Ctrl + L: Text ko left align karne ke liye.
  10. Ctrl + R: Text ko right align karne ke liye.
  11. Ctrl + J: Text ko justify karne ke liye.
  12. Ctrl + Shift + >: Text ko increase font size karne ke liye.
  13. Ctrl + Shift + <: Text ko decrease font size karne ke liye.
  14. Ctrl + D: Font formatting dialog box open karne ke liye.
  15. Ctrl + Shift + C: Formatting ko copy karne ke liye.
  16. Ctrl + Shift + V: Formatting ko paste karne ke liye.

Paragraph Formatting Shortcuts:

  1. Ctrl + M: Paragraph ko indent karne ke liye.
  2. Ctrl + Shift + M: Paragraph ka indent remove karne ke liye.
  3. Ctrl + T: Hanging indent apply karne ke liye.
  4. Ctrl + Shift + T: Hanging indent ko decrease karne ke liye.
  5. Ctrl + Q: Paragraph formatting reset karne ke liye (clear paragraph alignment).
  6. Ctrl + 1: Single line spacing apply karne ke liye.
  7. Ctrl + 2: Double line spacing apply karne ke liye.
  8. Ctrl + 5: 1.5 line spacing apply karne ke liye.
  9. Ctrl + Shift + J: Justify without hyphenation.
  10. Alt + Shift + Up/Down Arrow: Selected paragraph ko move up/down karne ke liye.

Navigation Shortcuts:

  1. Ctrl + Home: Document ke start par jump karne ke liye.
  2. Ctrl + End: Document ke end par jump karne ke liye.
  3. Ctrl + Left Arrow: Ek word piche move karne ke liye.
  4. Ctrl + Right Arrow: Ek word aage move karne ke liye.
  5. Ctrl + Up Arrow: Ek paragraph upar move karne ke liye.
  6. Ctrl + Down Arrow: Ek paragraph neeche move karne ke liye.
  7. Page Up/Page Down: Ek screen upar/neeche move karne ke liye.
  8. Alt + Ctrl + Z: Recent location par wapas jane ke liye.

Editing Shortcuts:

  1. Ctrl + Backspace: Ek word piche delete karne ke liye.
  2. Ctrl + Delete: Ek word aage delete karne ke liye.
  3. Ctrl + K: Hyperlink insert karne ke liye.
  4. Ctrl + Enter: New page insert karne ke liye (Page Break).
  5. Ctrl + Shift + Enter: Line break insert karne ke liye.
  6. Shift + F3: Toggle between uppercase, lowercase, and sentence case.
  7. Alt + Shift + D: Current date insert karne ke liye.
  8. Alt + Shift + T: Current time insert karne ke liye.

Table and Object Shortcuts:

  1. Tab: Next cell par move karne ke liye (table mein).
  2. Shift + Tab: Previous cell par move karne ke liye (table mein).
  3. Ctrl + Tab: Table mein tab character insert karne ke liye.
  4. Alt + Shift + Arrow Keys: Table rows/columns ko resize karne ke liye.
  5. Alt + Shift + F9: Field codes ko toggle karne ke liye (formulas or references in tables).

Reviewing Shortcuts:

  1. Ctrl + Alt + M: New comment insert karne ke liye.
  2. Ctrl + Shift + E: Track changes on/off karne ke liye.
  3. Alt + Shift + C: Reviewing pane open/close karne ke liye.
  4. F7: Spellcheck start karne ke liye.
  5. Shift + F7: Thesaurus open karne ke liye.

Advanced Shortcuts:

  1. Ctrl + F6: Next document window par move karne ke liye.
  2. Ctrl + Shift + F6: Previous document window par move karne ke liye.
  3. Alt + F8: Macros dialog box open karne ke liye.
  4. Alt + Ctrl + I: Print preview mode kholne ke liye.
  5. Ctrl + Alt + V: Paste Special dialog box open karne ke liye.
  6. Alt + Ctrl + F: Footnote insert karne ke liye.
  7. Alt + Ctrl + D: Endnote insert karne ke liye.