Microsoft Excel Keyboard Shortcuts

Excel keyboard shortcuts are key combinations that let you enter data, format cells, navigate sheets, and manage files without reaching for the mouse. The right shortcuts speed up the repetitive parts of spreadsheet work—copy/paste, inserting rows, filtering tables, and cleaning formatting—so you can stay focused on the numbers instead of the interface.

Choose your Platform

Shortcuts differ by platform because modifier keys and system conventions change. Windows uses Ctrl/Alt heavily, while macOS relies on Command (⌘)/Option (⌥). Mobile shortcuts usually require an external keyboard and support a smaller set of commands. The Web version is also affected by browser behavior (some keys are reserved by the browser or OS). Choose your platform and practice on the exact setup you use most. Choose your platform above.

What is Microsoft Excel?

Microsoft Excel is a spreadsheet application used for organizing data, performing calculations, building tables, and creating charts. It’s widely used for budgets, forecasting, reporting, inventory tracking, dashboards, and analysis—both in personal workflows and in business teams. Excel supports formulas and functions, structured tables, sorting and filtering, charting, and tools for cleaning and reshaping data.

Excel is available as a desktop app on Windows and macOS, as mobile apps on iOS and Android, and as a Web version in a browser. The core idea stays the same across platforms—cells arranged in rows and columns—but the interface and key handling can differ. That’s why a short set of keyboard shortcuts is valuable: most spreadsheet time is spent on small repeated actions (selecting ranges, inserting rows, formatting, filtering), and shortcuts turn those actions into fast, predictable commands.

Boost Productivity with Microsoft Excel Keyboard Shortcuts

After selecting your platform, you’ll get access to platform-specific cheat sheets for the actions you perform daily. These shortcuts let you complete common spreadsheet tasks faster than using menus.

Why learn them

  • Less clicking: fewer trips to the Ribbon and context menus.
  • Faster cleanup: formatting, selection, and edits happen immediately.
  • Better flow: you stay in the grid and keep your attention on the data.
  • More consistent work: repeatable commands reduce mistakes and rework.
  • Quicker troubleshooting: you can filter, find, and adjust sheets without breaking focus.

Clipboard and paste

Cut, Copy, and Paste are some of the most frequently used actions in any spreadsheet workflow and are the quickest way to take advantage of Excel shortcuts. For more precise control, you can use Paste Special, which allows you to choose specific options after opening the command. When your main goal is to paste only the values, the Paste only the values (not formulas) and number formats from copied cell command provides a fast and efficient routine.

Rows and columns

Select entire row and Select entire column are frequent actions in cleaning and maintaining data, so it’s important to select the row or a cell within it first to ensure the command applies correctly. Open the Insert dialog box is used for inserting new rows or columns, and creating new sheets is another repeated task that helps organize your work efficiently.

Cells and highlighting

When formatting headers, section labels, or blocks of data, using shortcuts can save many small, repetitive clicks. Merge cells is a common task, though it can be overused, so it’s best applied only when needed. Choosing a fill color helps highlight important areas and organize your data visually.

Data and filtering

Filtering is one of the most effective ways to speed up work in Excel, as it reduces scrolling and manual searching in large tables. Filter shortcut combined with Find makes it even faster to locate specific values within big sheets. Save workbook and Save As are easy to overlook until you’re under pressure, for example when closing a workbook (Close a workbook), opening a workbook (Open a workbook), sharing a copy, or exporting a report. When working with multiple workbooks, learning both window switching at the operating system level and workbook switching within Excel helps you move between files efficiently without hunting for tabs.

Printable PDF

A printable reference helps because shortcut learning is repetition-driven: glance, execute, move on. A one-page sheet beside your keyboard is especially useful for onboarding, team training, or switching between Windows and macOS where Ctrl vs Command can trip you up.

On HKeys, you can download a PDF version and print it as a desk reference. Keep the printout action-based (Frequently used, Ribbon, Navigation, Formatting, Selection & Actions, Data & Formulas, Refresh, Power Pivot) so it stays scannable during real work, not just as a long list.

References

This section lists official sources and documentation for Microsoft Excel:

Use official references to confirm the current shortcut list for your platform (Windows, macOS, mobile, or Web), because key combinations and Ribbon access patterns can differ between editions and keyboard layouts.

Official references useful for troubleshooting when a shortcut doesn’t work due to system-level conflicts, custom keyboard settings, laptop function-key modes, or browser-reserved keys in the Web version.

Want to suggest a new app, report a bug, or get help? Email us at info@hkeys.appCopy email.

For anything else or just a quick hello, write to us at info@hkeys.appCopy email.