MS Excel Shortcut Keys: The Complete Guide to Work 10x Faster (2026)

Picture this: your manager asks you to clean up an MIS report with 5,000 rows — right before lunch. You start clicking through menus, hunting for Format Cells, reaching for the mouse every ten seconds. Meanwhile, the colleague sitting next to you is already done — and they haven't touched the mouse once.

The difference? MS Excel shortcut keys.

Learning excel shortcut keys is one of the highest-ROI skills you can pick up as a student, fresher, or data professional in India. Whether you are preparing MIS reports, building salary slips, or analysing sales data, the right keyboard shortcuts can cut your work time in half — sometimes more. In this guide, you will find a complete list of shortcut keys of MS Excel, organised by category, along with tips to use them, a free PDF cheat sheet, and answers to the most-asked questions. [Explore Excel tutorials on Dynamic Duniya]

Why Learn MS Excel Shortcut Keys?

Most people who use Excel regularly still rely heavily on the mouse. That is not wrong — but it is slow. Once you start using shortcut keys in excel, you will immediately notice the difference. Here is why it matters:

Speed: Keyboard shortcuts are 2–5x faster than navigating menus. Tasks that take 30 seconds with a mouse take under 5 seconds with the right key combo.
Accuracy: Fewer mouse clicks mean fewer accidental misclicks. Your hands stay on the keyboard, and your focus stays on the data.
Interview edge: Many data analyst and MIS executive job interviews test practical Excel skills. Knowing how to use keyboard shortcuts in Excel instantly signals competence to recruiters.
Professional impression: In an Indian corporate environment — whether it is a BPO, an IT company, or a bank — Excel fluency is expected. Shortcut mastery separates average users from power users.
Reduced fatigue: Constantly switching between keyboard and mouse is physically tiring during long work sessions. Staying on the keyboard keeps you faster and more comfortable.

How to Use Keyboard Shortcuts in Excel

Using Excel shortcuts does not require any setup or configuration. Every shortcut works the moment you open Microsoft Excel on Windows or Mac. Simply press the key combination while the workbook is active — no need to click into any menu first.

On Windows: Most shortcuts use Ctrl as the base key (e.g., Ctrl + C to copy). Some advanced shortcuts involve the Alt key or Function (Fn) keys.
On Mac: Replace Ctrl with Cmd (⌘) for most shortcuts (e.g., ⌘ + C to copy). A few shortcuts differ significantly on Mac — where noted below, both versions are listed.
Pro tip: If you are on a laptop, make sure the Fn Lock is off when using function-key shortcuts like F2 or F4. This is a common source of confusion for new learners.

50 Shortcut Keys of MS Excel — Complete List by Category

Below is the most comprehensive list of ms excel shortcut keys organised into 10 categories. Each table is designed to be scannable — bookmark this page or download the PDF cheat sheet to keep it handy.

1. Basic Navigation Shortcuts

These shortcuts help you move around a spreadsheet without lifting your hands off the keyboard — essential for working with large data sets like attendance registers or sales reports.

Shortcut Key (Windows)	Action	Category
Arrow Keys	Move one cell in any direction	Navigation
Ctrl + Home	Go to cell A1 (beginning of sheet)	Navigation
Ctrl + End	Go to the last used cell in the sheet	Navigation
Ctrl + Arrow Key	Jump to the edge of a data region	Navigation
Page Up / Page Down	Scroll up or down one screen	Navigation
Alt + Page Up / Down	Scroll left or right one screen	Navigation
Ctrl + F	Open Find dialog	Navigation
Ctrl + G	Go To dialog (jump to any cell)	Navigation
Tab	Move to next cell in a row	Navigation
Shift + Tab	Move to previous cell in a row	Navigation

2. Selection Shortcuts

Working with large employee lists or product databases? These selection shortcuts save enormous time compared to clicking and dragging. The select all shortcut key alone is worth learning on day one.

Shortcut Key (Windows)	Action	Category
Ctrl + A	Select all cells in the sheet (select all shortcut key)	Selection
Ctrl + Shift + End	Select from current cell to last used cell	Selection
Ctrl + Shift + Home	Select from current cell to A1	Selection
Shift + Arrow Key	Extend selection by one cell	Selection
Ctrl + Shift + Arrow Key	Extend selection to edge of data region	Selection
Ctrl + Space	Select entire column	Selection
Shift + Space	Select entire row	Selection

