100+ Essential Shortcuts for Beginners & Advanced Users

Absolutely. Below is a comprehensive 3,000+ word guide to important Microsoft Excel keyboard shortcuts, organized for beginners, office work, data entry, formulas, formatting, navigation, filtering, PivotTables, and advanced productivity.

# Microsoft Excel Keyboard Shortcuts: Complete Guide

Microsoft Excel is one of the most widely used spreadsheet applications for office work, accounting, data analysis, education, business, finance, administration, and competitive examinations. Learning Excel keyboard shortcuts can significantly improve your speed and productivity because many common operations can be completed without moving your hand between the keyboard and mouse.

This comprehensive guide covers the most important Excel keyboard shortcuts, from basic commands to advanced data-management techniques.

> Note: Most shortcuts below apply to Excel for Windows. Some shortcuts may differ slightly on Mac or in different Excel versions.

—

# 1. Basic Excel Keyboard Shortcuts

These are the shortcuts every Excel user should know.

These shortcuts are especially useful for everyday office work.

—

# 2. Workbook Shortcuts

An Excel workbook can contain multiple worksheets. The following shortcuts help manage workbooks efficiently.

### Create a new workbook

Ctrl + N

Creates a new Excel workbook.

### Open an existing workbook

Ctrl + O

Opens the Open dialog box so you can select an existing Excel file.

### Save workbook

Ctrl + S

Saves changes to the current workbook.

### Save As

Ctrl + Shift + S

Allows you to save the workbook with a different name, location, or file format.

### Close workbook

Ctrl + W

Closes the current workbook while keeping Excel open.

### Close Excel

Alt + F4

Closes the Excel application.

### Print

Ctrl + P

Opens the Print screen.

### Open recent files

Use:

Alt + F → Recent files

The exact menu behavior can vary between Excel versions.

—

# 3. Cell Navigation Shortcuts

Navigation shortcuts are extremely important when working with large spreadsheets.

### Ctrl + Home

This is one of the most useful navigation shortcuts.

Ctrl + Home

moves the active cell to the beginning of the worksheet, normally A1.

### Ctrl + End

Ctrl + End

moves to the last used cell in the worksheet.

—

# 4. Selecting Cells

Selecting large amounts of data using the mouse can be slow. Keyboard shortcuts make this much faster.

### Select an entire row

Shift + Space

Selects the entire row containing the active cell.

### Select an entire column

Ctrl + Space

Selects the entire column containing the active cell.

### Select a data range

Place the cursor at the beginning of the data and press:

Ctrl + Shift + Arrow Key

For example, if A1 contains the first value in a continuous list, pressing:

Ctrl + Shift + Down Arrow

selects the data down to the end of the list.

—

# 5. Editing Cell Contents

These shortcuts are useful when entering or modifying information.

### F2

allows you to edit the contents of the active cell directly.

This is especially useful when correcting formulas.

—

# 6. Data Entry Shortcuts

These shortcuts can save significant time during data entry.

### Enter data and move down

Enter

### Enter data and move up

Shift + Enter

### Enter data and move right

Tab

### Enter data and move left

Shift + Tab

### Insert current date

Ctrl + ;

This inserts the current date.

### Insert current time

Ctrl + Shift + :

This inserts the current time.

### Insert a line break inside a cell

Alt + Enter

This is particularly useful for addresses, notes, and multi-line descriptions.

Example:

Employee Name
Department
Designation

can be entered inside one cell using Alt + Enter.

—

# 7. Copy and Paste Shortcuts

Copying and pasting is among the most frequent Excel operations.

### Paste Special

Ctrl + Alt + V

opens Paste Special.

It can be used for:

Values
Formulas
Formats
Comments/notes
Transpose
Operations such as Add, Subtract, Multiply, and Divide

### Fill Down

Ctrl + D

Copies the contents/formula of the top cell downward into the selected range.

### Fill Right

Ctrl + R

Copies the leftmost cell across the selected range.

—

# 8. Formatting Shortcuts

Formatting makes spreadsheets easier to read.

### Format Cells

Ctrl + 1

opens the Format Cells dialog box.

From there you can change:

Number format
Alignment
Font
Border
Fill
Protection

This is one of the most important Excel shortcuts.

—

# 9. Number Formatting Shortcuts

Excel provides several shortcuts for quickly changing number formats.

These shortcuts are useful when preparing financial and statistical spreadsheets.

—

# 10. Row and Column Shortcuts

Managing rows and columns becomes much faster with keyboard commands.

### Insert row

Select a row and use:

Ctrl + +

Depending on your keyboard, you may need the numeric keypad plus key.

