200+ Excel Keyboard Shortcuts to Work Faster (Complete Guide)

200+ Excel Keyboard Shortcuts

Microsoft Excel is one of the most popular spreadsheet programs used by students, teachers, accountants, office employees, business owners, and data analysts. Whether you are managing financial records, preparing reports, creating charts, or organizing large amounts of information, Excel can make your work easier.

However, using a mouse for every task can waste valuable time. This is where Excel keyboard shortcuts become useful.

With the help of keyboard shortcuts, you can quickly copy and paste data, format cells, insert rows, delete columns, calculate formulas, navigate worksheets, and perform many other tasks without repeatedly using your mouse.

In this article, you will discover 200+ Excel keyboard shortcuts for Windows with their functions and explanations. These shortcuts are organized into different categories so you can easily find and learn the ones you need.

What Are Excel Keyboard Shortcuts?

Excel keyboard shortcuts are combinations of two or more keyboard keys that allow you to perform specific actions quickly.

For example:

  • Ctrl + C: Copy selected cells.
  • Ctrl + V: Paste copied information.
  • Ctrl + S: Save your workbook.
  • Ctrl + Z: Undo your last action.
  • Ctrl + B: Apply bold formatting.

Instead of navigating through different menus, you can press a few keys to complete the same task.

1. Basic Excel Keyboard Shortcuts

These are some of the most commonly used Excel shortcuts. Beginners should learn these first because they are useful for everyday spreadsheet work.

No.Shortcut KeyFunction
1Ctrl + NCreate a new workbook
2Ctrl + OOpen an existing workbook
3Ctrl + SSave the current workbook
4F12Open the Save As dialog box
5Ctrl + PPrint the worksheet or workbook
6Ctrl + WClose the current workbook
7Alt + F4Close Excel
8Ctrl + CCopy selected cells
9Ctrl + XCut selected cells
10Ctrl + VPaste copied or cut cells
11Ctrl + ZUndo the last action
12Ctrl + YRedo or repeat an action
13Ctrl + ASelect the current data region or entire worksheet, depending on context
14Ctrl + FFind specific text or values
15Ctrl + HFind and replace data
16F1Open Excel Help
17F7Check spelling
18Ctrl + KInsert a hyperlink
19Shift + F10Open the context menu
20Ctrl + QOpen Quick Analysis options

2. Excel Navigation Shortcuts

Navigation shortcuts help you move between cells, rows, columns, and worksheets without scrolling manually.

They are particularly helpful when working with large spreadsheets containing thousands of rows.

No.Shortcut KeyFunction
21Arrow KeysMove one cell in the selected direction
22TabMove one cell to the right
23Shift + TabMove one cell to the left
24EnterMove one cell down after entering data
25Shift + EnterMove one cell up
26HomeMove to the beginning of the current row
27Ctrl + HomeMove to cell A1
28Ctrl + EndMove to the last used cell
29Ctrl + Right ArrowMove to the right edge of the current data region
30Ctrl + Left ArrowMove to the left edge of the current data region
31Ctrl + Up ArrowMove to the top edge of the current data region
32Ctrl + Down ArrowMove to the bottom edge of the current data region
33Page DownMove one screen down
34Page UpMove one screen up
35Alt + Page DownMove one screen to the right
36Alt + Page UpMove one screen to the left
37Ctrl + Page DownMove to the next worksheet
38Ctrl + Page UpMove to the previous worksheet
39Ctrl + GOpen the Go To dialog box
40F5Open the Go To dialog box
41End, Right ArrowMove to the next nonblank cell or the row’s edge
42End, Down ArrowMove to the next nonblank cell or the column’s edge
43End, Left ArrowMove toward the left edge of the current data region
44End, Up ArrowMove toward the top edge of the current data region
45Ctrl + BackspaceScroll to display the active cell

3. Excel Cell Selection Shortcuts

Selecting cells manually can become time-consuming when you work with large datasets. These shortcuts help you select individual cells, entire rows, columns, and data ranges.

No.Shortcut KeyFunction
46Shift + Arrow KeyExtend the selection by one cell
47Ctrl + Shift + Right ArrowSelect cells to the right edge of the data region
48Ctrl + Shift + Left ArrowSelect cells to the left edge of the data region
49Ctrl + Shift + Up ArrowSelect cells to the top edge of the data region
50Ctrl + Shift + Down ArrowSelect cells to the bottom edge of the data region
51Ctrl + SpacebarSelect the entire column
52Shift + SpacebarSelect the entire row
53Ctrl + Shift + SpacebarSelect the current region or worksheet, depending on context
54Ctrl + Shift + HomeExtend selection to the beginning of the worksheet
55Ctrl + Shift + EndExtend selection to the last used cell
56F8Turn on Extend Selection mode
57Shift + F8Add another range to the selection
58Ctrl + Shift + Asterisk (*)Select the current data region
59Ctrl + ASelect the current region or entire worksheet
60Ctrl + Period (.)Move between the corners of a selected range
61Shift + BackspaceReduce a multiple-cell selection to the active cell
62Ctrl + Shift + Page DownSelect the current and next worksheet
63Ctrl + Shift + Page UpSelect the current and previous worksheet
64Ctrl + EnterFill all selected cells with the current entry
65Alt + EnterStart a new line inside a cell

