Wise Owl Answers - How do I resize a Word table after copying from Excel?
Check out our other answers here • Wise Owl Answers
Get files here https://www.wiseowl.co.uk/vba-macros/...
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
If you copy data from Excel to Word what happens if the table is too big for the page? This video shows you how to control the width of table columns in Word to make sure that everything fits on the page.
Chapters
00:00 The Question
00:44 Referencing the Word Object Library
01:34 Copying Excel Data to Word
02:49 Using the Autofit Method
04:14 Making Columns the Same Width
04:41 Setting the Preferred Width of the Table
05:37 Reducing the Table Width
07:12 Looping Through the Worksheets Collection
08:53 Adding Page Breaks
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Watch video Wise Owl Answers - How do I resize a Word table after copying from Excel? online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 04 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,821 once and liked it 121 people.