Ask Your Question

How do I copy a calc sheet format?

asked 2018-11-03 15:54:22 +0100

Liberty gravatar image

I want to copy the formatting to a new sheet. I don't need the Data. I know thee must be a simple way to do this, but I haven't figured it out.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-11-05 00:54:51 +0100

Liberty gravatar image

Clicking on the top left corner was my problem, instead I selected A:1 <ctrl>A, <ctrl>C and then spececl pasted to the new sheet. I don't know why clicking the little upper left hand box didn't do the trick. I am using LO 6.1.2

edit flag offensive delete link more

answered 2018-11-03 16:39:30 +0100

laurencio gravatar image

updated 2018-11-03 16:59:50 +0100

It is a simple Copy-Paste. But you have to paste only formats (with the Paste special option)

try this: 1- Select the entire sheet: click on the top-left corner (column and row headers) 2- Copy the sheet: <ctrl> + <c> (or with the mouse: Right Click > Copy) 3- Open a new sheet 4- Position en the the A1 cell (the default) 5- On the menu bar: Edit > Paste Special ( or with the mouse: Right Click > Paste special > Paste special) 6- Paste only formats: on the menu: uncheck everything but Formats. Click on OK. (or just press Enter if OK button is highlighted)

edit flag offensive delete link more


Could not get this to work in LO Calc Version:

jspreadsheet gravatar imagejspreadsheet ( 2019-05-02 16:54:51 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-03 15:54:22 +0100

Seen: 569 times

Last updated: Nov 05 '18