4. Excel Formatting Shortcuts

Formatting makes your spreadsheet easier to read and understand. You can use these shortcuts to change fonts, apply borders, adjust number formats, and improve the appearance of your data.

No.Shortcut KeyFunction
66Ctrl + BApply or remove bold formatting
67Ctrl + IApply or remove italic formatting
68Ctrl + UApply or remove underline
69Ctrl + 1Open the Format Cells dialog box
70Ctrl + 2Apply or remove bold formatting
71Ctrl + 3Apply or remove italic formatting
72Ctrl + 4Apply or remove underline
73Ctrl + 5Apply or remove strikethrough
74Ctrl + 6Switch between hiding and displaying objects
75Ctrl + 8Show or hide outline symbols
76Ctrl + Shift + &Apply an outline border
77Ctrl + Shift + _Remove the outline border
78Ctrl + Shift + ~Apply General number format
79Ctrl + Shift + $Apply Currency format
80Ctrl + Shift + %Apply Percentage format
81Ctrl + Shift + ^Apply Scientific number format
82Ctrl + Shift + #Apply Date format
83Ctrl + Shift + @Apply Time format
84Ctrl + Shift + !Apply Number format
85Ctrl + Shift + FOpen font formatting options
86Ctrl + Shift + POpen font size options in Format Cells
87Alt + H, HOpen the Fill Color menu
88Alt + H, BOpen the Borders menu
89Alt + H, A, CCenter-align cell contents
90Alt + H, A, LLeft-align cell contents
91Alt + H, A, RRight-align cell contents
92Alt + H, WToggle Wrap Text
93Alt + H, M, CMerge and Center
94Alt + H, O, IAutoFit column width
95Alt + H, O, AAutoFit row height

Note: Ribbon shortcuts such as Alt + H, H are pressed in sequence, not simultaneously. The exact available ribbon commands can vary by Excel version.

5. Excel Editing Shortcuts

Editing shortcuts allow you to modify cell contents, remove information, copy formulas, and enter data more efficiently.

