[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 917
  • Last Modified:

EXCEL - COPY WORKSHEET FORMATS, VALUES, TEXT BOXES

I want to copy a worksheet from 1 excel workbook into another workbook but when i try to do this the values and formats copy over but the text boxes have not copied over, please assist.
0
Frank .S
Asked:
Frank .S
  • 3
  • 3
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

how are you copying? If you right-click the sheet tab, select Move or Copy, then select a workbook in the top drop down, tick "Create a copy", the whole worksheet will be copied, text boxes and all.

cheers, teylyn
0
 
Frank .SBuilding EstimatorAuthor Commented:
hi teylyn, sorry should have provided more information. What has happened, is that I can only copy and paste into the other workbook because the worksheet in the other workbook has code which is working in the other workbook i'm wanting to copy to, so i need to copy the information only into a particular worksheet with existing code, i hope i have explained a little more clearly for you.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

if you can't copy the whole sheet, then you'll need to do this in two steps. First copy the cells with values and formats. Then go back to the source sheet and hit F5, click Special, select Objects and hit OK. Now all objects like text boxes, images, etc are selected. Use your favourite Copy command and paste into the target sheet.

Tip: When you paste the objects, they may appear out of place, since Excel pastes them to the left and top most position. In order to preserve the absolute location of the text boxes, create a new, helper text box in the source sheet on top of cell A1. Then select all objects, copy and paste to the target sheet. The top left text box will sit on top of A1 again and the other text boxes will be placed correctly, too. After that, select only the text box at A1 and delete it.

cheers, teylyn
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Frank .SBuilding EstimatorAuthor Commented:
hi teylyn, for some reason now it wont allow me to copy the old worksheet to the new one, i dont get the standard 'paste special' window, i get this other one and i dont know what to do, please see my posted screenshot and let me know what i need to do to get the std 'paste special' window again. paste special window
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This happens when the two workbooks are open in different instances of Excel.

Close the target workbook. Go to the source workbook and use File - Open to open the target workbook. Now they are in the same Excel instance and the Paste Special will show the options you need.

(this is really a different question and should have been posted separately)

cheers, teylyn
0
 
Frank .SBuilding EstimatorAuthor Commented:
thankyou so much teylyn
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now