Top 50 Excel Most Used shortcut KeyTop 50 Excel Most Used shortcut Key

Top 50 Excel Most Used shortcut Key Working Office Jobs in India 2023

Microsoft Excel is a widely used spreadsheet application in office jobs in India and around the world. Knowing Excel shortcuts can significantly improve your efficiency and productivity. Here are the top 50 Excel shortcuts that are commonly used in office jobs in India in 2023: Top 50 Excel Most Used shortcut Key

Basic Navigation:

  1. Ctrl + N: New Workbook
  2. Ctrl + O: Open Workbook
  3. Ctrl + S: Save Workbook
  4. Ctrl + P: Print Workbook
  5. Ctrl + C: Copy
  6. Ctrl + X: Cut
  7. Ctrl + V: Paste
  8. Ctrl + Z: Undo
  9. Ctrl + Y: Redo
  10. Ctrl + F: Find
  11. Ctrl + H: Replace
  12. Ctrl + A: Select All
  13. Ctrl + Arrow Keys: Navigate within data
  14. Ctrl + Space: Select entire column
  15. Shift + Space: Select entire row

Working with Worksheets and Workbooks:

  1. Ctrl + Page Up/Down: Switch between worksheets
  2. Ctrl + Tab: Switch between open workbooks
  3. Ctrl + W: Close Workbook
  4. Alt + E, S, V: Paste Special
  5. Alt + E, S, T: Transpose data

Editing Cells:

  1. F2: Edit active cell
  2. Ctrl + Enter: Enter data in multiple cells
  3. Alt + Enter: Start a new line within a cell
  4. Ctrl + ‘: Copy formula from cell above
  5. Ctrl + “: Copy value from cell above
  6. F4: Repeat last action
  7. Ctrl + Backspace: Go to the active cell
  8. Ctrl + –: Delete selected cells/rows/columns
Top 50 Excel Most Used shortcut Key
Top 50 Excel Most Used shortcut Key

Formatting Cells:

  1. Ctrl + 1: Format cells dialog box
  2. Ctrl + B: Bold
  3. Ctrl + I: Italic
  4. Ctrl + U: Underline
  5. Ctrl + 5: Strikethrough
  6. Ctrl + 9: Hide rows
  7. Ctrl + 0: Hide columns

Working with Formulas:

  1. Alt + =: AutoSum
  2. F4: Toggle cell reference (absolute/relative) in a formula
  3. Ctrl + Shift + L: Create or remove filter
  4. Ctrl + :: Enter current time
  5. Ctrl + ;: Enter current date

Data Manipulation:

  1. Alt + D, L: Create Data Validation
  2. Ctrl + Shift + +: Insert new row or column
  3. Ctrl + –: Delete selected rows or columns
  4. Ctrl + Shift + $: Apply currency format
  5. Ctrl + Shift + %: Apply percentage format

Working with Charts:

  1. F11: Create a chart
  2. Alt + F1: Add chart elements
  3. Ctrl + 1 (in chart): Format chart elements
  4. Alt + J, L, N, E: Navigate Chart Elements
Top 50 Excel Most Used shortcut Key
Top 50 Excel Most Used shortcut Key

Review and Collaboration:

  1. Alt + R, G: Track Changes

These shortcuts should help you work more efficiently in Microsoft Excel in various office jobs in India in 2023. Remember that practice and familiarity with these shortcuts will make you more proficient in Excel. Top 50 Excel Most Used shortcut Key

Important Link

Visit at – https://www.corelclass.com

Read Also it – https://msexcelclass.com/

Also, Read- Tally Course Fees, Duration, Scope, Syllabus, Admission, Institutes

Also Read – CCC Course Fees, Syllabus, Duration, Scope, Jobs, and Institute

Important Link – DFA Course Fees, Syllabus, Duration, Scope, Jobs, and Institute

Visit – https://mswordclass.com/

External Link

www.easytarika.com