search

microsoft / python-in-excel

Python in Microsoft Excel
MIT License
490 stars 31 forks source link

Why `Ctrl+Enter` instead of `Shift+Enter` to run a cell? #29

Open fzumstein opened 10 months ago

fzumstein commented 10 months ago

Jupyter notebook uses Shift+Enter so I am hitting that all the time before remembering that it is Ctrl+Enter with Python in Excel...

keyur32 commented 10 months ago

Thank you for the report. Marking as enhancement for the team to take under consideration.

keyur32 commented 10 months ago

One note is Shift+Enter was already taken by Excel formulas. It will commit the formula and move the cell up one row.

That said, we'll continue to look to see if there's folks working in Python that might be prefer Shift+enter instead of ctrl+enter while in Beta.

ncalm commented 10 months ago

Shift+Enter is "Run cell and create new or select cell below" in Jupyter notebooks and Ctrl+Enter is "Run cell".

For me at least, the latter and current implementation is more natural for "Run Python cell" in Excel.

fzumstein commented 10 months ago

Fair point, so Shift+Enter should be introduced as an additional shortcut rather than replacing Ctrl-Enter to run the Excel cell and move the cursor to the next Python cell.

SergeiStPete commented 10 months ago

Just in case, in Power Pivot formula bar Shift+Enter means new line. For Excel data modellers it could be confusing to use it another way.

fzumstein commented 6 months ago

One note is Shift+Enter was already taken by Excel formulas. It will commit the formula and move the cell up one row.

The counter argument to this is that Enter also reacts differently in a PY cell than with Excel formulas...