Ask Your Question

How can I copy an entire cell, paste/merge it into a new cell, and retain the formatting in the new cell? [closed]

asked 2014-09-21 10:55:18 +0100

mpkettle gravatar image

updated 2020-07-12 23:38:33 +0100

Alex Kemp gravatar image

Merging several rows into one row in Calc Spreadsheet.

In the past you have helped me with some unusual problems . Here is my latest !

I am using a macbook 10.6.8. I have transferred File Maker Pro data to Calc Spreadsheet using merge (.mer) files. This is an example of a problem I am having. I have set all columns to 10 font. C3 - C10 are rows all of which contain only one line of data. (This is all text) When I copy and paste C3 to C2 (via line input) the result in C2 is an exact copy of C3 (10 font). When I copy and paste C3 plus C4 (or more rows) to C2, the result is a different font, approximately 12. If I change the font size of C2 to 11, the result becomes slightly smaller than the original 10 font. I have changed the setting in "Preferences" "View" "Scaling", but this doesn't help at all. Manually changing the font in C2 may be the only solution but is there another way ? Note - The above is only a simplified example. Thanks for any help. Maurice.

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-03-03 22:59:28.626839


"When I copy and paste C3 to C2 (via line input)": Is this done by editing C2 and appending a copied content of C3?

"When I copy and paste C3 plus C4 (or more rows) to C2": Would you, please, explain how, exactly, you proceed performing this?

How does this relate to the subject of your question ("Merging..")?

Could you supply a simplified example as a functional Calc document, please? This document should also contain an example of what you hope (expect) to get as the result of "Merging..".

Lupp gravatar imageLupp ( 2014-09-21 12:14:40 +0100 )edit

Hi Mr Lupp - Thanks (as usual) for your very prompt reply. By sheer determination I found and tried "Merge" late last night. It is much easier than my method and does exactly what I needed. Maurice (81.5 years young) ! Thanks again !

mpkettle gravatar imagempkettle ( 2014-09-22 05:18:29 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-09-22 05:22:54 +0100

mpkettle gravatar image

"Format" "Merge cells" works perfectly.

edit flag offensive delete link more

Question Tools


Asked: 2014-09-21 10:55:18 +0100

Seen: 462 times

Last updated: Sep 23 '14