I’ve had a number of requests to cover copying entire worksheets between files. The number one problem seems to be when the data is pasted into the new worksheet Excel doesn’t resize the column widths to fit the pasted data. Instead the columns seem to reset themselves back to the default width. Possibly the best way to avoid this happening is to use the Move and Copy command in Excel.
Moving and copying entire worksheets between workbooks (files)
In this tutorial you will learn how to quickly copy or move entire worksheets between workbooks.
It covers the Move and Copy command as well as copying and pasting an entire worksheet without the columns resizing.
Join the 'Excel at Work Insiders' group today!
100% free. Join now and unlock offers exclusive to this group!
Receive tips and guidance to help you SAVE TIME, WORK SMARTER and IMPROVE YOUR UNDERSTANDING of Microsoft® Office.
Also covers problems copying and pasting between the new Excel file format and the old file format and the error message “Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook”.
If you found this post helpful please ‘Like’ us!