[Solved] Copy & paste sheet including layout format not working

Discuss the spreadsheet application
Locked
DavidMWright
Posts: 38
Joined: Thu May 22, 2014 10:45 am

[Solved] Copy & paste sheet including layout format not working

Post by DavidMWright »

In the past I've been able to copy and past an entire sheet by selecting the top L cell and then ctrl-click, then select the same cell in a new sheet and the entire sheet is duplicated. I've found this to be really helpful when I want to create fresh sheets with the same format.
Recently I've not been able to do this - something has clearly changed - is there a way to do what I want?
Last edited by DavidMWright on Tue Dec 13, 2022 10:49 pm, edited 1 time in total.
Neo Office 2017.33 on Mac OS10.12.6
FJCC
Moderator
Posts: 9640
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Copy & paste sheet including layout format not working

Post by FJCC »

The procedure you describe is not quite what I am familiar with. You can click on the "cell" just to the left of the A column header and the whole sheet will be selected. You can then use CTRL + C or Edit -> Copy to copy the sheet contents and paste them in another sheet.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
Villeroy
Volunteer
Posts: 31365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Copy & paste sheet including layout format not working

Post by Villeroy »

Right-click sheet tab and choose Move/Copy Sheet
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
DavidMWright
Posts: 38
Joined: Thu May 22, 2014 10:45 am

Re: Copy & paste sheet including layout format not working

Post by DavidMWright »

FJCC - what you describe is exaclty what I've been doing. I'm using Neo Office on a Mac so maybe something has changed there?

Villeroy - Many thanks for this - it does indeed do what I want.
Neo Office 2017.33 on Mac OS10.12.6
Locked