Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2020, 11:27 PM
shansid shansid is offline How do I copy a workbook to another workbook and keep the formatting within the new workbook Windows 10 How do I copy a workbook to another workbook and keep the formatting within the new workbook Office 2013
Novice
 
Join Date: Sep 2020
Posts: 4
shansid is on a distinguished road
Default

Copying workbook to a different MS Office version causes misalignment. In such conditions you have to use the Paste special option.
Reply With Quote
  #2  
Old 09-15-2020, 03:37 AM
Purfleet Purfleet is offline How do I copy a workbook to another workbook and keep the formatting within the new workbook Windows 10 How do I copy a workbook to another workbook and keep the formatting within the new workbook Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

i would do as ArviLaanemets suggested, the safest way to keep all formulas and formatting the same, especially in a multi worksheet workbook.

it is possible to select all sheets, right click on the worksheet tab, move or copy, tick create a copy and select new book.

But there isnt look of difference between the 2
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing a Workbook that contains array formula link to other workbook Ahmad.rage22@gmail.com Excel 0 03-12-2018 10:15 PM
Copy data as well as formatting from one workbook to another. LearnerExcel Excel 1 03-10-2018 01:35 PM
vba code for integrating particular information from different workbook to one workbook klpw Excel Programming 1 12-28-2015 09:48 AM
data entered in one workbook should be updated in other relevant workbook based on the date vedha Excel 0 04-24-2015 08:45 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft