All Shortcut Keys of Computer A to Z Excel That You Should Know in 2023

In today’s fast-paced world, efficiency is the key to success, and this holds true in the realm of computing. Microsoft Excel, a spreadsheet software application, is one of the most widely used tools for data analysis, reporting, and much more. To harness the full power of Excel, it’s essential to master its shortcut keys. In this comprehensive guide, we’ll delve into all the shortcut keys of computer A to Z in Excel, and by the end of this article, you’ll have a vast arsenal of time-saving tricks at your disposal.

Let’s dive in and explore the world of Microsoft Excel shortcut keys, uncovering hidden gems that can significantly boost your productivity.

You May Also Like:

Computer Shortcut Keys – Know About All Shortcut Keys Here!

GTA 6 Rockstar Game: Everything You Need to Know

10 Ideas for Enhancing Your Life Management with Khojo Mat

Vedic Mathematics: Unlocking the Power of Ancient Indian

1. What is Microsoft Excel?

Before we dive into the world of Excel shortcut keys, let’s briefly cover what Microsoft Excel is. Excel is a powerful spreadsheet software developed by Microsoft. It allows users to perform a wide range of tasks, including data entry, data analysis, calculation, and creating charts and graphs. Whether you’re a student, a professional, or a data enthusiast, Excel is an invaluable tool.

Microsoft Excel is known for its user-friendly interface, but you can take your efficiency to the next level by learning and using keyboard shortcuts. These shortcuts allow you to perform various tasks without having to navigate through menus and ribbons, saving you time and reducing the risk of repetitive strain injuries.

2. Workbook Shortcut Keys

Excel workbooks are at the heart of your data management. Knowing the right shortcut keys can make working with workbooks a breeze.

Ctrl + N: Create a new workbook.

Ctrl + O: Open an existing workbook.

Ctrl + S: Save the current workbook.

Ctrl + P: Print the current workbook.

Ctrl + F12: Open the “Save As” dialog box.

Ctrl + W: Close the current workbook.

Ctrl + F4: Close Excel.

Ctrl + Z: Undo the last action.

Ctrl + Y: Redo the last action.

Ctrl + F: Open the “Find” dialog box.

These shortcuts are just the tip of the iceberg when it comes to working with Excel workbooks. Familiarizing yourself with these shortcuts will help you manage your workbooks more efficiently.

3. Cell Formatting Shortcut Keys

Formatting cells in Excel is crucial for making your data more presentable and understandable. Here are some essential cell formatting shortcut keys:

Ctrl + 1: Open the Format Cells dialog box. Ctrl + B: Apply or remove bold formatting. Ctrl + I: Apply or remove italic formatting. Ctrl + U: Apply or remove underline formatting. Ctrl + 5: Apply or remove strikethrough formatting. Alt + H, H: Change the font color. Alt + H, B: Add a border around the selected cells.

These shortcuts will help you format your data quickly and efficiently, making your spreadsheets more visually appealing and easier to read.

4. Row and Column Formatting Shortcut Keys

When working with large datasets, managing rows and columns efficiently can be a game-changer. Here are some essential shortcut keys for row and column formatting:

Ctrl + Space: Select the entire column.

Shift + Space: Select the entire row.

Ctrl + –: Delete selected rows or columns.

Ctrl + 1: Format cells in a selected range.

Alt + E, S, V: Paste special values.

Alt + E, S, T: Transpose data.

These shortcuts will help you quickly format, delete, and manipulate rows and columns, saving you time and reducing the risk of errors.

5. All Computer A to Z Excel Shortcut Keys

Let’s explore the most comprehensive list of Excel shortcut keys, from A to Z, that can streamline your work in Excel:

• Ctrl + A: Select all cells in the current worksheet.
• Ctrl + B: Apply or remove bold formatting.
• Ctrl + C: Copy the selected cells.
• Ctrl + D: Fill down.
• Ctrl + E: Activate the Search box.
• Ctrl + F: Open the “Find” dialog box.
• Ctrl + G: Go to a specific cell.
• Ctrl + H: Open the “Replace” dialog box.
• Ctrl + I: Apply or remove italic formatting.
• Ctrl + K: Insert a new hyperlink.
• Ctrl + L: Create a new table.
• Ctrl + M: Create a new chart.
• Ctrl + N: Create a new workbook.
• Ctrl + O: Open an existing workbook.
• Ctrl + P: Print the current workbook.
• Ctrl + Q: Quick Analysis tool.
• Ctrl + R: Fill right.
• Ctrl + S: Save the current workbook.
• Ctrl + T: Create a new table.
• Ctrl + U: Apply or remove underlined formatting.
• Ctrl + V: Paste the copied cells.
• Ctrl + W: Close the current workbook.
• Ctrl + X: Cut the selected cells.
• Ctrl + Y: Redo the last action.
• Ctrl + Z: Undo the last action.

These are just some of the many shortcut keys available in Excel. Learning and using them can significantly enhance your Excel proficiency.

6. Shortcut keys of computer a to z excel

