Ask Your Question

Calc How do you copy, then paste columns to another sheet preserving widths? [closed]

asked 2014-03-16 10:52:13 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am using the spreadsheet to create a number of similar forms, of which some of the content is shared by all forms. The first sheet has custom column widths and row heights. How do I select a rectangle from this sheet, copy it, and paste it to another sheet which has default widths and heights so that the pasted rectangle adjusts these dimensions to match those from the first sheet?

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 2016-02-20 07:58:47.565355

1 Answer

Sort by » oldest newest most voted

answered 2014-03-16 13:05:15 +0100

kumiponi gravatar image

updated 2014-03-16 13:52:29 +0100

Depending on the situation, the easiest way may be to first copy the first sheet (right-click on the tab, select Move/Copy Sheet). Then add in the parts that differ. Column width and row height are not cell properties, so if you copy a region, it will not copy the heights and widths, but if you instead copy whole columns or rows (select them by clicking the labels) the widths OR heights are carried over. If you'll be making a lot of the forms, you could create a template for it.

To copy just the widths or heights (and not the contents of the cells), copy the columns or rows, use Edit > Paste Special, and select only Formats.

edit flag offensive delete link more

Question Tools



Asked: 2014-03-16 10:52:13 +0100

Seen: 12,232 times

Last updated: Mar 16 '14