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 + &: Apply AutoSum to sum adjacent cells.

Alt + H, D, C: Delete the selected column.

Ctrl + T: Convert a range of cells into a formatted table.

Ctrl + F: Open the Find and Replace dialog box.

Formatting and Appearance

Ctrl + 1: Format cells as Number.

Ctrl + Shift + 4: Format cells as Currency.

Ctrl + Shift + %: Apply percentage formatting.

Alt + H, B, A: Add borders to selected cells.

Ctrl + Shift + F: Open the Format Cells dialog box for advanced formatting.

Bonus

Ctrl + Enter instead of Enter to move to the next cell in a data entry form.

F4: Repeat the last action (e.g., formatting, pasting).

Ctrl + PgUp/PgDn: Move between worksheets quickly.

F5: Go to a specific cell or named range.

Ctrl + ` (backtick): Toggle between showing cell formulas and their calculated 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 (3)

    MS Excel Shortcuts (3)

    Here are 10 more useful Excel shortcuts Formula and Functions F4: Absolute cell reference toggle (e.g.

  • 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 条评论

社区洞察

其他会员也浏览了