Python in Excel keyboard shortcuts
Applies To
For 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+F2 |
Launch the Python in Excel code editor task pane. |
|
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. Edit mode allows you edit the Python formula, and Enter mode allows you to select additional cells or ranges with your keyboard. |
|
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.
