Ask Your Question

how do I copy a row's formatting (but not the values) into another row in LibreOffic Calc

asked 2019-02-06 19:57:21 +0100

ecfromm gravatar image

updated 2020-09-21 23:16:43 +0100

Alex Kemp gravatar image

Never mind. It is the same I guess as for microsoft office: place cursor in the row number "cell", type ctrl-c (copy), then shift-spacebar (selects entire row), then ctrl-shift-v (paste special), and then enable copying only formats from the resulting menu and click "OK".

On the other hand, let me know if there is an easier way.



edit retag flag offensive close merge delete


I don't know about the shortcut keys. I always avoid them because I find it too easy to get them confused, and always use the menus instead.

So, highlight the row I want to copy formats from. Menu Edit -> Copy. Then move cursor to row where I want them copied. Click once in the first cell, menu Edit -> Paste Special. Select only Formats. OK. Unless I have forgotten something, it should work every time.

ve3oat gravatar imageve3oat ( 2019-02-06 22:11:03 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-02-06 22:35:54 +0100

m.a.riosv gravatar image

Use the clone formatting Icon, it is just after the paste icon.

Clone formatting

edit flag offensive delete link more

answered 2020-02-25 13:37:54 +0100

alvarolf gravatar image

No, it doesn't work. I tried.

edit flag offensive delete link more


Please use the comments.

m.a.riosv gravatar imagem.a.riosv ( 2020-02-25 16:32:22 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-06 19:57:21 +0100

Seen: 822 times

Last updated: Feb 25 '20