We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Libre Office Calc - make a cell manually updatable only
Options

JohnB47
Posts: 2,665 Forumite


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
Comments
-
Highlight the row then use ctrl-left click the cell you don't need perhaps?
4.8kWp 12x400W Longhi 9.6 kWh battery Giv-hy 5.0 Inverter, WSW facing Essex . Aint no sunshine ☀️ Octopus gas fixed dec 24 @ 5.74 tracker again+ Octopus Intelligent Flux leccy1 -
Hmmm. I've just tried that and things go weird. The cells after the left click one seem to come to the left and the whole pasted row is rearranged.
I was hoping that there was a way to make the particular cell updatable by manual only, not by copy and paste.0 -
Updating it manually after c&p will overwrite whatever was pasted. Is that adequate?0
-
Yes of course. It's not a big problem, more of a curiousity really. I just thought it would be handy being able to set the cell to be not included in the copy/paste.0
-
You could write a macro to do it. Although, depending on how often you do it, that's probably more effort than it justifies1
-
Ok, let's close this one. Thanks for all the replies. It was just a curiousity.
I'll continue just copy and pasting then deleting the appropriate cell afterwards. Cheers.0
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.6K Banking & Borrowing
- 253K Reduce Debt & Boost Income
- 453.4K Spending & Discounts
- 243.6K Work, Benefits & Business
- 598.4K Mortgages, Homes & Bills
- 176.8K Life & Family
- 256.8K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards