Excel Shortcuts

Excel Shortcuts

Vishal Sharrma Vishal Sharrma

Vishal Sharrma

Thought Leader | SIAM Consultantancy | Expert in Different Auxiliaries of Service Management | Client Satisfaction Champion | Leader in Driving Service Excellence and Process Optimization | Center of Excellence

发布日期: 2024年2月5日
+ 关注

Some highly useful MS Excel shortcuts applicable to a wide range of tasks:

Navigation and Selection:

Ctrl + C: Copy selected cell(s).

Ctrl + V: Paste copied cell(s).

Ctrl + X: Cut selected cell(s).

Ctrl + A: Select all cells in the active worksheet.

Home: Move to the beginning of the current row.

End: Move to the end of the current row/column (depending on selection).

Ctrl + Space: Select the entire current column.

Shift + Tab: Move to the cell to the left (opposite of Tab).

Editing and Formatting:

F2: Edit the content of the active cell.

Ctrl + Z: Undo the last action.

Bonus:

Ctrl + Enter: Fill selected cells with the content of the active cell.

Ctrl + Shift + &: Apply the number format to selected cells.

Ctrl + D: Fill down the content of the active cell to the cell below.

Ctrl + B: Apply bold formatting to selected cells.

Ctrl + I: Apply italic formatting to selected cells.

Ctrl + U: Apply underline formatting to selected cells.

Sharing Experience Sharing Experience

Sharing Experience

397 位关注者

订阅

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

Vishal Sharrma的更多文章

  • Bringing Dreams to Life: The Remarkable Journey of Interior Designer Sapnaa Sharrma
    2024年3月8日

    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
    2024年2月26日

    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?
    2024年2月7日

    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
    2024年2月7日

    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)
    2024年2月6日

    MS Excel Shortcuts (3)

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

  • MS Excel Shortcuts (2)
    2024年2月6日

    MS Excel Shortcuts (2)

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

  • Old v/s New Tax Regime
    2024年2月4日

    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
    2024年2月2日

    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
    2024年2月2日

    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
    2024年1月24日

    Personal Growth: Self SWOT Analysis

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

    1 条评论

社区洞察

其他会员也浏览了