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?
[Solved] Copy & paste sheet including layout format not working
-
DavidMWright
- Posts: 38
- Joined: Thu May 22, 2014 10:45 am
[Solved] Copy & paste sheet including layout format not working
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
Re: Copy & paste sheet including layout format not working
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Copy & paste sheet including layout format not working
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
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
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.
Villeroy - Many thanks for this - it does indeed do what I want.
Neo Office 2017.33 on Mac OS10.12.6