3. Copy, Cut & Paste Shortcuts

These are the most-used copy paste shortcut key combinations in any Excel workflow. The paste special shortcut is particularly powerful — it lets you paste only values, formats, or formulas independently.

Shortcut Key (Windows)	Action	Category
Ctrl + C	Copy selected cells	Copy / Paste
Ctrl + X	Cut selected cells	Copy / Paste
Ctrl + V	Paste	Copy / Paste
Ctrl + Alt + V	Paste Special dialog (paste special shortcut)	Copy / Paste
Ctrl + D	Fill Down — copy top cell to selected range below	Copy / Paste
Ctrl + R	Fill Right — copy leftmost cell to selection	Copy / Paste
Ctrl + Z	Undo last action	Copy / Paste
Ctrl + Y	Redo last action	Copy / Paste

4. Formatting Shortcuts

Stop digging through the ribbon every time you need to bold a header or format a salary column as currency. These shortcuts handle the most common formatting tasks instantly.

Shortcut Key (Windows)	Action	Category
Ctrl + B	Bold	Formatting
Ctrl + I	Italic	Formatting
Ctrl + U	Underline	Formatting
Ctrl + 1	Open Format Cells dialog	Formatting
Ctrl + Shift + $	Apply Currency format	Formatting
Ctrl + Shift + %	Apply Percentage format	Formatting
Ctrl + Shift + #	Apply Date format (dd-mmm-yy)	Formatting
Ctrl + Shift + ~	Apply General number format	Formatting
Alt + H + B	Open border menu	Formatting
Ctrl + Shift + L	Toggle AutoFilter (also a filter shortcut in excel)	Formatting

5. Formula & Function Shortcuts

These shortcut excel formulas keys are indispensable for data analysts. Whether you are auditing a formula in a salary slip or quickly summing a column of figures, these shortcuts speed up your formula workflow significantly.