Another method is:

Ctrl + Shift + +

### Delete row

Select the row and press:

Ctrl + –

### Insert column

Select the column and press:

Ctrl + +

### Delete column

Select the column and press:

Ctrl + –

### Select entire row

Shift + Space

### Select entire column

Ctrl + Space

—

# 11. Worksheet Shortcuts

Excel workbooks often contain many worksheets.

### Move between sheets

Ctrl + Page Up

moves to the previous worksheet.

Ctrl + Page Down

moves to the next worksheet.

These shortcuts are extremely useful when working with monthly or departmental sheets.

—

# 12. Formula Shortcuts

Excel formulas are essential for calculations.

### Start a formula

Type:

For example:

`=A1+B1`

### Show formulas

Ctrl + `

The grave accent key is usually located near the number 1 key.

This toggles between formula view and normal results.

### Edit formula

### Toggle absolute and relative references

While editing a formula, pressing F4 cycles through:

`A1`

`$A$1`

`A$1`

`$A1`

This is extremely important when copying formulas.

—

# 13. Important Formula Reference Concepts

Excel uses three major types of references.

### Relative reference

`A1`

Changes when copied.

### Absolute reference

`$A$1`

Does not change when copied.

### Mixed reference

`$A1`

`A$1`

Only one part remains fixed.

For example:

`=B2$E$1`

When copied downward, B2 changes but E1 remains fixed.

—

# 14. AutoSum Shortcuts

One of the most useful Excel shortcuts is:

Alt + =

This automatically inserts the SUM formula.

For example, if cells A1:A10 contain numbers, placing the cursor below them and pressing:

Alt + =

will usually create:

`=SUM(A1:A10)`

This is extremely useful for accounting, salary calculations, marksheets, sales reports, and budgets.

—

# 15. Find and Replace Shortcuts

### Find

Ctrl + F

Searches for specific text or numbers.

### Replace

Ctrl + H

Finds existing content and replaces it with new content.

For example, you can replace:

`Hyderabad`

with:

`Warangal`

throughout a worksheet.

### Go To

Ctrl + G

opens the Go To dialog box.

You can enter a cell reference such as:

`A5000`

and Excel will immediately move to that cell.

—

# 16. Filter Shortcuts

Filters are extremely important for data analysis.

### Turn AutoFilter on/off

Ctrl + Shift + L

This adds or removes filter buttons from the selected data range.

For example, a table containing:

Name | Department | Salary | City

can be filtered by department, salary, or city.

### Open filter menu

Depending on Excel version and context, use:

Alt + Down Arrow

when the filter cell/dropdown is active.

—

# 17. Sort Data

Excel can sort information alphabetically, numerically, or chronologically.

Common Ribbon shortcuts include:

Alt + A, S, A

Sort A to Z / smallest to largest, depending on context.

Alt + A, S, D

Sort Z to A / largest to smallest, depending on context.

Because Ribbon key sequences can vary between Microsoft 365 versions, the exact letters may differ.

—

# 18. Table Shortcuts

Excel Tables are useful for managing structured datasets.

### Create a table

Ctrl + T

Ctrl + L

in many Excel versions.

Excel opens the Create Table dialog box.

Tables automatically provide:

Filter buttons
Structured references
Automatic expansion
Formatting
Total row options

—

# 19. PivotTable Shortcuts

PivotTables are widely used for data analysis.

You can create a PivotTable using the Insert tab or Ribbon KeyTips.

A common approach is:

Alt + N, V

to access PivotTable-related commands in supported Excel versions.

PivotTables can summarize:

Sales
Expenses
Employee information
Attendance
Products
Regional performance
Monthly revenue

Because Ribbon shortcuts can vary by version, use the Alt key to display the current KeyTips.

—

# 20. Chart Shortcuts

Charts help visualize Excel data.

### Create a chart

Select the required data and press:

Alt + F1

This creates an embedded chart using the selected data.

### Create a chart on a separate chart sheet

F11

creates a chart sheet from the selected data.

Useful chart types include:

Column
Bar
Line
Pie
Area
Scatter
Combo

—

# 21. Insert and Delete Cells

### Insert cells/rows/columns

Ctrl + +

### Delete cells/rows/columns

Ctrl + –

### Insert worksheet

Shift + F11

### Delete worksheet

Worksheet deletion is normally performed through the sheet tab or Ribbon.

Be careful when deleting because worksheet deletion can remove significant amounts of data.

—

# 22. Hide and Unhide Rows and Columns

### Hide selected rows

Ctrl + 9

### Hide selected columns

Ctrl + 0

### Unhide rows

Select the surrounding rows and use the appropriate Unhide command from the Home menu.

### Unhide columns

Select surrounding columns and use the Unhide command.

Note that some Excel security or operating-system configurations may affect the behavior of Ctrl + 0.

—

# 23. Freeze Panes

Freeze Panes keeps important rows or columns visible while scrolling.

For example, if row 1 contains headings, you can freeze it so that the headings remain visible while scrolling down.

The exact Ribbon sequence depends on Excel version, but you can access it through:

View → Freeze Panes

This is particularly useful for large datasets.

—

# 24. Workbook Calculation Shortcuts

Excel automatically calculates formulas in normal calculation mode.

Useful shortcuts include:

Calculate formulas in all open workbooks.

Shift + F9

Calculate formulas in the active worksheet.

Ctrl + Alt + F9

Force calculation of all formulas.

Ctrl + Alt + Shift + F9

Recalculate dependencies and formulas.

These shortcuts can be useful in large workbooks where formulas take time to calculate.

—

# 25. Comments and Notes

Modern Excel uses threaded comments, while older Excel versions used comments/notes differently.

To insert a comment or note, use the Review tab.

Keyboard navigation through Ribbon KeyTips can vary between versions, so pressing Alt is the safest way to identify the current shortcut sequence.

—

# 26. Hyperlink Shortcut

Ctrl + K

opens the Insert Hyperlink dialog box.

You can use it to create links to:

Websites
Files
Email addresses
Locations inside a workbook

—

# 27. Spell Check

opens the spelling checker.

This is useful when preparing:

Reports
Employee lists
Official documents
Business reports
Presentations
Educational spreadsheets

—

# 28. Quick Access to Ribbon

Press:

Alt

Excel displays KeyTips over Ribbon commands.

For example, pressing Alt allows you to navigate through:

Home
Insert
Page Layout
Formulas
Data
Review
View

without using the mouse.

This is one of the best techniques for becoming a keyboard-focused Excel user.

—

# 29. Opening Ribbon Commands

Press:

Alt + H

to access Home-related commands.

Alt + N

to access Insert-related commands.

Alt + P

to access Page Layout-related commands.

Alt + M

to access Formulas-related commands.

Alt + A

to access Data-related commands.

Alt + R

to access Review-related commands.

Alt + W

to access View-related commands.

The exact letters shown after pressing Alt can vary by Excel version and language.

—

# 30. Flash Fill

Flash Fill can automatically recognize patterns in your data.

### Flash Fill

Ctrl + E

For example, if a column contains:

`Mallesh Tekumatla`

and you start another column with:

`Mallesh`

Excel may recognize the pattern and fill the remaining names.

Flash Fill is useful for:

Extracting first names
Extracting last names
Combining text
Formatting phone numbers
Separating codes
Cleaning data

—

# 31. Quick Analysis

Select a data range and Excel may display the Quick Analysis button.

Depending on Excel version, keyboard access can vary.

Quick Analysis can help create:

Formatting
Charts
Totals
Tables
Sparklines

—

# 32. Repeat Last Action

repeats the previous command in many contexts.

For example, if you format one cell and want to repeat the same operation elsewhere, F4 can sometimes repeat the action.

However, when editing formulas, F4 has another important function: changing reference types.

—

# 33. Redo and Undo

### Undo

Ctrl + Z

Reverses the last action.

### Redo

Ctrl + Y

Repeats or restores the action.

These are among the most important shortcuts to memorize.

—

# 34. Clear Data

Press:

Delete

to clear the contents of selected cells.

However, Delete does not necessarily remove all formatting.

To completely manage cell contents, use:

Home → Clear

where you can choose:

Clear All
Clear Formats
Clear Contents
Clear Comments/Notes
Clear Hyperlinks

—

# 35. Important Selection Tricks

Suppose you have thousands of rows.

Instead of scrolling, use:

Ctrl + Down Arrow

to jump to the bottom of a continuous data region.

Then:

Ctrl + Shift + Up Arrow

to select the data upward.

This is much faster than dragging with the mouse.

—

# 36. Working With Multiple Cells

To enter the same value into several selected cells:

1. Select the cells.
2. Type the value.
3. Press Ctrl + Enter.

The value is entered into all selected cells.

This is particularly useful for:

Department names
Status values
Common dates
Categories
Repeated labels

—

# 37. Transpose Data

Transpose changes rows into columns or columns into rows.

One method is:

1. Copy the range with Ctrl + C.
2. Use Ctrl + Alt + V.
3. Choose Transpose.

This is useful when restructuring datasets.

—

# 38. Important Excel Shortcut List for Competitive Exams

If you are preparing for an examination, remember these high-priority shortcuts first:

1. Ctrl + N — New workbook
2. Ctrl + O — Open workbook
3. Ctrl + S — Save
4. Ctrl + P — Print
5. Ctrl + C — Copy
6. Ctrl + X — Cut
7. Ctrl + V — Paste
8. Ctrl + Z — Undo
9. Ctrl + Y — Redo
10. Ctrl + F — Find
11. Ctrl + H — Replace
12. Ctrl + A — Select all/current data
13. Ctrl + G — Go To
14. F2 — Edit cell
15. F4 — Repeat/toggle references
16. F5 — Go To
17. F7 — Spell Check
18. F9 — Calculate
19. F11 — Chart sheet
20. Ctrl + 1 — Format Cells
21. Ctrl + B — Bold
22. Ctrl + I — Italic
23. Ctrl + U — Underline
24. Ctrl + 5 — Strikethrough
25. Ctrl + K — Hyperlink
26. Ctrl + T — Create Table
27. Ctrl + Shift + L — Filter
28. Ctrl + Shift + $ — Currency
29. Ctrl + Shift + % — Percentage
30. Ctrl + Shift + # — Date
31. Ctrl + Shift + @ — Time
32. Ctrl + Shift + ! — Number format
33. Ctrl + ; — Current date
34. Ctrl + Shift + : — Current time
35. Alt + Enter — New line inside cell
36. Alt + = — AutoSum
37. Ctrl + D — Fill Down
38. Ctrl + R — Fill Right
39. Ctrl + E — Flash Fill
40. Ctrl + Space — Select column
41. Shift + Space — Select row
42. Ctrl + Home — Go to A1
43. Ctrl + End — Last used cell
44. Ctrl + Page Up — Previous sheet
45. Ctrl + Page Down — Next sheet
46. Shift + F11 — New worksheet
47. Ctrl + 9 — Hide rows
48. Ctrl + 0 — Hide columns
49. Ctrl + Alt + V — Paste Special
50. Ctrl + Enter — Fill selected cells

—

# 39. Top 20 Excel Shortcuts to Memorize First

If you are a beginner, do not try to memorize every shortcut immediately.

Start with these 20:

| No. | Shortcut | Purpose |
| –: | —————- | ———————– |
| 1 | Ctrl + C | Copy |
| 2 | Ctrl + V | Paste |
| 3 | Ctrl + X | Cut |
| 4 | Ctrl + Z | Undo |
| 5 | Ctrl + Y | Redo |
| 6 | Ctrl + S | Save |
| 7 | Ctrl + F | Find |
| 8 | Ctrl + H | Replace |
| 9 | Ctrl + A | Select |
| 10 | Ctrl + P | Print |
| 11 | Ctrl + 1 | Format Cells |
| 12 | F2 | Edit cell |
| 13 | F4 | Repeat/reference toggle |
| 14 | Ctrl + Home | A1 |
| 15 | Ctrl + End | Last used cell |
| 16 | Ctrl + Shift + L | Filter |
| 17 | Ctrl + T | Table |
| 18 | Alt + = | AutoSum |
| 19 | Ctrl + E | Flash Fill |
| 20 | Ctrl + ; | Current date |

—

# 40. Excel Shortcuts for Data Entry Operators

For data-entry jobs, these shortcuts are especially useful:

Tab — Move right

Shift + Tab — Move left

Enter — Move down

Shift + Enter — Move up

Ctrl + Enter — Enter the same value in selected cells

Alt + Enter — New line in cell

Ctrl + ; — Current date

Ctrl + Shift + : — Current time

Ctrl + D — Fill down

Ctrl + R — Fill right

Ctrl + C — Copy

Ctrl + V — Paste

Ctrl + Z — Undo

F2 — Edit cell

Ctrl + F — Find

Ctrl + H — Replace

Ctrl + Shift + L — Filter

These can significantly improve data-entry speed.

—

# 41. Excel Shortcuts for Office Employees

Office professionals frequently work with reports, employee records, financial data, and administrative spreadsheets.

The most useful shortcuts include:

Ctrl + S — Save
Ctrl + P — Print
Ctrl + F — Find
Ctrl + H — Replace
Ctrl + T — Create table
Ctrl + Shift + L — Filter
Ctrl + 1 — Format Cells
Ctrl + C — Copy
Ctrl + V — Paste
Ctrl + Z — Undo
Ctrl + Shift + Arrow — Select data
Ctrl + Home — Beginning
Ctrl + End — Last used cell
Alt + = — AutoSum
Ctrl + E — Flash Fill
F2 — Edit
Ctrl + K — Hyperlink
F7 — Spell Check

—

# 42. Excel Shortcuts for Accounting and Finance

People working with financial spreadsheets should particularly know:

Alt + = — AutoSum

Ctrl + Shift + $ — Currency format

Ctrl + Shift + % — Percentage

Ctrl + 1 — Format Cells

F4 — Absolute references

Ctrl + D — Fill formulas downward

Ctrl + R — Fill formulas right

Ctrl + Shift + ! — Number formatting

Ctrl + ; — Insert date

Ctrl + Shift + : — Insert time

F9 — Calculate

These shortcuts can make repetitive financial calculations much faster.

—

# 43. Excel Shortcuts for Data Analysis

For analysts, the following shortcuts are particularly important:

Ctrl + T — Create Table

Ctrl + Shift + L — Filter

Ctrl + E — Flash Fill

Ctrl + Arrow Keys — Navigate data

Ctrl + Shift + Arrow Keys — Select data

Ctrl + Alt + V — Paste Special

Alt + = — AutoSum

Ctrl + 1 — Format Cells

Alt + F1 — Create chart

F11 — Create chart sheet

Ctrl + G / F5 — Go To

Ctrl + F — Find

Ctrl + H — Replace

Ctrl + ` — Show formulas

