all shortcut keys for Microsoft excel

  


  1. Ctrl + N: New Workbook 📊

    • Opens a new Excel workbook.


  1. Ctrl + O: Open Workbook 📂

    • Opens an existing Excel workbook.


  1. Ctrl + S: Save Workbook 💾

    • Saves the current Excel workbook.


  1. Ctrl + P: Print Workbook 🖨️

    • Opens the Print options for the workbook.


  1. Ctrl + C: Copy selected cells 📋

    • Copies the selected cells.


  1. Ctrl + X: Cut selected cells ✂️

    • Cuts the selected cells.


  1. Ctrl + V: Paste copied or cut cells 📋

    • Pastes the copied or cut cells.


  1. Ctrl + Z: Undo last action ↩️

    • Undoes the last action in Excel.


  1. Ctrl + Y: Redo last undone action ↪️

    • Redoes the last undone action in Excel.


  1. Ctrl + A: Select all cells 📊

    • Selects all cells in the current worksheet.


  1. Ctrl + B: Apply bold formatting to selected cells 🅱️

    • Applies bold formatting to the selected cells.


  1. Ctrl + I: Apply italic formatting to selected cells 🅸

    • Applies italic formatting to the selected cells.


  1. Ctrl + U: Apply underline formatting to selected cells 🅄

    • Applies underline formatting to the selected cells.


  1. Ctrl + F: Find 🔍

    • Opens the Find dialog box for searching text or values.


  1. Ctrl + H: Replace 🔍🔄

    • Opens the Replace dialog box for replacing text or values.


  1. Ctrl + Shift + "+": Insert new row or column 📊🆕

    • Inserts a new row above or a new column to the left of the selected cell.


  1. Ctrl + "-": Delete row or column 📊🗑️

    • Deletes the selected row or column.


  1. Ctrl + Shift + L: Toggle Filter 🔍🔄

    • Turns on/off the filter for the selected range.


  1. Ctrl + ;: Insert current date 📅

    • Inserts the current date in the selected cell.


  1. Ctrl + Shift + ": Insert current time ⌚

    • Inserts the current time in the selected cell.


  1. Ctrl + T: Create Table 📊🔄

    • Converts the selected range into a table.


  1. Ctrl + Shift + $: Apply currency format 💵

    • Applies the currency format to the selected cells.


  1. Ctrl + Shift + #: Apply date format 📅

    • Applies the date format to the selected cells.


  1. Ctrl + Shift + %: Apply percentage format %

    • Applies the percentage format to the selected cells.


  1. Alt + E, S, V: Paste Special 📋🎨

    • Opens the "Paste Special" dialog box.

📣 Disclaimer: Shortcut key functions may vary based on the version of Microsoft Excel and any customizations made.for the latest or specific information, please refer to the official Microsoft Excel documentation or help resources.

🔗 Source: Microsoft Office Support: https://support.microsoft.com/

 

  1. Ctrl + N: New Workbook 📊

    • Opens a new Excel workbook.


  1. Ctrl + O: Open Workbook 📂

    • Opens an existing Excel workbook.


  1. Ctrl + S: Save Workbook 💾

    • Saves the current Excel workbook.


  1. Ctrl + P: Print Workbook 🖨️

    • Opens the Print options for the workbook.


  1. Ctrl + C: Copy selected cells 📋

    • Copies the selected cells.


  1. Ctrl + X: Cut selected cells ✂️

    • Cuts the selected cells.


  1. Ctrl + V: Paste copied or cut cells 📋

    • Pastes the copied or cut cells.


  1. Ctrl + Z: Undo last action ↩️

    • Undoes the last action in Excel.


  1. Ctrl + Y: Redo last undone action ↪️

    • Redoes the last undone action in Excel.


  1. Ctrl + A: Select all cells 📊

    • Selects all cells in the current worksheet.


  1. Ctrl + B: Apply bold formatting to selected cells 🅱️

    • Applies bold formatting to the selected cells.


  1. Ctrl + I: Apply italic formatting to selected cells 🅸

    • Applies italic formatting to the selected cells.


  1. Ctrl + U: Apply underline formatting to selected cells 🅄

    • Applies underline formatting to the selected cells.


  1. Ctrl + F: Find 🔍

    • Opens the Find dialog box for searching text or values.


  1. Ctrl + H: Replace 🔍🔄

    • Opens the Replace dialog box for replacing text or values.


  1. Ctrl + Shift + "+": Insert new row or column 📊🆕

    • Inserts a new row above or a new column to the left of the selected cell.


  1. Ctrl + "-": Delete row or column 📊🗑️

    • Deletes the selected row or column.


  1. Ctrl + Shift + L: Toggle Filter 🔍🔄

    • Turns on/off the filter for the selected range.


  1. Ctrl + ;: Insert current date 📅

    • Inserts the current date in the selected cell.


  1. Ctrl + Shift + ": Insert current time ⌚

    • Inserts the current time in the selected cell.


  1. Ctrl + T: Create Table 📊🔄

    • Converts the selected range into a table.


  1. Ctrl + Shift + $: Apply currency format 💵

    • Applies the currency format to the selected cells.


  1. Ctrl + Shift + #: Apply date format 📅

    • Applies the date format to the selected cells.


  1. Ctrl + Shift + %: Apply percentage format %

    • Applies the percentage format to the selected cells.


  1. Alt + E, S, V: Paste Special 📋🎨

    • Opens the "Paste Special" dialog box.

📣 Disclaimer: Shortcut key functions may vary based on the version of Microsoft Excel and any customizations made.for the latest or specific information, please refer to the official Microsoft Excel documentation or help resources.

🔗 Source: Microsoft Office Support: https://support.microsoft.com/


Post a Comment (0)
Previous Post Next Post