Ask Your Question

How to make exact copies of cells?

asked 2018-08-20 22:30:37 +0100

DreamCode gravatar image

updated 2018-08-21 00:18:01 +0100

I need to copy some rows but not only the content - I need to copy the row heights and the cell widths too.

I need to copy 40 rows, and I need to copy them in the same sheet, just below the rows I copy. Most of the rows have 7 millimeters in height but some of them have 5 or 6 millimeters. When I copy the rows, they are not preserving the row height, but only the content. If I copy the rows on another sheet, then it won't preserve the cell widths.

Is it possible to make exact copies of the cells?

Later edit: I am using LibreOffice, the 32 bit version on Windows 8.1 - 64 bit

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-20 23:25:58 +0100

Liberty Belle gravatar image

You don't say what computer, operating system, or version of LO you are using. On my Mac with version of LO, copy and paste on the same sheet preserves everything, while copy and paste to a different sheet doesn't preserve column width.

Try using the Edit > Paste Special command and tick the Formats box.Edit Paste Special

edit flag offensive delete link more


Thanks. It didn't work in my version of LibreOffice but I noticed something: When I copy, I can preserve the row heights if I select rows instead of selecting cells.

DreamCode gravatar imageDreamCode ( 2018-08-21 01:00:22 +0100 )edit

I guess I thought it was obvious that you would be selecting rows instead of cells, since that's what you were asking about.

Might want to think about upgrading to a more recent version of LO.

Liberty Belle gravatar imageLiberty Belle ( 2018-08-21 01:07:32 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-20 22:30:37 +0100

Seen: 140 times

Last updated: Aug 21 '18