Hello,
In Libreoffice, calc spreadsheet,
how can I enter same data in several cells same row, without using copy ^ paste about 70 or more times.
Answers will be appreciated.
Thanks
Motim
OS win 10 pro, 19045.4529, x64
Libreoffice version 24.2.3.2
If the “several cells” are selected as a single cell range (and the focus cell, the one with the border, isn’t an unselected cell outside), simply type or paste-in your new content and hit Alt+Enter.
If the selection is multi-range this won’t work, but with multiple selected sheets it does…
for ref. from Shortcut Keys for Spreadsheets :
and if “several cells” are explicitely referencing a main one, then one input will show up everywhere.
