
Master MS Excel shortcut keys with this complete guide. Covers 50+ shortcuts for navigation, formulas, filters, pivot tables, and more — with a free PDF cheat sheet. Built for Indian students and working professionals.
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]
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:
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.
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.
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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:
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.
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 |
| 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.
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:
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.
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.
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.
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.
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).
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.
Sign in to join the discussion and post comments.
Sign in