Ask Your Question
0

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.

thanks,

-eric

edit retag flag offensive close merge delete

Comments

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
0

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

alvarolf gravatar image

No, it doesn't work. I tried.

edit flag offensive delete link more

Comments

Please use the comments.

m.a.riosv gravatar imagem.a.riosv ( 2020-02-25 16:32:22 +0100 )edit
0

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 800 times

Last updated: Feb 25 '20