Shortcut Key (Windows)	Action	Category
= (Equals)	Start a formula in a cell	Formulas
Alt + =	AutoSum selected range	Formulas
F2	Edit the active cell (enter edit mode)	Formulas
F4	Toggle absolute / relative reference ($ signs)	Formulas
Ctrl + `	Toggle show formulas vs values in all cells	Formulas
Ctrl + Shift + Enter	Enter an array formula	Formulas
Shift + F3	Open Insert Function (fx) dialog	Formulas
Ctrl + [	Go to precedent cells (trace formula source)	Formulas
F9	Recalculate all formulas in the workbook	Formulas

6. Filter Shortcuts in Excel

Filtering is one of the most common actions in Excel data work — from filtering a product list by city to isolating entries from a specific month. Knowing the shortcut for filter in excel saves multiple clicks every single time.

Shortcut Key (Windows)	Action	Category
Ctrl + Shift + L	Apply / Remove AutoFilter (filter shortcut in excel)	Filter
Alt + Down Arrow	Open the AutoFilter dropdown for the selected cell	Filter
Alt + Down Arrow → E	Clear the filter from the selected column	Filter
Ctrl + Shift + F	Open Advanced Filter dialog	Filter

7. Pivot Table Shortcut Keys

Pivot tables are the backbone of MIS reporting in India. These pivot table shortcut key combinations help you build and manage pivot tables faster, without hunting through the ribbon.

Shortcut Key (Windows)	Action	Category
Alt + N + V	Insert a new PivotTable	Pivot Table
Alt + JT + R	Refresh the PivotTable (pivot table shortcut key)	Pivot Table
Alt + JT + E	Clear the entire PivotTable	Pivot Table
Alt + JT + F	Insert a PivotTable slicer	Pivot Table
Ctrl + Shift + *	Select the entire PivotTable	Pivot Table
Double-click on value cell	Drill down / show source data for that value	Pivot Table

8. Print & File Shortcuts

Before sending out a report, you often need to save, print, or preview it. These print shortcut key combinations let you do that instantly.

Shortcut Key (Windows)	Action	Category
Ctrl + S	Save the workbook	File / Print
Ctrl + Shift + S	Save As	File / Print
Ctrl + P	Print (print shortcut key)	File / Print
Ctrl + F2	Open Print Preview	File / Print
Ctrl + N	Create a new workbook	File / Print
Ctrl + O	Open an existing workbook	File / Print
Ctrl + W	Close the current workbook	File / Print
Alt + F4	Close Excel entirely	File / Print

9. Workbook & Sheet Navigation

Working across multiple sheets in a single workbook — like separate sheets for each month's attendance or each product category — is much easier with these sheet navigation shortcuts.

Shortcut Key (Windows)	Action	Category
Ctrl + Page Down	Move to the next sheet (right)	Sheets
Ctrl + Page Up	Move to the previous sheet (left)	Sheets
Alt + Shift + F1	Insert a new worksheet	Sheets
Ctrl + F6	Switch between open workbooks	Sheets
F11	Create a chart from selected data (in new sheet)	Sheets
Alt + F8	Open Macro dialog	Sheets

10. Refresh & Miscellaneous Shortcuts

These miscellaneous shortcuts round out your toolkit — including the shortcut key for refresh in Excel, which is especially useful when working with data connections or pivot tables linked to external sources.

Shortcut Key (Windows)	Action	Category
F5	Open Go To dialog	Misc
Ctrl + Alt + F5	Refresh all data connections (shortcut key for refresh)	Misc
Alt + F5	Refresh selected PivotTable only	Misc
Ctrl + T	Create a Table from selection	Misc
Ctrl + K	Insert a hyperlink	Misc
Ctrl + H	Find and Replace	Misc
Ctrl + ;	Insert today's date	Misc
Ctrl + Shift + :	Insert current time	Misc
Escape (Esc)	Cancel current entry or close dialog	Misc

MS Excel Shortcut Keys PDF — How to Download

Knowing these shortcuts is one thing. Practising them until they are muscle memory is another. The fastest way to do that is to keep a ms excel shortcut keys pdf on your desktop or printed next to your workstation — so you can glance at it while you work.

An excel shortcuts cheat sheet is particularly useful when you are just starting out. Instead of memorising everything at once, print the PDF and focus on one category per week. By the end of a month, the most important excel shortcut keys will feel natural.

Where to get a reliable MS Excel shortcut keys PDF:

Microsoft's official support site — search "Excel keyboard shortcuts" on support.microsoft.com to find the most up-to-date, version-specific list.
Dynamic Duniya Excel resources — we are working on a downloadable pdf excel shortcut keys cheat sheet, formatted for easy printing. Watch this space. [Download Excel Shortcuts PDF — Coming Soon]
ExcelJet.net — a well-regarded third-party resource for Excel shortcut PDFs with clean formatting.

Tip: When you download an excel shortcut keys pdf, choose the Windows version if you are on a PC and the Mac version if you are on a MacBook. The shortcuts differ in several places, and using the wrong reference will only confuse you.

Excel Shortcut Keys vs MS Word Shortcut Keys

Many Indian students and professionals use both Excel and Word daily — for data work in Excel and reports or letters in Word. It is helpful to know where the ms word shortcut keys overlap with Excel shortcuts, and where they differ. The table below highlights the most important differences.

Action	MS Excel Shortcut	MS Word Shortcut Key
Bold	Ctrl + B	Ctrl + B
Italic	Ctrl + I	Ctrl + I
Underline	Ctrl + U	Ctrl + U
Save	Ctrl + S	Ctrl + S
Find	Ctrl + F	Ctrl + F
Undo	Ctrl + Z	Ctrl + Z
Select All	Ctrl + A	Ctrl + A
Print	Ctrl + P	Ctrl + P
New document / workbook	Ctrl + N	Ctrl + N
Format Cells / Font dialog	Ctrl + 1	Ctrl + D
Insert Table	Ctrl + T	Not a direct shortcut
Sum a range	Alt + =	Not applicable
Toggle formula view	Ctrl + `	Not applicable
New paragraph / new row	Alt + Enter (in cell)	Enter
Open Header / Footer	Not direct shortcut	Alt + N + H

As you can see, the core ms word shortcut key combinations for basic editing (Ctrl + C, B, I, U, S, Z) are identical in Excel. The differences appear mainly in formatting and document-specific actions. This makes switching between the two tools easier once you learn the fundamentals.

Tips to Memorise Excel Shortcut Keys Fast

Learning laptop shortcut keys or any set of keyboard shortcuts is not about cramming — it is about consistent, deliberate practice. Here are five proven tips that actually work:

