copying sheets

[fastballfreddy]

I want to copy and paste a sheet into a new sheet, but I want to keep the settings the same, like the column width. Is this possible?

Thanks,

[Gazzr]

Hi there,

Right click on tab name (Sheet1)

Select "Move or Copy", select the location where you want the sheet to go. Tick the "Make a copy" button at the bottom and click OK

Everything should stay the same.

Thanks
Gazzr

[James Hamilton]

I think I know what you want....

On the sheet tab (eg "sheet 1"), right click, choose MOVE OR COPY, and go
from there.

"fastballfreddy" wrote:

>
> I want to copy and paste a sheet into a new sheet, but I want to keep
> the settings the same, like the column width. Is this possible?
>
> Thanks,
>
>
> --
> fastballfreddy
> ------------------------------------------------------------------------
> fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
> View this thread: http://www.excelforum.com/showthread...hreadid=539174
>
>