Ask Your Question

Calc-how do I maintain formatting?

asked 2018-06-05 13:36:08 +0200

MikeAgner gravatar image

In Excel, if you highlight several rows and columns, then apply formatting - say, make the text always centered- Excel propagates that formatting to everything that is highlighted. This is an easy way of keeping data in your spreadsheet readable.

I was copying something from a website and pasting it into a cell that I had pre-formatted, and it seems to turn all the formatting off. I then have to go back and reset the formatting just for that cell. It's very clumsy. Anyone have a work around for this? TIA Mike

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-06-05 14:38:37 +0200

erAck gravatar image

Paste as raw (unformatted) text, Shift+Ctrl+V, or from the Paste icon's arrow list choose "Unformatted text".

edit flag offensive delete link more

answered 2018-06-07 03:26:13 +0200

MikeAgner gravatar image

Thanks I'll try that...Mike

edit flag offensive delete link more


Please post comments as comment instead of answer. Thanks.

erAck gravatar imageerAck ( 2018-06-07 18:05:37 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-05 13:36:08 +0200

Seen: 41 times

Last updated: Jun 07 '18