Start with just 5 shortcuts. Pick the five you use most often — Ctrl + C, Ctrl + V, Ctrl + Z, Ctrl + S, and Ctrl + Home. Use only those for a week, completely ignoring the mouse for those actions. Once they are automatic, add five more.
Print or pin the cheat sheet. Stick a printed copy of the computer shortcut keys you are learning near your monitor. Visual reminders are far more effective than trying to recall from memory while you work.
Use the "no mouse" rule for 30 minutes a day. Pick a task — like cleaning a dataset or building a pivot table — and complete it using only keyboard shortcuts. This forces your hands to find the shortcuts rather than defaulting to the mouse.
Learn in categories, not in order. Do not try to learn all 50 shortcuts top-to-bottom. Learn Filter shortcuts this week, Formula shortcuts next week. Grouped learning sticks better because the shortcuts share a context.
Teach someone else. Explaining a shortcut to a classmate or colleague — or writing about it — cements it in your memory far faster than passive reading. This is especially useful if you are creating Excel content or tutorials.

Frequently Asked Questions

Q1. What are the 50 shortcut keys of MS Excel?

The 50 most important ms excel shortcut keys cover navigation (Ctrl + Home, Ctrl + End), selection (Ctrl + A, Ctrl + Shift + End), copy/paste (Ctrl + C, Ctrl + V, Ctrl + Alt + V), formatting (Ctrl + 1, Ctrl + B, Ctrl + Shift + $), formulas (Alt + =, F2, F4), filtering (Ctrl + Shift + L, Alt + Down Arrow), pivot tables (Alt + N + V, Alt + JT + R), printing (Ctrl + P), sheet navigation (Ctrl + Page Down), and miscellaneous tasks (Ctrl + T, Ctrl + H, Ctrl + ;). The complete list with all 50+ shortcuts is available in the tables above and in our downloadable PDF.

Q2. How do I use keyboard shortcuts in Excel on a laptop?

Using keyboard shortcuts in Excel on a laptop works the same as on a desktop — press the key combination while your Excel workbook is open and active. The only difference on laptops is the Fn (Function) key. If shortcuts like F2 or F4 are not working, try pressing Fn + F2 or Fn + F4. Alternatively, enable Fn Lock on your laptop (usually Fn + Esc or Fn + Fn Lock key) so function keys work directly without holding Fn.

Q3. What is the shortcut key for filter in Excel?

The primary filter shortcut in excel is Ctrl + Shift + L — this toggles AutoFilter on or off for the selected data range. To open the filter dropdown on a specific column cell, use Alt + Down Arrow. To clear the filter on a column, press Alt + Down Arrow to open the dropdown, then press E.

Q4. What is the paste special shortcut in Excel?

The paste special shortcut in Excel is Ctrl + Alt + V. This opens the Paste Special dialog box, which lets you choose exactly what to paste — values only (removes formulas), formats only, column widths, formulas only, or comments. This is extremely useful when you want to copy calculated values from one sheet to another without carrying over the underlying formulas.

Q5. Where can I download MS Excel shortcut keys PDF?

You can download a ms excel shortcut keys pdf from Microsoft's official support website (support.microsoft.com — search "Excel keyboard shortcuts"), or from trusted Excel resources like ExcelJet.net. Dynamic Duniya is also publishing a free excel shortcut keys pdf cheat sheet — [check our Excel tutorials section] for the latest download link. Always make sure you download the version that matches your operating system (Windows or Mac) and your Excel version (2019, 2021, Microsoft 365).

Conclusion

MS Excel shortcut keys are not a luxury — they are a fundamental productivity skill for anyone who works with data, whether you are a fresher building your first resume-worthy portfolio or a working professional managing MIS reports every morning. The shortcuts covered in this guide span every major workflow: navigation, selection, copy-paste, formatting, formulas, filtering, pivot tables, printing, and more.

The best strategy is to start small: pick 5 shortcuts, use them exclusively for a week, and then layer in more. Within a month, you will notice a significant difference in how quickly — and confidently — you work in Excel. Download the cheat sheet PDF, pin it near your workstation, and practice every day.

Ready to take your Excel skills further? [Explore more Excel tutorials on Dynamic Duniya] — from beginner formulas to advanced data analysis. Bookmark this page so you always have the full shortcut list at your fingertips.