[Feature request] Batch insert

[kpodp0ra]

Is your feature request related to a problem? Please describe.
I'm always frustrated when I need to quickly populate multiple selected cells with the same value, but there’s no easy way to do so. Currently, I can delete multiple selected rows by selecting them and pressing Backspace. However, there's no equivalent functionality for inserting a value into multiple selected cells at once.

Describe the solution you'd like
I would like the ability to type a value (e.g., "0"), press Enter, and have all selected cells filled with that value. This would streamline workflows where bulk editing of cells with a single value is needed.

Describe alternatives you've considered

• Copying and pasting the desired value into each cell manually, which is time-consuming and inefficient.
• Using external scripts or plugins to achieve this functionality, which adds unnecessary complexity.

Additional context
Here is a video demonstrating the current behavior, where Backspace deletes selected cells:

video-2024-12-06_01.15.06.webm

The proposed feature would allow users to insert a value into multiple selected cells in a similarly intuitive manner.

[tea-artist]

At present, we support batch editing by copying a cell -> selecting an area -> pasting. Have any products ever implemented the interaction you proposed?

[kpodp0ra]

@tea-artist Yea, I use this feature quite frequently in JetBrains Datagrip

https://www.jetbrains.com/help/datagrip/cells.html#modifying_multiple_cells

video-2024-12-06_04.22.49.webm