MS Excel Shortcuts (3)

MS Excel Shortcuts (3)

Here are 10 more useful Excel shortcuts


Formula and Functions

F4: Absolute cell reference toggle (e.g., $A$1).

Ctrl + Enter: Enter an array formula (useful for complex calculations).

F9: Calculate all formulas in the workbook.

Ctrl + Shift + Enter: Create a named range.

F2: Edit a formula directly in the cell.


Charting and Visualization

Alt + F1: Create a chart from selected data.

Alt + H, C, C: Change the chart type.

Ctrl + Space: Add data labels to a chart.

Ctrl + Shift + F: Format chart elements.

Alt + H, F, N: Filter data points in a chart.


Macros and Automation

Alt + F11: Open the Visual Basic Editor (VBA) for creating macros.

Ctrl + R: Record a macro to automate repetitive tasks.

F5: Run a recorded macro.

Ctrl + Break: Stop a running macro.

Alt + F8: Manage and run existing macros.


More

Ctrl + Shift + K: Create a hyperlink to a website or file.

Ctrl + Enter in the formula bar to confirm a formula and return to the cell.

F12: Save As.

Ctrl + P: Print the active worksheet.

Ctrl + H: Find and Replace text and values.

要查看或添加评论,请登录

Vishal Sharrma的更多文章

  • Bringing Dreams to Life: The Remarkable Journey of Interior Designer Sapnaa Sharrma

    Bringing Dreams to Life: The Remarkable Journey of Interior Designer Sapnaa Sharrma

    On the International Women’s Day, I would like to mention and appreciate Interior Designer Sapnaa Sharrma for her…

    2 条评论
  • Spreadsheet Keys

    Spreadsheet Keys

    Utilizing keyboard shortcuts in Microsoft Excel often proves more efficient than relying solely on the trackpad or…

  • Challenging: The Transition From Legacy Skills to Acquiring New Ones?

    Challenging: The Transition From Legacy Skills to Acquiring New Ones?

    To reflect on the recent initiatives within IT Industry regarding skill development and career advancement…

  • Influence of AI and automation on SIAM & Service Management

    Influence of AI and automation on SIAM & Service Management

    Embracing the power of AI and automation offers numerous benefits. From streamlining service delivery processes to…

    1 条评论
  • MS Excel Shortcuts (2)

    MS Excel Shortcuts (2)

    Here are 10 more useful Excel shortcuts Data Manipulation Ctrl + Shift + L: Filter data based on criteria. Ctrl + Shift…

  • Excel Shortcuts

    Excel Shortcuts

    Some highly useful MS Excel shortcuts applicable to a wide range of tasks: Navigation and Selection: Ctrl + C: Copy…

  • Old v/s New Tax Regime

    Old v/s New Tax Regime

    India has two income tax regimes - The Old Tax Regime and The New Tax Regime. The introduction of two income tax…

  • Excel Essential Skills for Freelancers & All

    Excel Essential Skills for Freelancers & All

    Excel proficiency is a valuable skill set that opens doors to various opportunities in the freelancing world & Its…

    2 条评论
  • HRA Tax Exemption

    HRA Tax Exemption

    House Rent Allowance, commonly known as HRA, is a component of an employee's salary that may be fully or partially…

    2 条评论
  • Personal Growth: Self SWOT Analysis

    Personal Growth: Self SWOT Analysis

    In personal and professional development, the Self SWOT Analysis proved very powerful time and again, guiding…

    1 条评论

社区洞察

其他会员也浏览了