Python in Excel keyboard shortcuts
Python in Excel is currently in preview and is subject to change based on feedback. To use this feature, join the Microsoft 365 Insider Program and choose the Current Channel (Preview) Insider level.
This feature is gradually rolling out to Enterprise, Business, Education, and Family and Personal users running Current Channel (Preview) on Windows. It's rolling out to Excel for Windows first, starting with Version 2406 (Build 17726.20016), and then to other platforms at a later date. For more availability information, see Python in Excel availability.
If you encounter any concerns with Python in Excel, please report them by selecting Help > Feedback in Excel.
New to Python in Excel? Start with Introduction to Python in Excel and Get started with Python in Excel.
List of keyboard shortcuts
The following list includes keyboard shortcuts that are helpful to know when using Python in Excel.
Shortcut |
Action |
---|---|
=PY |
Enables Python formulas in an Excel cell. |
Ctrl+Alt+Shift+C |
Changes a Python plot from an image object to linked floating plot. |
Ctrl+Alt+Shift+F9 |
Resets the Python runtime. May help resolve #BUSY! or #CONNECT! errors. |
Ctrl+Alt+Shift+M |
Toggles Python formula results between Python objects and Excel values. |
Ctrl+Alt+Shift+P |
Like =PY, enables Python formulas in the current cell. |
Ctrl+Enter |
Commits Python formulas in a Python cell. |
Ctrl+F2 |
Toggles between edit mode in the cell and the formula bar. |
Ctrl+Shift+F5 |
When a cell contains a card icon, additional data is available inside card. Ctrl+Shift+F5 opens the card to display the additional data. |
Ctrl+Shift+U |
Expands or collapses the Excel formula bar to view more or fewer lines of code. |
F2 |
Toggles between Enter mode and Edit mode in a Python cell. |
F9 |
When a workbook is in Manual Calculation or Partial Calculation mode, F9 recalculates the workbook. |