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 Beta Channel Insider level.
Python in Excel is gradually rolling out to Excel for Windows customers using the Beta Channel. At this time, the feature is not available on other platforms.
If you encounter any issues 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. |
Related articles
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
