Are you using Copy & Paste?
Here is a better way if you want the entire page;
1) Open the two files (Source and Target)
2) On the View tab use the Arrange All tool in the Window group to have the
two workbooks visible (horizontally works best)
3) Click the tab of the worksheet to be copied; hold the CTRL key; drag the
mouse to carry the tab to the Target file

What you get is an exact copy so the formatting is the same.

If you are making a copy of something called Sheet1, it might help to delete
Sheet1 from the Target workbook first; otherwise it will get called Sheet
1(2).

This method requires both file be either XL2007 or both be earlier versions.
You cannot drag a sheet with 1 million rows into an Excel 2003 workbook!

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"smich" wrote in message
...
I would like to keep column widths and formulas when copying a complete
sheet
to a new file (windows 2007)

Thanks for any help