How to retain column width and formulas in copying a sheet

[smich]

I would like to keep column widths and formulas when copying a complete sheet
to a new file (windows 2007)

Thanks for any help

 

[Bernard Liengme]

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

 

[smich]

Bernard,
Thanks for your help.

However I tried with Ctrl drag on the tab and it didn't work. I have two
screens so the two files are visible. I also tried putting them on the same
screen.

 

[smich]

Hi again, Bernard,
I did try it again within the same window and it did work. I guess what I
was hoping for was just the simple "copy/paste" routine with the paste
options box. But your methods works well.

Thanks