Copying All Cells in XL 2007

[BVass]

I am trying to copy an enitre worksheet to another worksheet in a new
workbook. In XL 2003 and prior all you had to do was highligh all the cells
by clicking top left corner then copy and go to the new workbook, select all
the celss via the same mtehod and paste. This would copy everything,
including the formats of the cells.

In XL 2007 it copies everything, except the formatting. How do I copy it so
the formatting comes across as well?

BVass

 

[Bernard Liengme]

Why copy/paste at all?
Hold SHIFT; drag the worksheet tab to left or tight; if it was Sheet 1 you
get Sheet1 (2) which is an exact copy of the original
best wishes

 

[BVass]

Bernard,

If you read correctly I wish to copy the worksheet to a new workbook. Doing
what you are suggesting copies it to the same workbook....so this is no hlep.

BVass

 

[Bob I]

Then r-click the tab and select Move or Copy to new book!

 

[Bernard Liengme]

Just use Windows Arrange and follow my directions
best wishes