Ask Your Question

In Calc, how do you paste formatting using menus?

asked 2019-10-31 16:24:36 +0100

Persnickety1 gravatar image

updated 2020-08-09 11:20:32 +0100

Alex Kemp gravatar image

Select a cell, then use the keyboard to select "Format" menu > "Clone Formatting". (The paintbrush toolbar icon appears "pressed".) Then navigate to and select the cell(s) to receive the cloned formatting.

What keys do you press now to apply the cloned formatting?

  • The "Enter" key does nothing.
  • Selecting the "Format" menu again still shows "Clone Formatting" (not, say, "Paste Formatting").
  • Selecting "Format" menu > "Clone Formatting" turns off the cloning (or at least the paintbrush toolbar icon appears "unpressed").

To be more clear: I'm familiar with "Paste Special" ... but I'm wondering whether there is a one-level-deep "Paste Cloned Formatting" option just as easily available as "Format > Clone Formatting".

edit retag flag offensive close merge delete


If you use clone formatting you need to use mouse as well for pasting (you may notice the icon change). Using menu operations only, requires Edit -> Copy and Edit -> Paste Special -> Paste Special -> Cat: Selection - [x] Formats or CTRL+SHIFT+V (unselecting anything else). In that sense "clone formatting" is a shortcut for that.

Opaque gravatar imageOpaque ( 2019-10-31 17:03:34 +0100 )edit

Thank you, Opaque (and others). This is what I suspected: the (semi-cumbersome) "Paste Special" is the only counterpart to the (quickly-accessible) "Clone Formatting" command. I suppose having the first half of the operation easy-to-perform is better than having neither half easy to perform. ;-)

Persnickety1 gravatar imagePersnickety1 ( 2019-10-31 18:43:13 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-10-31 23:37:19 +0100

m.a.riosv gravatar image

After Copy, you can do it through [Ctrl+Shift+V] Menu/Edit/Paste special, if you only want to past the format, select only Formats.

edit flag offensive delete link more

answered 2019-11-01 13:05:41 +0100


  1. Select area to copy formatting.
  2. Click on the icon.
  3. The cursor changes
  4. Select the area to paste formatting.

image description

image description


ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-31 16:24:36 +0100

Seen: 318 times

Last updated: Nov 01 '19