Libre Office Calc - make a cell manually updatable only

2.3K Posts


in Techie Stuff
In a Libre Office Calc spreadsheet, when you copy and paste a whole row, it copies and pastes all of the cells.
Is there an easy way to stop it copy/pasting one particular cell, so that it's contents are blank when pasted?
I want to update that cell manually after the copy/paste operation.
Thanks.
Is there an easy way to stop it copy/pasting one particular cell, so that it's contents are blank when pasted?
I want to update that cell manually after the copy/paste operation.
Thanks.
0
Latest MSE News and Guides
Childcare budget boost
More support for children from nine months and those on Universal Credit
MSE News
Replies
I was hoping that there was a way to make the particular cell updatable by manual only, not by copy and paste.
I'll continue just copy and pasting then deleting the appropriate cell afterwards. Cheers.