Excel Shortcut Keys

Excel shortcut keys are combinations of keys that help us to perform different tasks in excel quickly. It helps to work easier, such as copying data, saving a workbook, formatting cells, calculating totals, and moving between rows and columns. These shortcut keys save time and work more easily with large Excel spreadsheets.

1. Basic Excel Shortcut Keys

Basic shortcuts help us to perform common tasks such as copying, pasting, saving, and finding information. These shortcuts are useful for beginners as well as people who work with Excel every day.

Example: Suppose you have copied an employee's salary from one cell and want to place it in another cell. Select the original cell, press Ctrl + C, select the destination cell, and press Ctrl + V.

2. Excel Navigation Shortcut Keys

Navigation shortcuts help us to move around a worksheet without scrolling manually. They are particularly useful when working with thousands of rows or multiple worksheets.

Example: Suppose an employee attendance sheet contains 5,000 rows. Instead of scrolling to the bottom, click a cell in column A and press Ctrl + Down Arrow. Excel moves to the next edge of the data region in that column.

If there are blank cells or separate groups of data, Excel may stop at a blank cell or the next data boundary rather than the final row of the worksheet.

3. Excel Selection Shortcut Keys

Selection shortcuts help us to select cells, rows, columns, or large data ranges quickly. They are useful when you want to apply formatting, copy data, or delete multiple entries.

Example: Suppose you want to select all employee names in a long list. Click the first name and press Ctrl + Shift + Down Arrow. Excel extends the selection down the column to the next data boundary.

4. Excel Editing Shortcut Keys

Editing shortcuts help us to enter, change, and fill data without repeating the same actions for every cell.

Example: Suppose you need to enter the word "Pending" in 19 cells, from C2 to C20. Select the range, type Pending, and press Ctrl + Enter. Excel fills all selected cells with the same word.

5. Excel Formatting Shortcut Keys

Formatting shortcuts help us to change the appearance of data, such as making text bold, displaying amounts as currency, or applying a date format.

Example: Suppose a salary sheet contains the value 30000 in a cell. Select the cell and press Ctrl + Shift + $ to apply currency formatting. The exact currency symbol and display depend on your Excel settings.

You can also select a heading and press Ctrl + B to make it bold.

6. Excel Row and Column Shortcut Keys

These shortcuts help us to insert, delete, hide, and resize rows or columns. They are useful when organizing employee records, attendance sheets, salary reports, and other office spreadsheets.

Example: Suppose some employee names are too long to display completely. Select the relevant columns and use Alt, H, O, I in sequence. Excel adjusts their widths to fit the cell contents.

Note: The shortcut Ctrl + Shift + 0 for unhiding columns may not work on some Windows systems because of operating-system settings. You can use Home > Format > Hide & Unhide > Unhide Columns instead.

7. Excel Formula and Data Shortcut Keys

Formula and data shortcuts make calculations easier and help you organize information for filtering, analysis, and reporting.

Example: Suppose you have a list of employee salaries and want to calculate the total. Click the empty cell below the salary values and press Alt + =. Excel suggests a SUM formula, which you can confirm by pressing Enter.

8. Practical Examples of Excel Shortcut Keys

Let's understand five useful shortcuts with simple examples.

Example 1: Calculate Total Salary Using Alt + =

Suppose you have the following employee salary data and want to calculate the total salary.

Steps:

1. Enter the employee names in cells A2.
2. Enter their salaries in cells B2.
3. Click cell B6, directly below the last salary.
4. Press Alt + =.
5. Check the suggested formula and press Enter.

Output:

Explanation:

Excel automatically inserts a formula such as =SUM(B2:B5) into cell B6. The SUM function adds the four salary amounts and displays the result, 135000.

Example 2: Move Through a Large Table Using Ctrl + Arrow

Suppose you have an employee list containing thousands of records in column A. You want to move to the end of the current data region quickly.

Steps:

1. Click cell A1.
2. Press Ctrl + Down Arrow.
3. Excel moves to the next edge of the data region in column A.

Output:

The active cell moves down the column without requiring you to scroll through every row.

Explanation:

The Ctrl and Arrow key combination moves between data boundaries. If column A contains continuous data from A1 to A5000, Excel can move directly to A5000.

If blank cells separate the data, the shortcut may stop at the first boundary. In that case, press the shortcut again as needed.

Example 3: Lock a Cell Reference Using F4

Suppose you are calculating employee bonuses using a percentage stored in cell B1. When copying a formula to other rows, you may want the percentage reference to remain fixed.

Excel uses dollar signs ($) to lock a row, a column, or both.

Steps:

1. Enter =A1 in a cell.
2. While editing the formula, place the cursor on the reference A1.
3. Press F4 repeatedly to cycle through the reference types.

Output:

Explanation:

A relative reference changes when a formula is copied to another cell. An absolute reference, such as $A$1, remains fixed.

For example, if the bonus percentage is stored in B1, the formula =A2*$B$1 keeps the percentage reference fixed when copied down the employee list.

Learn more about Excel concepts in our Excel Interview Questions guide.

Example 4: Separate First Names Using Flash Fill (Ctrl + E)

Suppose column A contains full names, but you want to display only the first names in column B.

Input:

Steps:

1. Enter Amit Sharma in A2 and Amit in B2.
2. Enter the next full name in A3.
3. Click B3.
4. Press Ctrl + E.

Output:

Explanation:

Flash Fill identifies a pattern from the example you entered and tries to complete the remaining entries. It is useful for separating names, extracting parts of text, and rearranging data.

Always review the results because Flash Fill may not recognize every pattern correctly.

Example 5: Fill Multiple Cells at Once Using Ctrl + Enter

Suppose you are preparing an office task tracker and need to mark several tasks as Pending.

Steps:

1. Select the range C2.
2. Type Pending.
3. Press Ctrl + Enter.

Output:

Every cell from C2 to C20 contains the word Pending.

Explanation:

Normally, pressing Enter moves the active cell after entering a value. However, pressing Ctrl + Enter places the same value into all selected cells.

This shortcut is helpful when updating task statuses, entering common labels, or filling several cells with the same formula.

9. Tips for Learning Excel Shortcut Keys

You do not need to memorize every Excel shortcut at once. Start with the shortcuts you use most frequently and gradually learn more as your work requires them.

• For everyday work: Learn Ctrl + C, Ctrl + V, Ctrl + Z, Ctrl + S, and Ctrl + F.
• For large spreadsheets: Practice Ctrl + Arrow and Ctrl + Shift + Arrow to navigate and select data.
• For calculations: Learn Alt + = for totals and F4 for cell references.
• For formatting: Use Ctrl + 1 to access number formats, borders, alignment, and other cell settings.
• For data management: Use Ctrl + T to create a Table and Ctrl + Shift + L to apply filters.

Most of these shortcuts apply to Excel on Windows desktop. Shortcuts can differ on Mac, in Excel for the web, or depending on keyboard and system settings. On Mac, many common shortcuts use Command instead of Ctrl, but not all shortcuts have a direct equivalent.

Conclusion

Excel shortcut keys help you complete everyday spreadsheet tasks more quickly. Whether you are preparing a salary sheet, maintaining employee attendance, organizing records, or calculating totals, keyboard shortcuts can reduce repetitive work.