We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc, clone formatting to a group of cells [closed]

asked 2020-11-17 18:52:41 +0200

smurf gravatar image

updated 2021-05-25 11:21:37 +0200

Alex Kemp gravatar image

In Calc, I want to clone formatting to lots of cells. I know about double-clicking the icon, but then I have to individually click on hundreds of cells to clone the formatting to each one. Is there a way I can select a group of cells and clone the formatting to all of them at once, instead of having to do it one at a time?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-25 11:21:44.497582

1 Answer

Sort by » oldest newest most voted

answered 2020-11-17 19:01:33 +0200

Opaque gravatar image

updated 2020-11-17 19:16:47 +0200


as long as the cell range you want to clone to is a contiguous range the method is:

  • Selecet the cell whose format you want to clone to other cell
  • Click the clone icon once
  • Move to the upper left cell of you desired range of cell
  • Click left mouse button (keep the button pressed)
  • Move over the range
  • Release the button when you are at the lower right corner of your desired range

image description

Note The double click method is intended for "non-contiguous" ranges of cells (which in terms of LibreOffice is often referred to as "multi-selection"), but it could be used for a single range as well; just keep the left mouse button pressed for a range)

Hope that helps.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2020-11-17 18:52:41 +0200

Seen: 41 times

Last updated: Nov 17 '20