Microsoft Excel offers a wide range of shortcuts that cater to almost every aspect of the software. Here’s a continuation of our A to Z list of shortcut keys:

• Alt + H, B, A: Add or remove the auto filter.
• Alt + H, O, I: Auto resize columns.
• Alt + H, O, R: Auto resize rows.
• Alt + D, L: Create a data list.
• Alt + A, M, M: Merge cells.
• Alt + H, B, N: Remove all borders.
• Alt + E, S, T: Transpose data.
• Alt + E, S, V: Paste special values.
• Alt + E, S, F: Paste special formulas.
• Alt + E, S, N: Paste special comments.
• Alt + E, S, W: Paste special formats.
• Alt + E, S, K: Paste special validation.

These additional shortcut keys provide even more functionality and convenience in Microsoft Excel.

Shortcut keys of computer a to z in MS Excel

Microsoft Excel offers a wide array of shortcut keys that can significantly enhance your efficiency and productivity. From basic navigation to complex data analysis, these shortcuts cover it all. Let’s start by exploring some fundamental shortcuts that every Excel user should know

Shortcut keys of computer a to z in MS Excel

Shortcut a to z keys of computer Excel pdf

Preparing a lengthy sheet in MS Excel and then revising the data or editing any single piece of information in the complete sheet would be time-consuming if you are not aware of the shortcut keys for MS Excel. Shortcut a to z keys of computer excel pdf Office programs have been discussed below. Check out the table given below to know the shortcut keys used in MS Excel. Please some change word for make some easier for read

For Excel:

• Ctrl + A: Select all cells in a worksheet.

• Ctrl + B: Apply or remove bold formatting.

• Ctrl + C: Copy the selected cells.

• Ctrl + D: Fill down.

• Ctrl + E: Flash fill.

• Ctrl + F: Find.

• Ctrl + G: Go to a specific cell.

• Ctrl + H: Replace.

• Ctrl + I: Apply or remove italic formatting.

• Ctrl + J: Justify text.

• Ctrl + K: Insert hyperlink.

• Ctrl + L: Create a table.

• Ctrl + M: Enter a formula.

• Ctrl + N: Create a new workbook.

• Ctrl + O: Open an existing workbook.

• Ctrl + P: Print.

• Ctrl + Q: Quick analysis.

• Ctrl + R: Fill right.

• Ctrl + S: Save.

• Ctrl + T: Create a table.

• Ctrl + U: Apply or remove underlined formatting.

• Ctrl + V: Paste.

• Ctrl + W: Close the current workbook.

• Ctrl + X: Cut.

• Ctrl + Y: Repeat the last action.

• Ctrl + Z: Undo.

For PDFs:

• Ctrl + A: Select all text or images.

• Ctrl + C: Copy selected content.

• Ctrl + F: Find text in the document.

• Ctrl + N: Create a new document.

• Ctrl + O: Open an existing document.

• Ctrl + P: Print the document.

• Ctrl + S: Save the document.

• Ctrl + T: Open a new browser tab (in some PDF viewers).

• Ctrl + V: Paste content.

• Ctrl + X: Cut selected content.

• Ctrl + Z: Undo the last action.

• Ctrl + Y: Redo the last action.

• Ctrl + Shift + N: Create a new folder (in file dialog).

• Ctrl + Shift + T: Reopen the last closed tab (in some PDF viewers).

• Ctrl + Shift + V: Paste without formatting (in some PDF viewers).

• Ctrl + Shift + Z: Redo the last action.

Shortcut keys of computer a to z in Excel

Shortcut keys of computer a to z excel

how to remove formula in Excel shortcut key FAQs

To remove a formula and keep only the calculated values in Microsoft Excel, you can use the “Copy and Paste Values” technique, which involves copying the cells with formulas and then pasting them as values. There isn’t a specific built-in keyboard shortcut to do this, but you can create your own shortcut by using the following steps:

1. Select the cell or range of cells that contain the formulas you want to remove.
2. Press Ctrl+C on your keyboard to copy the selected cells.
3. Right-click on the same selection, and from the context menu, choose “Paste Values” or “Paste Special.”
4. If you see “Paste Values” in the context menu, select it directly. If you see “Paste Special,” choose it, and then in the “Paste Special” dialog box, select “Values” and click “OK.”

Now you’ve replaced the formulas with the calculated values, effectively removing the formulas. You can set up a custom keyboard shortcut for this process as follows:

1. Click the “File” tab in Excel.
2. Choose “Options” at the bottom of the navigation pane.
3. In the Excel Options dialog box, select “Quick Access Toolbar.”
4. In the “Choose commands from” dropdown, select “All Commands.”
5. Scroll down and find “Values,” “Paste Values,” or “Paste Special.” Select the one that suits your needs.
6. Click the “Add” button to add the command to the Quick Access Toolbar.
7. With the command selected in the Quick Access Toolbar, you can assign a custom keyboard shortcut in the “Shortcut key” field. For example, you can use Ctrl+Shift+V.
8. Click “OK” to save your changes.