No.Shortcut KeyFunction
96F2Edit the active cell
97DeleteClear cell contents
98BackspaceClear the cell and begin editing
99EscCancel the current entry
100Ctrl + DFill selected cells downward
101Ctrl + RFill selected cells to the right
102Ctrl + EUse Flash Fill
103Ctrl + EnterEnter the same data in all selected cells
104Ctrl + Apostrophe (‘)Copy the formula from the cell above
105Ctrl + Shift + Apostrophe (‘)Copy the value from the cell above
106Ctrl + Plus (+)Open the Insert Cells dialog box
107Ctrl + Minus (-)Open the Delete Cells dialog box
108Ctrl + Alt + VOpen Paste Special
109Ctrl + KInsert a hyperlink
110Ctrl + Semicolon (;)Insert the current date
111Ctrl + Shift + Semicolon (;)Insert the current time
112Ctrl + Grave Accent (`)Show or hide formulas
113Ctrl + Shift + UExpand or collapse the formula bar
114Ctrl + LCreate a table
115Ctrl + TCreate a table
116F4Repeat the last action when possible

6. Excel Row and Column Shortcuts

When working with employee records, student information, sales reports, or financial data, you often need to insert, delete, hide, or resize rows and columns.

These shortcuts make those tasks easier.

No.Shortcut KeyFunction
117Ctrl + SpacebarSelect the entire column
118Shift + SpacebarSelect the entire row
119Ctrl + 9Hide selected rows
120Ctrl + Shift + 9Unhide hidden rows
121Ctrl + 0Hide selected columns
122Ctrl + Shift + 0Unhide hidden columns, subject to Windows settings
123Ctrl + Plus (+)Insert cells, rows, or columns
124Ctrl + Minus (-)Delete cells, rows, or columns
125Alt + H, I, RInsert a worksheet row above
126Alt + H, I, CInsert a worksheet column to the left
127Alt + H, D, RDelete selected rows
128Alt + H, D, CDelete selected columns
129Alt + H, O, IAutoFit column width
130Alt + H, O, AAutoFit row height
131Alt + H, O, WSet column width
132Alt + H, O, HSet row height

7. Excel Formula and Function Shortcuts

Excel formulas help you perform calculations, analyze information, and manage numerical data.

The following shortcuts are useful when working with functions and formulas.

No.Shortcut KeyFunction
133=Start entering a formula
134Alt + =Insert the AutoSum formula
135Shift + F3Open the Insert Function dialog box
136F2Edit the formula in the active cell
137F4Change between relative and absolute cell references while editing a formula
138Ctrl + `Display or hide formulas
139Ctrl + Shift + UExpand or collapse the formula bar
140F9Calculate all worksheets in open workbooks
141Shift + F9Calculate the active worksheet
142Ctrl + Alt + F9Force calculation of all worksheets
143Ctrl + Alt + Shift + F9Recheck dependencies and force a full calculation
144Ctrl + ADisplay function arguments when editing a formula
145Ctrl + Shift + AInsert function argument names while editing a formula
146Ctrl + F3Open Name Manager
147Ctrl + Shift + F3Create names from selected row or column labels
148Ctrl + FFind a particular formula or value
149F9 (while editing a formula)Calculate the selected portion of a formula
150Ctrl + End (in formula bar)Move the cursor to the end of the formula text

8. Excel Data Management Shortcuts

Data management shortcuts are especially useful for people working with large databases, customer lists, sales reports, and business records.

No.Shortcut KeyFunction
151Ctrl + Shift + LTurn filters on or off
152Alt + Down ArrowOpen the filter or data validation dropdown
153Ctrl + EUse Flash Fill
154Ctrl + TConvert selected data into a table
155Ctrl + LCreate a table
156Alt + A, S, ASort data from A to Z
157Alt + A, S, DSort data from Z to A
158Alt + A, TApply or remove filters
159Ctrl + Alt + LReapply filters
160Alt + A, EOpen the Text to Columns wizard
161Alt + A, MOpen Remove Duplicates
162Alt + A, V, VOpen Data Validation options
163Alt + A, WOpen What-If Analysis options
164Alt + A, QOpen Get Data options in supported Excel versions
165Alt + F5Refresh the selected external data connection
166Ctrl + Alt + F5Refresh all external data connections

9. Excel Worksheet and Workbook Shortcuts

These shortcuts help you manage multiple worksheets, open workbook windows, and organize spreadsheet files.

No.Shortcut KeyFunction
167Shift + F11Insert a new worksheet
168Alt + Shift + F1Insert a new worksheet
169Ctrl + Page DownMove to the next worksheet
170Ctrl + Page UpMove to the previous worksheet
171Ctrl + Shift + Page DownSelect the current and next worksheet
172Ctrl + Shift + Page UpSelect the current and previous worksheet
173Alt + F1Create an embedded chart from selected data
174F11Create a chart on a separate chart sheet
175Ctrl + F6Switch between workbook windows
176Ctrl + TabSwitch to the next open workbook window in supported contexts
177Ctrl + Shift + F6Switch to the previous workbook window
178Ctrl + F4Close the active workbook window
179Ctrl + NCreate a new workbook
180Ctrl + OOpen a workbook
181Ctrl + SSave the workbook
182F12Open Save As

10. Excel Chart and Object Shortcuts

Charts help you present information visually. You can use these shortcuts to create charts and work with objects in your worksheet.

No.Shortcut KeyFunction
183Alt + F1Create an embedded chart using selected data
184F11Create a chart on a separate chart sheet
185Ctrl + CCopy a selected chart or object
186Ctrl + XCut a selected chart or object
187Ctrl + VPaste a copied chart or object
188DeleteDelete a selected chart or object
189TabMove between objects when object navigation is active
190Ctrl + Alt + 5Start navigating floating objects
191EscExit floating object navigation
192Shift + F10Open the context menu for a selected object
193Alt + Left ArrowRotate a selected object left in supported contexts
194Alt + Right ArrowRotate a selected object right in supported contexts

11. Excel Paste Special Shortcuts

Paste Special is one of the most useful Excel features. It allows you to paste only specific parts of copied information, such as values, formulas, formatting, or column widths.

First, copy the cells using Ctrl + C. Then press Ctrl + Alt + V to open the Paste Special dialog box.

No.Shortcut KeyFunction
195Ctrl + Alt + VOpen Paste Special
196APaste everything in the Paste Special dialog
197FPaste formulas
198VPaste values
199TPaste formats
200CPaste comments and notes
201NPaste data validation
202HPaste all contents and formatting
203XPaste everything except borders
204WPaste column widths
205RPaste formulas and number formats
206UPaste values and number formats

Important: The letters in rows 196–206 are used after opening the Paste Special dialog. They are not standalone Excel shortcuts.

12. Excel Function Keys and Their Uses

Function keys are the keys labeled F1 through F12 on your keyboard. They perform different tasks in Microsoft Excel.

No.Shortcut KeyFunction
207F1Open Excel Help
208F2Edit the active cell
209F3Paste a defined name into a formula
210F4Repeat the last action or change cell references
211F5Open the Go To dialog box
212F6Switch between worksheet, ribbon, task pane, and other areas
213F7Check spelling
214F8Turn on Extend Selection mode
215F9Calculate all worksheets in open workbooks
216F10Activate or deactivate Key Tips
217F11Create a chart on a separate chart sheet
218F12Open the Save As dialog box

13. Most Useful Excel Shortcuts for Beginners

If you are new to Microsoft Excel, learning all 200+ shortcuts at once may feel difficult.

Instead, start with these essential shortcuts. They can help you complete everyday spreadsheet tasks more quickly.

No.Shortcut KeyWhat It Does
219Ctrl + CCopy
220Ctrl + VPaste
221Ctrl + XCut
222Ctrl + ZUndo
223Ctrl + SSave
224Ctrl + BBold
225Ctrl + FFind
226Ctrl + HReplace
227Ctrl + TCreate a table
228Ctrl + 1Format cells
229Ctrl + Shift + LApply filters
230Alt + =AutoSum
231Ctrl + HomeGo to cell A1
232Ctrl + EndGo to the last used cell
233Ctrl + DFill down
234Ctrl + RFill right
235Ctrl + EFlash Fill
236F2Edit a cell
237F4Repeat an action or change formula references
238Shift + F11Insert a new worksheet

Tips for Learning Excel Keyboard Shortcuts

Learning keyboard shortcuts takes practice. You do not need to memorize every shortcut in one day. Follow these simple tips to improve your Excel skills.

1. Start With Basic Shortcuts

Begin with common shortcuts such as Ctrl + C, Ctrl + V, Ctrl + S, and Ctrl + Z. These are useful in almost every spreadsheet task.

2. Practice Every Day

Spend 10–15 minutes practicing Excel shortcuts. Try using keyboard combinations instead of clicking buttons with your mouse.

3. Learn Shortcuts by Category

Learn shortcuts related to formatting, navigation, formulas, and data management separately. This makes remembering them easier.

4. Keep a Shortcut Cheat Sheet

Save or print a list of your favorite Excel shortcuts. Keep it near your computer so you can quickly check unfamiliar combinations.

5. Practice With Real Data

Create a simple spreadsheet containing names, numbers, dates, and prices. Practice sorting, filtering, formatting, and calculating data using keyboard shortcuts.

500 excel shortcut keys pdf

download cultural diversity pdf
200+ Excel Keyboard Shortcuts to Work Faster (Complete Guide)

Frequently Asked Questions About Excel Keyboard Shortcuts

1. What are the 5 most useful Excel keyboard shortcuts?

The five most useful Excel keyboard shortcuts are:
Ctrl + C: Copy
Ctrl + V: Paste
Ctrl + Z: Undo
Ctrl + S: Save
Ctrl + F: Find

2. What is the shortcut key for saving an Excel file?

Ctrl + S is the shortcut key for saving an Excel workbook.

3. What is the shortcut key for creating a new worksheet?

Press Shift + F11 to insert a new worksheet in Excel.

4. What is the shortcut key for AutoSum in Excel?

Press Alt + = to insert the AutoSum formula into a selected cell.

5. What is the shortcut key for finding data in Excel?

Press Ctrl + F to open the Find dialog box and search for specific information.

6. What is the shortcut key for deleting a row in Excel?

Select the row using Shift + Spacebar and press Ctrl + Minus (-) to open the Delete dialog box.

8. Can I use the same Excel shortcuts on Mac?

Some shortcuts work similarly on Windows and Mac, but many are different. For example, Ctrl + C on Windows is generally Command + C on Mac. Always check the shortcut instructions for your operating system.

9. How can I learn Excel shortcuts quickly?

Start with 10 basic shortcuts and practice them daily. Gradually learn shortcuts for formatting, formulas, navigation, and data management.

10. Are Excel keyboard shortcuts the same in every version?

Most common shortcuts work across modern desktop versions of Excel. However, some ribbon commands, web shortcuts, and operating-system-specific combinations may differ.

Conclusion

Excel keyboard shortcuts are an excellent way to save time and improve productivity. Whether you are a student, accountant, teacher, office employee, or business professional, learning these shortcuts can make your spreadsheet work easier and faster.

You do not need to memorize all 200+ shortcuts immediately. Start with the most frequently used combinations and practice them regularly. As you become more comfortable, gradually learn the advanced shortcuts for formulas, formatting, charts, and data management.

Remember: The more you practice Excel keyboard shortcuts, the less you need to depend on your mouse.

Myself Krishna A Certified Digital Content Writer and Expert Fluent Speaker with a Nicer in Public speaking, English Language Teacher, Life lessons,, Institutes an Personal Development. I enjoy giving life to my hearty musings through my blogs.

Item added to cart.
0 items - $0.00