Wed 18 Jul 2007
Another small problem that we here at LANcom encountered with Office 2007 had to do with the copying of cells in one Excel workbook into another. Previously we were able to use the Paste Special feature to ensure all formatting stayed the same when we pasted a selection of cells into a new workbook. When we tried to do this is 2007 we encountered a problem. In did not carry over the column changes.
For example here is how a table we create originally looked
And here is what a pasted version in the new Workbook looked like.
If you are having this problem and are finding manually adjusting the column widths to time consuming try this.
Copy the cells you would like in your new Workbook or new Sheet. Then in the new Workbook or Sheet click on the arrow below the Paste button on the Home ribbon and select Paste Special. Now select Column Widths (Selecting All does not carry over column widths, we tried this). Excel will now paste the column widths of the cells you previously copied. Now simply click Paste and the cells you have copied will appear as they did in the first Workbook or sheet.