—

# 44. Excel Shortcut Memory Tricks

You can remember many shortcuts by associating the letter with its function.

### C = Copy

Ctrl + C

### V = Paste

Think of V as the common paste shortcut.

Ctrl + V

### X = Cut

Ctrl + X

### S = Save

Ctrl + S

### P = Print

Ctrl + P

### F = Find

Ctrl + F

### H = Replace

Ctrl + H

### B = Bold

Ctrl + B

### I = Italic

Ctrl + I

### U = Underline

Ctrl + U

### K = Hyperlink

Ctrl + K

### T = Table

Ctrl + T

### E = Flash Fill

Ctrl + E

Learning these associations makes memorization easier.

—

# 45. Frequently Asked Excel Shortcut Questions

### What is the shortcut for Copy?

Ctrl + C

### What is the shortcut for Paste?

Ctrl + V

### What is the shortcut for Cut?

Ctrl + X

### What is the shortcut for Undo?

Ctrl + Z

### What is the shortcut for Redo?

Ctrl + Y

### What is the shortcut for Save?

Ctrl + S

### What is the shortcut for Find?

Ctrl + F

### What is the shortcut for Replace?

Ctrl + H

### What is the shortcut for Format Cells?

Ctrl + 1

### What is the shortcut for AutoSum?

