Top 50 Excel Most Used shortcut Key Working Office Jobs

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:

Ctrl + N: New Workbook
Ctrl + O: Open Workbook
Ctrl + S: Save Workbook
Ctrl + P: Print Workbook
Ctrl + C: Copy
Ctrl + X: Cut
Ctrl + V: Paste
Ctrl + Z: Undo
Ctrl + Y: Redo
Ctrl + F: Find
Ctrl + H: Replace
Ctrl + A: Select All
Ctrl + Arrow Keys: Navigate within data
Ctrl + Space: Select entire column
Shift + Space: Select entire row

Working with Worksheets and Workbooks:

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

Editing Cells:

F2: Edit active cell
Ctrl + Enter: Enter data in multiple cells
Alt + Enter: Start a new line within a cell
Ctrl + ‘: Copy formula from cell above
Ctrl + “: Copy value from cell above
F4: Repeat last action
Ctrl + Backspace: Go to the active cell
Ctrl + –: Delete selected cells/rows/columns

Formatting Cells:

Ctrl + 1: Format cells dialog box
Ctrl + B: Bold
Ctrl + I: Italic
Ctrl + U: Underline
Ctrl + 5: Strikethrough
Ctrl + 9: Hide rows
Ctrl + 0: Hide columns

Working with Formulas:

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

Data Manipulation:

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

Working with Charts:

F11: Create a chart
Alt + F1: Add chart elements
Ctrl + 1 (in chart): Format chart elements
Alt + J, L, N, E: Navigate Chart Elements

Review and Collaboration:

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