Ask Your Question
0

How do I copy a calc sheet format?

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

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
0

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

laurencio gravatar image

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

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

Comments

Could not get this to work in LO Calc Version: 6.2.2.2.

jspreadsheet gravatar imagejspreadsheet ( 2019-05-02 16:54:51 +0200 )edit
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 226 times

Last updated: Nov 05 '18