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
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
- Excel Macro To Insert Picture in Comment BoxExcel Macro To Insert Picture in Comment Box Excel เคฎเฅเค Picture เคเฅ Comment Popup (Note) เคเฅ เค เคเคฆเคฐ Insert...
- Excel VBA Visitor Enquiry Form Software Projects by Pradip VedantSriThis Workbook Code 'this is ThisWorkbook Code Private Sub Workbook_Open() Application.Visible = False UserForm1.Show vbModeless End Sub VBA...
- Download Free MS Excel Data Entry Invoice Projects | Pradip VedantSriDownload Free MS Excel Data Entry Invoice Projects | Pradip VedantSri Below are some of the most popular...