Copy Microsoft Excel Range & Keep Row/Column Sizes

In this Microsoft Excel tutorial, I will show you how to copy and paste data from one sheet to another while maintaining row heights and column widths. You'll learn basic techniques for entire sheets and delve into VBA to handle partial copies, ensuring both dimensions are preserved. Perfect for Excel beginners and developers alike.

John from Graham, Washington (a Platinum Member) asks: I need to copy data from one Excel sheet to another. On the source sheet, I've set the row heights and column widths the way I want, but when I copy the data to a new sheet, those sizes don't carry over. Is there a way to copy and paste data in Excel while keeping both row heights and column widths?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Excel VBA

Links

• Code Vault - Gold Members

Recommended Courses

• Excel VBA Course Info

Learn More!

• FREE Excel Beginner Level 1
• Excel Beginner Level 2 for $1.00
• Excel Forum
• Mailing List Notifications for New Videos

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

TechHelp Excel, Excel copy row heights column widths, Excel preserve format copying, Excel cells maintain dimensions, Excel VBA copy paste dimensions, Excel VBA preserve size, Excel copy partial sheet VBA, Excel sheet dimensions VBA, Excel macro row height column width, Excel multiple instance copy paste, Excel cell size automation