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

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


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=539174

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