Alt + =

### What is the shortcut for Filter?

Ctrl + Shift + L

### What is the shortcut for creating a table?

Ctrl + T

### What is the shortcut for editing a cell?

### What is the shortcut for absolute cell reference?

Press F4 while editing a formula.

### What is the shortcut for inserting the current date?

Ctrl + ;

### What is the shortcut for inserting the current time?

Ctrl + Shift + :

### What is the shortcut for a new line inside a cell?

Alt + Enter

### What is the shortcut for hiding rows?

Ctrl + 9

### What is the shortcut for hiding columns?

Ctrl + 0

### What is the shortcut for selecting an entire row?

Shift + Space

### What is the shortcut for selecting an entire column?

Ctrl + Space

—

# 46. Final Excel Shortcut Cheat Sheet

For quick revision, remember this core list:

—

# Conclusion

Microsoft Excel contains hundreds of keyboard shortcuts, but you do not need to memorize all of them at once. Start with the essential commands such as Ctrl + C, Ctrl + V, Ctrl + X, Ctrl + Z, Ctrl + S, Ctrl + F, Ctrl + H, Ctrl + 1, F2, F4, Ctrl + T, Ctrl + Shift + L, Alt + =, Ctrl + E, Ctrl + Home, and Ctrl + End.

Once these become familiar, add shortcuts for formulas, formatting, worksheet navigation, filtering, data analysis, and PivotTables.

For competitive examinations and office jobs, understanding the purpose of each shortcut is more important than simply memorizing a long list. Practicing these shortcuts while working with real Excel data will help develop both speed and accuracy.

Important: Excel’s Ribbon KeyTip sequences can change between Microsoft 365/Excel versions and language settings. When a multi-key Ribbon shortcut differs, press Alt to display the current KeyTips on your version of Excel.

Englishmoral

100+ Essential Shortcuts for Beginners & Advanced Users

Leave a Reply Cancel reply